Microsoft Excel X for Mac OS X: Visual QuickStart Guide

The Format Painter

The Format Painter lets you copy cell formatting and apply it to other cells. This can help you format worksheets quickly and consistently.

To use the Format Painter

1.	Select a cell with the formatting you want to copy.
2.	Click the Format Painter button on the Standard toolbar. The mouse pointer turns into a little plus sign with a paintbrush beside it and a marquee appears around the original selection (Figure 56). Figure 56. When you click the Format Painter button, a marquee appears around the original selection and the mouse pointer turns into the Format Painter pointer.
3.	Use the Format Painter pointer to select the cells ...