Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
3
With the mouse
pointer still a block
plus sign with a
paintbrush, drag
through the range
A25:I25 to assign the
format of the source
cell, A13 in this case,
to the destination
range, A25:I25 in
this case.
to stop the format
painter.
Press the ESC key
format copied to range
A25:H25 and Currency
style applied to range
B25:I25
Apply the Currency
style to the range
B25:H25 to cause the
cells in the range
to appear with a
l oating dollar sign
and two decimal
places and then scroll
the worksheet so that
column A is displayed (Figure 3 – 49).
Figure 3 – 49
Other Ways
1. Click Copy button
(Home tab | Clipboard
group), select cell, click
Paste button arrow
(Home tab | Clipboard
group), click Formatting
icon on Paste gallery
2. Right-click cell, click
Copy, right-click cell,
click Formatting icon on
shortcut menu
Why does the Currency style need to be reapplied to the range B25:H25?
Sometimes, the use of the format painter results in unintended outcomes. In this case, the
changing of the background i ll color and font color for the range B25:H25 resulted in the
loss of the Currency style because the format being copied did not included the Currency
style. Reapplying the Currency style to the range results in the proper number style, i ll color,
and font color.
To Format the What-If Assumptions Table
and Save the Workbook
Painting a Format to
Nonadjacent Ranges
Double-click the Format
Painter button (Home tab
| Clipboard group) and
then drag through the
nonadjacent ranges to
paint the formats to the
ranges. Click the Format
Painter button (Home
tab | Clipboard group) to
deactivate it.
The last step to improving the appearance of the worksheet is to format the
What-If Assumptions table in the range A1:B8. The specii cations in Figure 3 – 40 on page
EX 173 require an 8-point italic underlined font for the title in cell A1 and 8-point font in
the range A2:B8. The following steps format the What-If Assumptions table.
1
Press CTRL + HOME to select cell A1.
2
Click the Font Size button arrow (Home tab | Font group) and then click 8 in the Font Size
list to decrease the font size of the selected cell.
3
Click the Italic button (Home tab | Font Group) and then click the Underline button
(Home tab | Font group) to italicize and underline the text in the selected cell.
4
Select the range A2:B8, click the Font Size button arrow (Home tab | Font group) and
then click 8 in the Font Size list to apply a smaller font size to the selected range.
5
Select the range A1:B8 and then click the Fill Color button (Home tab | Font group) to
apply the most recently used background color to the selected range.
 
Search JabSto ::




Custom Search