Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
To Center Cell Entries across Columns
by Merging Cells
1 ENTER TEXT | 2 CALCULATE SUMS & USE FORMULAS | 3 SAVE WORKBOOK | 4 FORMAT TEXT
5 INSERT CHART | 6 NAME TAB | 7 PREVIEW & PRINT WORKSHEET
The nail step in formatting the worksheet title and subtitle is to center them across columns A through N.
Why? Centering a title across the columns used in the body of the worksheet improves the worksheet’s appearance. To do
this, the 14 cells in the range A1:N1 are combined, or merged, into a single cell that is the width of the columns
in the body of the worksheet. The 14 cells in the range A2:N2 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 if you are using
a touch screen, drag
the selection handles
as necessary to cell N1;
if you are using a
mouse, drag to cell
N1 to highlight the
range to be merged
and centered
(Figure 1– 40).
range A1:N1
selected for
merging
What if a cell in
the range B1:N1
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.
Figure 1– 40
2
Tap or click the
‘Merge & Center’
button (HOME tab |
Alignment group)
to merge cells A1
through N1 and
center the contents
of the leftmost
cell across the
selected columns
(Figure 1– 41).
‘Merge & Center’ button
(touch screens may not
have a separate ‘Merge &
Center’ button and
‘Merge & Center’ arrow)
range merged
and centered
in one cell, A1
What if my screen
displays a Merge &
Center menu?
If you are using a
touch screen, you
may not have a
separate ‘Merge &
Center’ button and ‘Merge & Center’ arrow. In this case,
select the desired option on the Merge & Center menu.
Figure 1– 41
What happened to cells B1 through N1?
After the merge, cells B1 through N1 no longer exist.
The new cell A1 now extends across columns A through N.
 
Search JabSto ::




Custom Search