Microsoft Office Tutorials and References
In Depth Information
EX 202
Excel Chapter 3 What-If Analysis, Charting, and Working with Large Worksheets
2
Click cell A6 to assign the format
of cell A4 to cell A6 (Figure 3–45).
format of cell A4
copied to cell A6
Figure 3–45
3
With cell A6 selected, click the
Format Painter button on the
Ribbon and then click cell A14.
With cell A14 selected, click the
Format Painter button on the
Ribbon and then click cell A16.
Select the range B16:H16, click the
Fill Color button on the Ribbon, and
then click the Orange, Accent 1 color
(column 5, row 1) on the Fill Color
palette.
Click the Font Color button on
the Ribbon, and then click the
Background 1 color (column 1,
row 1) on the Font Color palette
(Figure 3–46).
format copied
to cell A14 and
range A16:H16
Apply the Currency style to the
range B16:G16.
Figure 3–46
Other Ways
1. Click Copy button, select
cell, click Paste button, click
Paste Special command on
Paste menu, click Formats,
click OK button
2. Double-click Format Painter
button
Search JabSto ::




Custom Search