Microsoft Office Tutorials and References
In Depth Information
Verifying Formulas Using Range Finder
2
Tap or click Basis in
the Themes gallery
to change the
workbook theme
(Figure 2 – 29).
font of worksheet
cells reects theme’s
default font
Why did the cells
in the worksheet
change?
The cells in the
worksheet originally
were formatted with
the default font for
the default office
theme. The default
font for the Basis
theme is different
from that of the
default font for the
office theme and,
therefore, changed
on the worksheet
when you changed
the theme. If you had
modied the font for any of the cells, those cells would
not be formatted with the default font for the Basis theme.
Figure 2 – 29
To Format the Worksheet Titles
The following steps merge and center the worksheet titles, apply the Title cells
style to the worksheet titles, and decrease the font of the worksheet subtitle.
1
Display the HOME tab.
2
Select the range to be merged, A1:J1 in this case, and then tap or click the ‘Merge &
Center’ button (HOME tab | Alignment group) to merge and center the text in the
selected range.
3
Select the range A2:J2 and then tap or click the ‘Merge & Center’ button (HOME tab |
Alignment group) to merge and center the text in the selected range.
4
Select the range to contain the Title cell style, in this case A1:A2, tap or click the Cell
Styles button (HOME tab | Styles group) to display the Cell Styles gallery, and then tap
or click the Title cell style in the Cell Styles gallery to apply the Title cell style to the
selected range.
5
Select cell A2 and then tap or click the ‘Decrease Font Size’ button (HOME tab | Font
group) to decrease the font size of the selected cell to the next lowest font size
(Figure 2 – 30).
What is the effect of tapping or clicking the ‘Decrease Font Size’ button?
When you tap or click the ‘Decrease Font Size’ button, Excel assigns the next lowest font
size in the Font Size gallery to the selected range. The ‘Increase Font Size’ button works
in a similar manner, but causes Excel to assign the next highest font size in the Font Size
gallery to the selected range.
 
Search JabSto ::




Custom Search