Copying Formatting

Often it is beneficial to copy formatting from one place in your spreadsheet to another. Excel provides a shortcut for doing this:

1. Select the cell that contains the formatting you want to copy.
2. Click once on the Format Painter tool on the toolbar. (This tool has a small paintbrush on it.)
3. Select the cell or range of cells that you want to have the same formatting as the cell you selected in step 1.

If you want to copy formatting to more than one location, then you can double-click on the Format Painter tool in step 2. When you are done copying, simply press Esc to indicate you are done.