Tables in Excel need to be identified as such by ‘marking them up’. This means code is added to the tables in the background to help software recognise them as such and understand the content. You will almost always need to mark up tables in your Excel files as they will contain your data sets.
To mark up data in Excel as a table:
To specify the first column and header row in an existing table:
All tables should have one named header (top) row. All columns must have text in the header row (or Excel will give any columns that don’t a default name when they are identified as part of a table). In addition, header names must be unique – a table can’t have two columns with the same text in the header row.
To define named regions for cell ranges:
Filters and freeze panes are usually used to assist with viewing sheets with large data sets. However, these viewing options obscure data and can make page navigation difficult.
If you do need to use filters or freeze panes, inform users, and give instructions on how to turn them off.
Worksheets affect how users will access and understand your content. Some tips include:
Creating data sets appropriately is important in ensuring users can access and navigate your content effectively. Some tips include:
Cells that do not contain any data can be a barrier for assistive technology users to understand where the table starts and ends.
If the following points are met, blank cells should not cause accessibility issues:
Ensure to wrap text within cells. This will make the text in cells visible and clearly spaced out.
ScreenTips are small containers of descriptive text that appear when you hover your cursor over an element – this can include buttons, commands, images, or hyperlinks. ScreenTips can give additional information about elements, which can help users scan content more easily and quickly.
To add ScreenTips: