Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
• Repeat Steps 1 and 2
to merge and center
subtitle across cells
A2 through N2
(Figure 1– 42).
Are cells B1 through
N1 and B2 through
N2 lost forever?
No. The opposite
of merging cells is
splitting a merged cell.
After you have merged multiple cells to create one merged cell, you can unmerge, or split, the merged cell to
display the original cells on the worksheet. You split a merged cell by selecting it and tapping or clicking the
‘Merge & Center’ button. For example, if you tap or click the ‘Merge & Center’ button a second time in Step 2,
it will split the merged cell A1 into cells A1, B1, C1, D1, E1, F1, G1, H1, I1, J1, K1, L1, M1, and N1.
Figure 1– 42
1. If you are using a mouse, right-click selection, click
‘Merge & Center’ button on mini toolbar
2. Tap ‘Show Context Menu’ button on mini toolbar or right-click selected cell, tap or
click Format Cells on shortcut menu, tap or click Alignment tab (Format Cells dialog
box), select ‘Center Across Selection’ in Horizontal list, tap or click OK button
1 ENTER TEXT | 2 CALCULATE SUMS & USE FORMULAS | 3 SAVE WORKBOOK | 4 FORMAT TEXT
5 INSERT CHART | 6 NAME TAB | 7 PREVIEW & PRINT WORKSHEET
To Format Rows Using Cell Styles
The next step to format the worksheet is to format the rows. Why? Row titles and the total row should be
formatted so that anyone who views the worksheet can distinguish quickly the column titles and total row from the data in
the body of the worksheet. Data rows can be formatted to make them easier to read, as well. The following steps format
the column titles and total row using cell styles in the default worksheet theme.
• Tap or click cell A3 and then drag to cell N3 to select the range.
• Tap or click the Cell Styles button (HOME tab | Styles group) to display the Cell Styles gallery.
• If you are using a mouse, point to the Heading 1 cell style in the Titles and Headings area of the Cell Styles gallery
to see a live preview of the cell style in the selected range (Figure 1– 43).
• If you are using a mouse, point to other cell styles in the Titles and Headings area of the Cell Styles gallery to see a
live preview of other cell styles in the selected range, A3:N3.
of cell style
Heading 1 cell style
Figure 1– 43