LearnFast.Ninja

Format painter Excel 2010 example

How to copy formatting from one place and apply it to another place. Select the format you want to apply. Click Home then click Format Painter. Select the cells you want them to be with the same format. Note you can double click the Format Painter button and then you can apply the formatting to multiple places in the current document.

Step 1: Select the format you want to apply.


Step 2: Click Home > click Format Painter.


Step 3: Select the cells you want them to be with the same format.


Result:


Note: Double click Format Painter to apply the formatting to multiple places in the current document.


Tags

excel

excel-basics format painter