Microsoft Office Tutorials and References
In Depth Information
Verifying Formulas Using Range Finder
Cell Styles button
‘Increase
Font Size’
button
‘Decrease
Font Size’
button
HOME tab
‘Merge & Center’
button
font size of
worksheet
subtitle
decreased
title and
subtitle cells
merged
Figure 2 – 30
Which colors should you select when formatting your worksheet?
Knowing how people perceive colors helps you emphasize parts of your worksheet. Warmer colors (red and orange) tend to
reach toward the reader. Cooler colors (blue, green, and violet) tend to pull away from the reader. Bright colors jump out of a
dark background and are easiest to see. White or yellow text on a dark blue, green, purple, or black background is ideal.
To Change the Background Color and Apply
a Box Border to the Worksheet Title and Subtitle
1 ENTER FORMULAS | 2 ENTER FUNCTIONS | 3 VERIFY FORMULAS
4 FORMAT WORKSHEET | 5 CHECK SPELLING | 6 PRINT WORKSHEET
Why? A background color and border can draw attention to the title of a worksheet. The nail formats assigned
to the worksheet title and subtitle are the green background color and thick box border (Figure 2 – 27b on
page EX 90). The following steps complete the formatting of the worksheet titles.
1
Select the range
A1:A2 and then
tap or click the
Fill Color arrow
(HOME tab | Font
group) to display
the Fill Color gallery
(Figure 2 – 31).
Fill Color arrow
desired background
color
Fill Color gallery
Experiment
Point to a number
of colors in the Fill
Color gallery to
display a live preview
of the color in the
range A1:A2.
Figure 2 – 31
 
Search JabSto ::




Custom Search