Table Formatting
Table Formatting
Specify Row and Column Headings
- Have Table Tools been checked to ensure proper row and column elements are marked?
How?
- Highlight the cells to be included in the table.
- On the Insert tab, in the Tables group, click Table.
- Select the My table has headers check box.
- Click OK.
Why is this important?
Clear column headings provide context and assist in navigation of information in the table.
Resources
- Add Headers to a New Table
- Use Headers in an Existing Table
- Create More Accessible Tables in Excel Training Video
Keep Tables Simple and Straightforward
- Have merged or split cells been avoided?
- Have complex tables been separated into smaller tables?
How?
Split the table into smaller tables within the same worksheet or separate into different worksheets with labeled sheet tabs.
Why is this important?
Screen readers announce column and header rows. Merged or split cells may not be properly conveyed by the screen reader. Tables that are nested are difficult for a screen reader to interpret.
Resources
Include Table Data with Any Data Visuals
- Is the data table provided for any charts or graphs?
How?
Provide descriptive text immediately after the chart or graph.