There are five basic techniques that will greatly improve the accessibility of your Excel content:
- Add alternative (alt) text to images, SmartArt, graphs, tables, and other visuals
- Specify column headers
- Give sheets and workbooks meaningful names
- Create meaningful hyperlinks that inform readers about the link's content
- Use the Accessibility Checker
Add Alternative (alt) Text
Alt text helps individuals using assistive technologies access images, graphs, and other visuals by describing important features of a visual. Follow the steps below to include alt text in your document’s images:
- Select the visual and right click, or select the menu key, to bring up a menu.
- Select Format Picture in the menu. A Format Picture dialog should appear.
- In the dialog, select the Layout and Properties option.
- Insert alt text into the Alt Text textbox.
Specify Column Headers
When specified, column headers can provide important information about table data and help screen readers navigate a table. Follow the steps below to insert column headers:
- Go to the Insert tab.
- In the Tables group, select Table.
- Select the My table has headers check box.
- Select OK. Excel creates a header row with default names.
- Type new, descriptive names for each column in the table.
Give Sheets Meaningful Names
Giving sheets meaningful names describes to readers what data that particular sheet has and lets readers choose whether or not to use the document. Follow the steps below to rename sheets in a meaningful way:
- Right click on the sheet tab (default name is usually Sheet1).
- Select Rename from the menu.
Create Meaningful Hyperlinks
Hyperlinks that contain meaningful text instead of a URL provide much more context in a document, and inform users where the link will take them if they click on it. Follow the steps below to create meaningful hyperlinks:
- Select the text intended to be the link.
- Under the Insert tab, go to the Links group.
- Select Hyperlink.
- In the dialog box, insert the desired website URL. (Your selected text should already be in the "Text to Display" field.)
- Click OK.
Use the Accessibility Checker
The Accessibility Checker is a feature in Excel that informs you about any accessibility concerns in your document, and instructs on how to address and fix these concerns. Follow the steps below to run the Accessibility Checker:
- Go to the File tab, then Info.
- Select Check for Issues to bring down a dropdown menu.
- Select Check Accessibility.
- Follow the steps in the results pane as needed.
- NCDAE: Creating Accessible Spreadsheets in Microsoft Excel 2010/2013 (also applies to Excel 2016)
- Office: Make your Excel spreadsheets accessible