Introduction

Excel is a spreadsheet program that can be used for storing, organizing, and manipulating data. If Excel is not used properly, then it may be inaccessible to someone with a disability.

Provide Alt-Text

Alternative text, also known as alt text, often appears when you move your pointer over a picture or object on a website. Screen readers also read alt text to users to educate them on what an image, object, or table contains.

Alt text should be accurate and descriptive, but it does not need to include what type of object was created (image, chart, table, etc.), as the screen reader will automatically convey this. 

HOW TO: Provide alt-text in Excel:

Windows Users:

  1. The first step will vary depending on the type of object selected:
    • Chart/Picture/Shape/SmartArt: Right-click the object and select View Alt Text.
    • Table: Click the Table, select Format, and then click the Alt Text command.
    • Pivot Table: Right-click, select PivotTable Options, and then click Alt Text.
  2. Type a description of the image or object into the Description text boxes. NOTE: Any alt text in the Title box will not be recorded as alt text.
  3. Click Close.

Specify Column Heading Information in Tables

In addition to adding alt text that describes the table, having clear column headings can help provide context and assist navigation of the table’s contents.

HOW TO: Specify a header row in cells marked as a table:

  1. Click anywhere in the table.
  2. On the Table Tools Design tab, in the Table Style Options group, select the Header Row check box.
Table Styles Options menu with checkboxes for Header Row and Banded Rows checked.

  1. Add your header information.

HOW TO: Specify a header row in a NEW block of cells marked as a table:

  1. Highlight the cells you want to include in the table.
  2. On the Insert tab, in the Tables group, click Table.
  3. Select the My table has headers check box.
The Create Table dialog box with the checkbox for My table has headers selected
  1. Click OK.

Naming Worksheets

Providing sheet names make it easier to navigate through a workbook. All worksheets should be named, and any blank sheets in a workbook should be removed.

HOW TO: Rename a sheet:

  1. Right-click the sheet tab, then click Rename.
  2. Type a brief, unique name that is descriptive of the sheet
    contents.
Worksheet menu highlighting the Rename option

Excel Accessibility Checker

The Accessibility Checker helps find and fix issues that can make it difficult for people with disabilities to read or interact with a workbook.

HOW TO: Check for accessibility in Excel

Windows Users:

  1. Click the File tab.
  2. Click Check for Issues.
  3. Click Check Accessibility.
  4. Errors and warnings will appear in a task pane. You can then review the issues and see which ones need to be fixed.

Mac Users:

  1. Open the Review tab in the ribbon.
  2. Click Check Accessibility.
  3. The Accessibilty Assistant window will open on the right side of the screen.
  4. Click a specific issue to see more information and steps you can take to change the content.

The Accessibility Checker checks a file against a set of possible issues that people who have disabilities might experience in the file. Each issue is classified as an Error, Warning, or Tip.

  • Error: An error is for content that makes a file very difficult or impossible for people with disabilities to understand.
  • Warning: A warning is for content that in most, but not all, cases makes a file difficult for people with disabilities to understand.
  • Tip: A tip is for content that people with disabilities can understand, but that might be better organized or presented in a way that would improve their experience.

Excel Accessibility Checker

The Accessibility Checker helps find and fix issues that can make it difficult for people with disabilities to read or interact with a workbook.

HOW TO: Check for accessibility in Excel

Windows Users:

  1. Click File > Info.
  2. Click Check for Issues.
  3. Click Check Accessibility.
Screenshot of the Excel Info panel, highlighting options for checking accessibility and inspecting the workbook for issues.
  1. Errors and warnings will appear in a task pane. You can then review the issues and see which ones need to be fixed.

Mac Users:

  1. Open the Review tab in the ribbon.
  2. Click Check Accessibility.
The Review tab in Excel showing the "Check Accessibility" option highlighted.
  1. The Accessibilty Assistant window will open on the right side of the screen.
  2. Click a specific issue to see more information and steps you can take to change the content.

Accessibility Checker Issues

The Accessibility Checker checks a file against a set of possible issues that people who have disabilities might experience in the file. Each issue is classified as an Error, Warning, or Tip.

  • Error: An error is for content that makes a file very difficult or impossible for people with disabilities to understand.
  • Warning: A warning is for content that in most, but not all, cases makes a file difficult for people with disabilities to understand.
  • Tip: A tip is for content that people with disabilities can understand, but that might be better organized or presented in a way that would improve their experience.

Back to Top