Excel: Creating Table Headers Using a Title Region

Overview

A title region connects row and column headers to all table cells, allowing screen readers to announce header information with cell data.

Considerations

• Proper title regions can only be verified using a screen reader (e.g., JAWS).

• Especially important for large spreadsheets.

Steps

1. Select the upper-left cell of the table.

2. Go to Formulas > Name Manager and select New.

3. Enter TitleRegion1 (no spaces, capital T and R).

4. Add a period and the first cell reference (e.g., .A4).

5. Add another period and the last cell reference (e.g., .F54).

6. Add a final period and the sheet number (e.g., .1).

7. Press OK.