Christmas is all around. Perhaps you are busy with decorating your Christmas tree with lots of joy.
However it’s no joy to decorate your Excel worksheets in your daily work. It could be really time-consuming to apply the same set formats (note the “s”) into different tables. What a repetitive and boring task! If you have this feeling, there is a high chance that you do not know Format Painter, which is a very good assistance in Excel. :)
How many formats does it contain? Font size: 16 Bold Italic, Font Type: Comic Sans MS, Border: Solid, Outline… but not sure what color it is… OK. Let’s not take the color of the border into consideration for the moment. If you need to apply this format to another cell, how many clicks are required? TEN Clicks at least!!!!
With Format Painter, it takes you only three clicks!
This simple tool is one of my favorite assistances that helps apply consistent formats across different sections quickly.
Many users are disappointed that the Format Painter can only apply once. Once the format is applied, the Format Painter is gone. Then you have to click on the Format Painter again if you want to apply the same format to many different cells. It’s just another repetitive and boring task… Wait… have your ever hovered your mouse on the Format Painter and read the pop-up hint?
See!? If you wish to apply the format to multiples places, just double-click it so that you may apply the same format to different areas. When you are done, press ESC.
Extra Hint: How to apply color band to alternative rows
p.s. this can be easily done with Table (available in Excel 2007 or above)
Final step: Practice!