Does Numbers have any equivalent to Excel's Format Painter?

Does Numbers have any equivalent to Excel's Format Painter?

iMac 21.5″, macOS 10.15

Posted on Jul 13, 2020 11:14 PM

Reply
Question marked as Top-ranking reply

Posted on Jul 14, 2020 10:07 AM

hi paul,


This might be what you're looking for.



Numbers has a copy style and paste style that is, I believe, similar to format painter in Excel.



  • First select the cell to copy the style from and select format - copy style from the menu


  • Select the cell (or range of cells) to apply the style to then select format - paste style from the menu




-or-


Right click in the menu bar and select Customize Toolbar - drag the copy style and paste style to the menu bar. Numbers uses an eye dropper Icon as apposed to the Excel Paint Brush.



Just follow the same procedure as outlined above except click on the copy style, paste style icons instead.


-Tom

3 replies
Question marked as Top-ranking reply

Jul 14, 2020 10:07 AM in response to paulgc

hi paul,


This might be what you're looking for.



Numbers has a copy style and paste style that is, I believe, similar to format painter in Excel.



  • First select the cell to copy the style from and select format - copy style from the menu


  • Select the cell (or range of cells) to apply the style to then select format - paste style from the menu




-or-


Right click in the menu bar and select Customize Toolbar - drag the copy style and paste style to the menu bar. Numbers uses an eye dropper Icon as apposed to the Excel Paint Brush.



Just follow the same procedure as outlined above except click on the copy style, paste style icons instead.


-Tom

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.

Does Numbers have any equivalent to Excel's Format Painter?

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