Microsoft Office Tutorials and References
In Depth Information
Copying a Cell’s Format Using the Format Painter Button
Using the Format Painter button on the Ribbon, you can format a cell quickly by copying
a cell’s format to another cell or a range of cells.
The following steps format cells A6, A14, and the range A16:H16 using the Format Painter button.
• Select cell A4.
• Click the Format Painter button
on the Ribbon and then move the
mouse pointer onto the worksheet
to cause the mouse pointer to
change to a block plus sign with a
paintbrush (Figure 3–44).
block plus sign