Include alternative text with all visuals and tables.
Visual content includes pictures, clip art, SmartArt graphics, shapes, groups, charts, embedded objects, ink, and videos.
To find all instances of missing alternative text in the spreadsheet, use the Accessibility Checker.
Alt text helps people who can’t see the screen to understand what’s important in images and other visuals.
Avoid using text in images as the sole method of conveying important information. If you must use an image with text in it, repeat that text in the document. In alt text, briefly describe the image and mention the existence of the text and its intent.
Add alt text to images
Add alt text to SmartArt graphics
Add alt text to shapes
Add alt text to PivotCharts
Add alt text to tables
Add meaningful hyperlink text and ScreenTips.
To determine whether hyperlink text makes sense as standalone information and whether it gives readers accurate information about the destination target, visually scan the sheets in your workbook.
People who use screen readers sometimes scan a list of links. Links should convey clear and accurate information about the destination. For example, instead of linking to the text Click here, include the full title of the destination page.
TIP: You can also add ScreenTips that appear when your cursor hovers over a cell that includes a hyperlink.
Add hyperlink text and ScreenTips
Give all sheet tabs unique names, and remove blank sheets.
To find out whether all sheets that contain content in a workbook have descriptive names and whether there are any blank sheets, use the Accessibility Checker.
Screen readers read sheet names, which provide information about what is found on the worksheet, making it easier to understand the contents of a workbook and to navigate through it.
Rename sheet tabs
Delete a sheet tab
Use a simple table structure, and specify column header information.
To ensure that tables don’t contain split cells, merged cells, nested tables, or completely blank rows or columns, use the Accessibility Checker.
Screen readers keep track of their location in a table by counting table cells. If a table is nested within another table or if a cell is merged or split, the screen reader loses count and can’t provide helpful information about the table after that point. Blank cells in a table could also mislead someone using a screen reader into thinking that there is nothing more in the table.
Screen readers also use header information to identify rows and columns.
Add headers to a new table
Use headers in an existing table