MS Excel Secrets - Format Painter

Using Format Painter to copy formatting options to one cell:Add all the formatting options you want to use to at least one cell.

1. Click on that cell with the mouse pointer to make it the active cell.
2. Click on the Format Painter icon on the formatting tool bar.
3. Click on the cell that you want to copy the formatting to.

Read lots more MS Excel Secrets

Using Format Painter to copy formatting options to adjacent cells:

• Add all the formatting options you want to use to at least one cell.
• Click on that cell with the mouse pointer to make it the active cell.
• Click on the Format Painter icon on the formatting tool bar.
• Click on the first cell and then drag the mouse pointer to select additional cells.

Using Painter Format Painter to copy formatting options to non-adjacent cells:

1. Add all the formatting options you want to use to at least one cell.
2. Click on that cell with the mouse pointer to make it the active cell.
3. Double click on the Format Painter icon on the formatting tool bar.
4. Click on the first cell you want to copy the formatting to and then continue clicking on additional cells to copy the formatting to these cells as well.
5. Click on the Format Painter icon on the formatting tool bar to turn it off.

Related Posts:
How to Convert PowerPoint to Flash Flipbook