Accessible Excel

Use an accessible template

To find a template, select File, then New. Search for accessible templates. To start using one, select Create.

Organize the sheet tabs

Screen readers read sheet names which provide information about what’s on the worksheet. Rename sheet tabs (default: Sheet 1, Sheet 2, etc) with descriptive titles.

Delete any unused sheet tabs.

Make your text legible

Some text is easier for people to read:

  • Use a size 12 point font or larger
  • Review accessible font information in these tutorials
  • Do not write in all capital letters
  • Do not use bold unless you’re using it to emphasize a few words or a short sentence
  • Avoid italics, they’re difficult to read
  • Only underline text if it’s a hyperlink
  • When using a text colour other than black, test the colour contrast to make sure it’s easy to read (free Colour Contrast Analyser)
  • Do not use colour alone to convey meaning as it may not be visible to people who are colour blind and will not be communicated to someone using a screen reader. For example: writing in red to indicate something is important

Colour contrast

If your spreadsheet has a high level of contrast between text and background, more people will be able to see and use the content. To find insufficient color contrast, use the Accessibility Checker. Colour contrast accessibility ratios define the minimum difference in luminance between text and its background to ensure readability for users with visual impairments. In order to meet WCAG Level AA, standard text must have a contrast ratio of at least 4.5:1 while large text (headings, etc.) needs a 3:1 ratio.

When using a text colour other than black, test it to make sure it’s easy to read. You can use the free app Colour Contrast Analyser.

Add alternative text to visual content

Add alternative text (alt text) to images, such as pictures, screenshots, icons, SmartArt, PivotCharts and 3D models.

Do one of the following:

  • Right-click an image and select Edit Alt Text
  • Select the image. Select Format > Alt Text
  • Use the Alt Text button on the Excel for Windows ribbon

The Alt Text pane opens on the right side of the document body. Type 5 to 15 words to describe the image and its context.

Mark as decorative

If your visuals are decorative, such as borders that add visual interest but are not informative, you can mark them as decorative.

To do this:

  1. Select the visual and open the alt text pane
  2. Select the Mark as decorative text box.

Hyperlinks

Links should convey clear information about their destination. For example, instead of linking to the text Click here, include the full title of the destination page.

Tables

  • Use header information to identify rows and columns
  • Use a simple table structure. Screen readers keep track of their location in a table by counting cells. If a table is nested within another table or a cell is merged or split, the screen reader loses count and cannot provide helpful information
  • Limit your use of blank cells
  • Use the Accessibility Checker to ensure your table doesn’t contain split cells, merged cells, or nested tables

Create accessible charts

The charts and graphs you create in Excel help make information easier to understand.

  • Make sure chart labels are clear and useful
  • Use a descriptive title for your chart
  • Check your data labels by selecting the chart and then selecting Chart Elements. Select Axis Titles to add titles to the horizontal and vertical axes
  • Add alt text to your chart

Accessibility Checker

Review your document using Microsoft’s built-in Accessibility Checker.

  1. Go to File, select Info, and then select the Check for Issues button
  2. From the dropdown select Check Accessibility
  3. Review the results and make edits as needed

Resources