Microsoft Office Tutorials and References
In Depth Information
Copying a Cell’s Format Using the Format Painter Button
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.
To Copy a Cell’s Format Using the Format Painter Button
The following steps format cells A6, A14, and the range A16:H16 using the Format Painter button.
1
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).
Format Painter
button
block plus sign
with paintbrush
mouse pointer
cell A4
selected
marquee is
displayed around
cell A4
Figure 3–44
 
 
Search JabSto ::




Custom Search