Excel 2007's Format Painter

Copy formatting with the format painter

Formatting Spreadsheets using Format Painter

Adding formatting to your spreadsheet not only makes it more attractive and easier to read, but it can make it easier for users to find the information they are after.

To quickly copy formatting from one part of a sheet to another, or to another sheet in the same workbook, use the Format Painter.

Format Painter is very useful when you are extending a spreadsheet to accommodate new data and need to format the new cells to match the original data area.

To use Format Painter to copy formatting options to a second cell

1. Add all the formatting options you want to use to the first cell.
2. Click on that cell with the mouse pointer to make it the active cell.
3. Click on the Home tab.
4. Click on the Format Painter icon on the ribbon.
5. Clicking on a second cell will copy the formats from the active cell to this second cell.

To use Format Painter to copy formatting options to 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. Click on the Home tab.
4. Click on the Format Painter icon on the ribbon.
5. Drag select to highlight the destination cells. Doing so will copy the formats from the active cell to the destination cells
.

To use 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. Click on the Home tab.
4. Double click on the Format Painter icon on the ribbon.
5. Click on a second cell to copy the formats from the active cell to this second cell.
6. Continue clicking on additional cells to copy the formatting to these cells as well.
7. Click on the Format Painter icon on the ribbon once again to turn it off.