A feature that I use so often I almost take it for granted, is the Format Painter, which allows me to quickly copy formatting from one thing in a document to another.
The Format Painter tool appears under the HOME tab in most of the Microsoft Office programs. In Outlook it appears in the MESSAGE tab. It looks like a little paint brush.
Sometimes all you want to do is make the formatting of one thing match another. I have several practical applications for this. Most notably, any time you copy something from one program to another.
As much as Microsoft likes to think that formatting is the same across the board, it’s mistaken. Copying information from Word to OneNote or from OneNote to Outlook, I always end up having to update the formatting. Using Format Painter lets me do that very quickly.
To use the Format Painter tool, select a part of the document (the in case of Excel, the cells) that contain the formatting you want.
Click the Format Painter tool, and then select the part of the document (or cells) that need this formatting. Voilà!
BONUS TIP: If you double-click on the Format Painter icon, it will maintain the formatting copy function which allows you to paste the formatting to multiple locations within the document.