Copy format

How do you copy the format of one cell to another? (Text color, fill color, etc.)


http://support.apple.com/kb/PH3397?viewlocale=en_US has directions at the bottom. It says to select a range of text, then tap Style, then tap Copy Style.


But I cannot find "Style" to tap. I can't find it anywhere. I thought maybe they meant the paintbrush tool, which is where formatting stuff is found, but I can't find "Copy Style" on there anywhere.


Can someone please give me more precise directions on how to copy and paste one cell's formatting to another cell?


(Latest/current versions of Numbers and iOS 6.)

Posted on Oct 19, 2012 7:40 PM

Reply
6 replies

Oct 20, 2012 10:16 AM in response to Justin J. Rebbert

I don't use the iOS version of numbers much, and not for this sort of thing, but since no one is jumping in, I'll try a few suggestions.


The instructions you quote are for a range of text, not a range of cells; do you have the text selected, or just the cell? To apply, I expect you would also have to select text, not a cell. I don't know that you can copy and paste cell styling in iOS Numbers. You probably have to do that in the full version of Numbers, on a real computer.

Oct 21, 2012 6:07 AM in response to Justin J. Rebbert

If you select some styled text in a text box or in a shape, these options come up, so these instructions do apply to iOS Numbers, for text boxes and shapes containing text. They do not, however, work for text in a cell.


In fact, if you copy styled text from a text box and paste it into a cell, the styling will be stripped. Some text styling is stripped on importing from the desktop version to the iOS version as well. So, apparently, the iOS version has much more limited support for text styling features in tables compared to the desktop version.


If you copy the whole cell with the styling you want, and paste it into the cell to which you want to apply that styling, it will bring its styling with it. You can then overwrite the content of the cell with new content which will still have the desired styling. This is obviously less than optimal if you have already entered the information into that cell.


If you have a number of cell ranges in your table (which may already contain data) that you want to have all styled the same, but you don't want to apply the styling to each range individually, one possible work-around would be:

  • Add enough blank columns (or rows) to the table to accommodate all those ranges (i.e., double its size)
  • Select and drag each range into the blank area
  • Select a range including all the moved cells and apply the styling once, to all of them
  • Move each range back to its original place
  • Delete the extra columns

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Copy format

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.