Format Painter in Excel
Most people who know about Format Painter think of it in relation to Microsoft Word. They don’t realise that there is a Format Painter option in Microsoft Excel as well. Not only that, it exists whether you are using Excel on Windows or Mac. The video tutorial below shows you how to use it in Windows, but it works exactly the same on Mac and it works in all versions.
Use Format Painter in Excel 2010 to copy formats from one place to another. Simply select the cell whose formatting you wish to copy, click the Format Painter Icon and then click on the cell where you want the format to appear. The video tutorial will show you how to do this.
To help your staff become more efficient and save time give us a call on 020 8203 1774 and one of our lovely trainers will be delighted to come in.