If you need to quickly copy formatting from one cell to another, the Format Painter tool in Excel is a gift. You can use it to copy formatting once or multiple times. This video shows you how. For example, if you have formatted a spreadsheet on Monday but can’t remember what you did on Friday…using the Format Painter tool will save you a lot of work.  View the tutorial below and as always there is a file to practise on.

 

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/format_painter.m4v’]

 

 

Here is the file you can practise on. Copy the yellow formatting onto some of the other cells.