Tables are the most common element used while creating an Excel document. A table has a few steps that will need to be taken to ensure its accessibility.
An example of a common table is shown below.
Excel has a tool to turn your tables into Formatted Tables. This means Excel recognizes that this is indeed a table and allows you to select options that will help define the information on the table.
To turn the table into a formatted table,
- Highlight your created table.
- Under the "Home" tab, Select Format as Table.
The dropdown presented will display color schemes for your table. Choosing a color scheme that alternates colors between rows in the table helps people with impaired vision to parse each data field.
3. Select your color scheme.
*Note the formatted table will create new header rows, you can choose to use this option or hide the row by.
1. Right clicking on the row number to the left and select "Hide".
Alt Text For Tables
Tables and charts need Alt Text the same way pictures do. To add alt text to your table.
- Right click on your table.
- Highlight "Table" (*Note: this option won't appear until you create your table as a formatted excel table shown above).
- Select "Alternative Text...".
- Type your description in the "Description" field.
Headers For Tables
Tables require a row for headers called, "Header Row". To ensure your table has a header row:
- Select your table.
- Click the "Table Tools/ Design" Tab.
- Make sure the "Header Row Box is checked.