Use a screen reader to create column headers in a table in Excel

When you create a table in an Excel worksheet, Excel automatically adds and displays table headers. Table headers either display their default names (you can change these directly in the worksheet), or you can specify that they display the header data that is in your worksheet.

In a long table, table headers replace the worksheet column headings so that they stay visible when you move through the table data. Table headers should not be confused with worksheet column headings or the headers for printed pages.

Notes: 

Add column headers to a table

  1. Place focus anywhere in the table.

  2. Press ALT+J, T. You hear, “Upper Ribbon. Design tab. To change ribbons use Left or Right Arrows. To navigate the current Ribbon, use Tab or Shift Tab. Alt followed by Y, J,T.”

  3. Press the Tab key until you hear one of the following:

    • “Table Style Options group box. Header row box checked.”

    • “Header row box not checked.”

    Press Enter to check the box and return focus to the table.

More information

Use a screen reader to insert a table in an Excel 2016 worksheet

Get help for using a screen reader with Excel 2016

Keyboard shortcuts in Excel 2016 for Windows

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×