Formatting Row and Column Headings

In addition to formatting worksheet cells, you can format many aspects of row and column headings. Worksheet headings comprise three areas: the row headings, column headings, and the box in the top left corner of the worksheet where the row and column headings intersect.

Sizing Row and Column Headings

You can set the size of row and column headings and the top left corner.

To change the height of column headings:

• Click and drag the bottom edge of the top left corner.

To change the width of row headings:

• Click and drag the right edge of the top left corner.

  

Setting Row and Column Heading Text

Like other column and row heading attributes, the text displayed in headings cells can be changed.

To change the text for a row or column heading:

1. Double-click the heading you want to change. The Header Text dialog appears, as shown below.

   

2. Enter one or more lines of text to serve as the heading name.
3. Click OK.

The heading text is displayed, as shown below.