Microsoft Office Tutorials and References
In Depth Information
Adding Cell Borders
4. Click the merged cell A17 to select it, and then repeat Steps 1 through 3 to rotate
and align the text.
5. Reduce the width of column A to characters. See Figure 2-16. 5
Rotated cell text
column A is five
rotated label takes
up less space in
the merged cell
Adding Cell Borders
When a worksheet is printed, the gridlines that surround the cells are not printed by
default. They only appear on the worksheet as a guide. Sometimes you want to include
lines along the edges of cells to enhance the readability of the rows and columns of
data. One way to do this is by adding a border to a cell or range. You can add borders
to the left, top, right, or bottom of a cell or range; around an entire cell; or around the
outside edges of a range. You can also specify the thickness of and the number of lines in
Tom wants you to add borders to the column titles and Total rows. Standard
accounting practice is to add a single top border and a double bottom border to the Total rows to
clearly differentiate them from ﬁ nancial data.
You set the gridlines or
the row and column
headings to print by clicking
the appropriate Print
check box in the Sheet
Options group on the
Page Layout tab.
To add cell borders to the column labels and Total rows:
1. Select the nonadjacent range B6:F6;B17:F17 . You’ll add a bottom border to these
2. In the Font group on the Home tab, click the Border button arrow , and
then click Bottom Border . A border is added to the bottom of the selected cells.
3. Select the nonadjacent range B15:F15;B26:F26 . You’ll add top and bottom
borders to these Total rows.
4. In the Font group, click the Border button arrow , and then click Top and
Double Bottom Border . The Total rows both have a single top border and a
double bottom border, following standard accounting practice.
5. Click cell to deselect the range. See Figure 2-17. A5