Format Painter in Numbers - does this exist?

Hi,

If you customize the toolbar in Numbers (right click on it or use the View Menu option) you get the chance to add "Copy Style" and "Paste Style" buttons.

You can apply them over a range. Copy the style, select the range and then click the Paste Style button.

There isn't an exact duplicate of this function, but there is a format copy. It is in most Apple product like snumbers and pages and Keynote. Select tha item, then under the format menu, use copy style. Select the final location, and use Paste Style. This only works for single cells right now, I can't get a range to do it.
There are keyboard shortcuts so you cna do it over and over again. I used it in Pages all the time.

Jason

If we are hoping that Apple will read this and take note, I would like to add emphasis to the part about copying the value in one cell and pasting it into a range of cells. It can't be done. You must paste and click and paste and click and paste and click and paste and click and paste and click and .....

Likewise, the Edit->Fill command doesn't seem to exist.

Let's say you have a series of numbers in column B and you want to put the word Detroit beside some of them in column A, Chicago beside others, and Cleveland beside others, so that your next step would be to sort by city and produce substotals, for example. Where contiguous cells exist with the same desired value, you ought to be able to select the range and paste. With any date or number-sensitive cell, you get arithmetic progressions, which is handy when you want it but not when you don't.

Or let's say you simply want to fill all of column A, or a range within column A with something that is not a progressive value. Can't do it.

Hi Dennis,

You can copy into a range of cells, so long as they are contiguous. If you type a value into the first cell and then grab the lower right corner (which appears as a hollow circle) of the cell and drag it either across or downwards, then the value will be copied into the new cells.

Thanks Jason, lets hope Apple staff read this stuff and will either give a paint brush, or ability to do it over a range. GT