Turning Headers On and Off

You already know that the headers in a worksheet come in handy. This is the gray area, at the left and top of a worksheet, which indicates the row and column label used by Excel. You click in the header area if you want to select either a row or header. You also know that you can adjust the height or width or rows or columns by using the row and column header area.

Even though this area is very useful, there may be times when you do not want it displayed. For instance, if you are using Excel to create an on-screen form, then the header areas may be distracting to the intended users of the form.

To control whether headers are turned on or off, follow these steps:

1. Display the Excel Options dialogue box. In Excel 2010 or a later version, display the File tab of the ribbon and then click Options.)
2. At the left of the dialogue box, click Advanced.
3. Scroll through the available options until you see the Display Options for this Worksheet section.
4. Make sure the Show Row and Column Headers checkbox is selected. If cleared, then the header area is not displayed.
5. Click on OK.

As with other tasks in Excel, there are additional methods that accomplish the same result, as shown above. These methods use various tabs of the ribbon. One method is to display the Page Layout tab of the ribbon, then clear the View checkbox under Headings in the Sheet Options group. Another method is to display the View tab of the ribbon and clear the Headings checkbox in the Show group.

Notice that Excel does not allow you to control the display of row and column headers individually—they are either both on or both off.

Alan Salmon