Microsoft Office Tutorials and References
In Depth Information
To Center Cell Entries across Columns by Merging Cells
• Click Dark Blue, Text 2 (column 4,
row 1) on the Font Color palette to
change the font of the worksheet
subtitle in cell A2 from black to
dark blue (Figure 1–57).
Why does the Font Color button
change after I select the new
When you choose a color on the
Font Color palette, Excel changes
the Font Color button on the
Formatting toolbar to the chosen
color. Thus, to change the font
color of the cell entry in another
cell to the same color, you need
only to select the cell and then click the
Font Color button.
Font Color button
changes to reﬂ ect
font color in
active cell A2
is dark blue
1. Select font color from Font
Color list on Mini toolbar
2. Right-click cell, click Format
Cells on shortcut menu,
click Font tab, select color
on Font Color palette, click
The ﬁ nal step in formatting the worksheet title and subtitle is to center them across columns A through
G. Centering a title across the columns used in the body of the worksheet improves the worksheet’s appearance.
To do this, the seven cells in the range A1:G1 are combined, or merged, into a single cell that is the width of the
columns in the body of the worksheet. The seven cells in the range A2:G2 also 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.
• Select cell A1 and then drag to cell
G1 to highlight the range A1:G1
What if a cell in the range B1:G1
For the Merge & Center button to
work properly, all the cells except
the leftmost cell in the selected
range must be empty.