Lock Copy Formatting

If  you need to apply the same formatting to a number of different cells, you can do so quickly by locking the Copy Formatting tool.

Apply the formatting options that you want to the first cell – for instance, bold red centrally aligned text with a yellow background. Select this cell and double-click the 'Format Painter' button in the Clipboard group of the Home tab.

This is now locked on. Any cell that you click into will take on the formatting of the source cell. Click each cell you want to format in this way and then double-click the 'Format Painter' button to turn the lock off.

Work Smart!!! ;)