Excel: Format Painter

Easily replicate your preferred cell formats

You have formatted one section of your data to your satisfaction:

Instead of having to go through each of the different formatting pieces to replicate the changes made to the data in the first column (font, number format, fill, some bold), use the “Format Painter” and apply all the formatting from the selected section to the other sections you’d like to appear the same:

Note too, that if the areas where you’d like to apply your formatting aren’t side by side, you can double click on the “Format Painter” tool and it will lock in that format to be pasted everywhere you click until you click again on the “Format Painter” tool (or hit Escape) to release it.

A nice shortcut to save you clicks!

Looking For More?


Silicon Valley Accounting Solutions produces the Solution of the Week in order to share tips and shortcuts that promote process efficiency and highlight software features that may not be in your current toolbox. Please let us know if you have questions on how to accomplish a particular task or if you simply have a comment to share.

Even if you find that you know most of what you see here, it only takes one “Aha” to make regular visits worthwhile. To avoid missing any solutions, you may subscribe and have a new one delivered to your inbox each week.

Contact Us

We want to help you grow
your business, call us
at: (408) 260-5250 or
find out more here.


When you need:
  • Clear processes for cash controls
  • Analysis of results
  • Customized reporting


When you need:
  • Timely and accurate bookkeeping
  • Reconciliations and monthly closes
  • Familiarity with popular accounting software
Web Analytics