Copy and paste cell format only?

Question

Level 1

39 points

Is there a way to copy cell 'style' and paste it into another cell?

In Excel there's a paintbrush tool that allows copying styles, but I don't see any way to do this in Numbers.

I'm working with several different currencies and it's time-consuming to keep using pull-down menus for cell/data format/currency/GBP etc.

MacBook Air, OS X Mountain Lion (10.8.5)

Posted on Jan 13, 2014 11:58 AM

Reply

Answer 1

Top-ranking reply

Level 8

37,568 points

Hi SaltSeaShark,

If you are using Numbers 3 you can copy and paste styles this way:

Click cell with style you want to copy style from and choose Format > Copy Style from the menu (or type option-command-c).
Click target cell(s) you want to copy the style to and choose Format > Paste Style from the menu (or type option-command-v).

This has a similar effect to the paintbrush tool in Excel.

SG

Reply

Answer 2

Level 1

39 points

thanks, that could be useful,

but no 'copy & paste'?

Reply

Answer 3

you can command click to add/remove cells from a selection then apply a single format action to the selected cells.

Before formatting.... a non-contiguous selection:

Formatted in single action:

Reply