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!