Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
To Center Cell Entries Across Columns by Merging Cells
The i nal step in formatting the worksheet title and subtitle is to center them across columns A through H.
Centering a title across the columns used in the body of the worksheet improves the worksheet’s appearance. To do
this, the eight cells in the range A1:H1 are combined, or merged, into a single cell that is the width of the columns
in the body of the worksheet. The eight cells in the range A2:H2 are merged in a similar manner. Merging cells
involves creating a single cell by combining two or more selected cells. The following steps center the worksheet
title and subtitle across columns by merging cells.
1
Select cell A1 and
then drag to cell H1
to highlight the range
to be merged and
centered (Figure 1– 38).
A1 is active cell
What if a cell in the
range B1:H1 contains
data?
For the Merge &
Center button (Home
tab | Alignment
group) to work
properly, all the cells
except the leftmost
cell in the selected
range must be empty.
range A1:H1
selected
Figure 1–38
Merge & Center
button
formats assigned
to active cell A1
2
Home tab
Click the Merge &
Center button (Home
tab | Alignment
group) to merge cells
A1 through H1 and
center the contents of
the leftmost cell across
the selected columns
(Figure 1– 39).
What happened to
cells B1 through H1?
After the merge, cells
B1 through H1 no
longer exist. The new
cell A1 now extends
across columns A
through H.
A1 is active cell
Alignment group
cells A1 through
H1 merged to
create new cell A1
heavy border indicates
new dimensions of
cell A1
entry in cell A1
centered across
columns A through H
Figure 1–39
 
Search JabSto ::




Custom Search