How to Use Format Painter in Excel for Multiple Cells
A post from our Microsoft Software blog
Written by Jordan James
Sometimes multiple format changes are required in Excel on various locations and sheets within a Workbook, this can be time consuming and ineffective. Excel can provide a more efficient way of doing this for you.
[ Video tutorial produced by Activia Training and purchased by ZandaX ]
Format Painter is a very powerful and efficient method of copying formats from one cell to another and ensuring that documents and spreadsheets have uniform formatting.
Select the cell with the correct formatting that you want to copy over and click on Format Painter in the Home Ribbon. Your mouse cursor will now have a paint brush next to it and the original cell has a dotted border to identify which cell's formatting has been copied. Click on the cell that you want to copy the formatting to and the formatting will be applied and the Format Painter will be deactivated.
We can double click on the Format Painter option if you need to copy it to multiple cells. Once you have formatted all the cells required you will need to click on the Format Painter icon again to deactivate it.
In the example below, cell A2 contains the correct formatting that we would like to have applied to other cells. By clicking on cell A2 and then double clicking the Format Painter tool, we can then single click on multiple cells to apply the required formatting to them.
We can also use this to copy formatting such as Data Validation and Conditional Formatting but it will not copy data content or formulas.
Want Better Excel Skills?
We have online courses with full 12-months' access. RRP from $49 limited time offer just $12.00
Get a solid foundation in Project software to create solid, resilient project plans.
You don't need prior experience with Project: just be able to use a PC with Microsoft Windows.
Microsoft Project Advanced
The Advanced course takes you to a level that will put you in complete control of your projects.
You should, of course, be fully conversant with the skills and concepts taught in the Introduction course.
Become a Visio master with our two intensive but very easy-to-follow CPD certified Microsoft Visio courses.