Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Make your Excel documents accessible to people with disabilities

This topic gives you step-by-step instructions and best practices for making your Excel spreadsheets accessible and unlock your content to everyone, including people with disabilities.

You learn, for example, how to work with the Accessibility Checker to tackle accessibility issues while you're creating your spreadsheet. You'll also learn how to add alt texts to images so that people using screen readers are able to listen to what the image is all about. You can also read about how to create accessible tables and how to use templates, fonts, and colors to maximize the inclusiveness of your spreadsheets before sharing them with others.

In this topic

Best practices for making Excel spreadsheets accessible

The following table includes key best practices for creating Excel spreadsheets that are accessible to people with disabilities.

What to fix

How to find it

Why fix it

How to fix it

Avoid common accessibility issues such as missing alternative text (alt text) and low contrast colors.

Use the Accessibility Checker.

Make it easy for everyone to read your spreadsheet.

Check accessibility while you work in Excel

Use a simple table structure for data only, and specify column header information.

To ensure that tables don’t contain split cells, merged cells, or nested tables, use the Accessibility Checker.

Visually scan your tables to check that they don't have any completely blank rows or columns.

Screen readers keep track of their location in a table by counting table cells.

Screen readers also use header information to identify rows and columns.

Create accessible tables

Add text to cell A1.

Make sure that you have text in cell A1.

Screen readers start reading any worksheet from cell A1.

Add text to cell A1

Include alt text with all visuals.

To find all instances of missing alt text, use the Accessibility Checker.

Alt text helps people who can’t see the screen to understand what’s important in images and other visuals.

Add alt text to visuals

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 workbook.

People who use screen readers sometimes scan a list of links.

Add accessible hyperlink text and ScreenTips

Use sufficient contrast for text and background colors.

To find insufficient color contrast, use the Accessibility Checker.

You can also look for text in your spreadsheet that’s hard to read or to distinguish from the background.

If your spreadsheet has a high level of contrast between text and background, more people can see and use the content.

Use accessible font format and color

Use an accessible template

Give all worksheets unique names, and remove blank worksheets.

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 worksheets

Delete blank worksheets

Name cells and ranges.

Visually scan your workbook to see which cells and ranges would benefit from having a name.

When you name cells and ranges, screen reader users can quickly identify the purpose of cells and ranges.

Name cells and ranges

Top of Page

Check accessibility while you work in Excel 

The Accessibility Checker is a tool that reviews your content and flags accessibility issues it comes across. It explains why each issue might be a potential problem for someone with a disability. The Accessibility Checker also suggests how you can resolve the issues that appear.

In Excel, the Accessibility Checker runs automatically in the background when you're creating a document. If the Accessibility Checker detects accessibility issues, you will get a reminder in the status bar.

To manually launch the Accessibility Checker, select Review > Check Accessibility. The Accessibility pane and the Accessibility ribbon open, and you can now review and fix accessibility issues. The Accessibility ribbon contains all the tools you need to create accessible spreadsheets in one place. For more info, go to Accessibility Ribbon and Improve accessibility with the Accessibility Checker.

Top of Page

Create accessible tables

Tables can help you identify a set of data by name, and you can format the table using styles that make the data stand out. When you carefully name and format your table, you can be sure that everyone can understand your data.

It is also important to specify column header information and use a simple table structure to make sure that screen reader users can navigate the tables easily. 

Name a table

By default, Excel names the tables you create as Table1, Table2, Table3, and so on. To make it easier to refer to a table, give each table a descriptive name. A meaningful table name like "EmployeeList" is more helpful than the generic "Table1." 

With the descriptive name, you can, for example, quickly jump to the table with the Go To command (Ctrl+G) or the Name Manager dialog box. You can also easily refer to the table in formulas.

  1. Place the cursor anywhere in the table.

  2. On the Table Design tab, under Table Name, replace the default name, such as 'Table1,' with a more descriptive one.

Image of the Name Box in the Excel Formula Bar to rename a table

Note: Table names must start with a letter, an underscore (_), or a backslash (\) and cannot contain spaces. For more info, see section "Important notes for names" in Rename an Excel table.

Select an accessible table style

Light colored tables with low contrast can be hard to read. To make your table more accessible, select a table style that has colors with a strong contrast. For example, choose a style that alternates between white and a dark color, such as black, dark grey, or dark blue.

  1. Place the cursor anywhere in the table.

  2. On the Table Design tab, in the Table Styles group, select the style you want.

Use table headers

Screen readers use header information to identify rows and columns. Clear table headers provide context and make navigating the table content easier.

  1. Place the cursor anywhere in a table.

  2. On the Table Design tab, in the Table Style Options group, select the Header Row checkbox.

  3. Type the column headings.

For instructions on how to add headers to a new table, go to Create a table.

Table structures to avoid

Design your tables keeping in mind the following:

  • Avoid blank cells, columns, and rows. When navigating using the keyboard, a blank cell, column, or row might lead a screen reader user to believe there is nothing more in the table.

    • If there is no need for a blank cell, column, or row, consider deleting it.

    • If you cannot avoid a blank cell, column, or row, enter text explaining that it is blank. For example, type N/A or Intentionally Blank.

  • Avoid splitting or merging cells: 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. Merged or split cells can make navigating Excel tables with assistive technologies very difficult, if not impossible. Always keep your tables straightforward and simple. To ensure that tables don't contain split cells, merged cells, or nested tables, use the Accessibility Checker.

Top of Page

Use an accessible template

Use one of the accessible Excel templates to make sure that your spreadsheet design, colors, contrast, and fonts are accessible for all audiences. The templates are also designed so that screen readers can more easily read the spreadsheet content.

When selecting a template, look for a template that has several features that support accessibility. For example:

  • Using enough white space makes the spreadsheet easier to read.

  • Colors with contrast make them easier to tell apart for low vision and colorblind readers.

  • Larger fonts are easier for low-vision users.

  • Preset descriptive headings and labels make the spreadsheet easier to understand for users who navigate it with a screen reader.

For the step-by-step instructions on how to use accessible templates, go to Video: Start with an accessible Excel template.

Top of Page

Add text to cell A1

A screen reader starts reading any worksheet from cell A1. If you have a table on the worksheet, A1 should preferably be the title of the table.

If the sheet is long or complex, add instructions or an overview of the sheet in cell A1. This will inform people who are blind what’s being presented in your worksheet and how to use it. This instructional text can match the background color. This will hide it from people who can see, but allows it to be read by screen readers.

Top of Page

Add alt text to visuals

Alt text helps people who can’t see the screen to understand what’s important in visual content. Visual content includes pictures, SmartArt graphics, shapes, groups, charts, pivot charts, embedded objects, ink, and videos. In alt text, briefly describe the image and mention its intent. Screen readers read the text to describe the image to users who can’t see the image.

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.

Tip: To write a good alt text, make sure to convey the content and the purpose of the image in a concise and unambiguous manner. The alt text shouldn’t be longer than a short sentence or two—most of the time a few thoughtfully selected words will do. Do not repeat the surrounding textual content as alt text or use phrases referring to images, such as, "a graphic of" or "an image of." For more info on how to write alt text, go to Everything you need to know to write effective alt text.

For the step-by-step instructions on how to add alt text, go to Add alternative text to a shape, picture, chart, SmartArt graphic, or other object.

To find missing alt text, use the Accessibility Checker.

Note: For audio and video content, in addition to alt text, include closed captioning for people who are deaf or hard of hearing.

Top of Page

Use accessible font format and color

An accessible font doesn't exclude or slow down the reading speed of anyone reading a spreadsheet, including people with low vision or reading disability or people who are blind. The right font improves the legibility and readability of the spreadsheet.

For instructions on how to change the default font, go to Change the font size.

Use accessible font format

Here are some ideas to consider:

  • To reduce the reading load, select familiar sans serif fonts such as Arial or Calibri. Avoid using all capital letters and excessive italics or underlines.

  • A person with a vision disability might miss out on the meaning conveyed by particular colors. For example, add an underline to color-coded hyperlink text so that people who are colorblind know that the text is linked even if they can’t see the color.

  • For headings, consider adding bold or using a larger font.

Use accessible font color

The text in your spreadsheet should be readable in a high contrast mode. For example, use bright colors or high-contrast color schemes on opposite ends of the color spectrum. White and black schemes make it easier for people who are colorblind to distinguish text and shapes.

Here are some ideas to consider:

  • To ensure that text displays well in a high contrast mode, use the Automatic setting for font colors. For instructions on how to change the font color, go to Format text in cells.

  • Use the Accessibility Checker to analyze the spreadsheet and find insufficient color contrast. The tool now checks the documents for text color against page color, table cell backgrounds, highlight, textbox fill color, paragraph shading, shape and SmartArt fills, headers and footers, and links.

  • Use an accessible template.

Top of Page

Create accessible charts

Charts help make complex information easier to understand. To make charts accessible, use clear and descriptive language for the chart elements, such as the chart title, axis titles, and data labels. Also make sure their formatting is accessible.

For instructions on how to add chart elements to your chart and make them accessible, go to Video: Create accessible charts in Excel.

Format a chart element

  1. Select the chart element you want to format, for example, the chart title or data labels.

  2. Select the Format tab.

  3. Under the Current Selection group, select Format Selection. The Format pane opens to the right.

  4. Select the formatting options that make your chart element accessible, such as a larger font or well-contrasting colors.

Top of Page

Rename worksheets

Screen readers read worksheet names, so make sure those labels are clear and descriptive. Using unique names for worksheets makes it easier to navigate the workbook.

By default, Excel names worksheets as Sheet1, Sheet2, Sheet3, and so on, but you can easily rename them. For instructions on how to rename worksheets, go to Rename a worksheet.

Top of Page

Delete blank worksheets

Screen readers read worksheet names, so blank worksheets might be confusing. Do not include any blank sheets in your workbooks.

For instructions on how to delete worksheets, go to Insert or delete a worksheet.

Top of Page

Name cells and ranges

Name cells and ranges so that screen reader users can quickly identify the purpose of cells and ranges in Excel worksheets. Users can use the Go To command (Ctrl+G) to open up a dialog box which lists all the defined names. By selecting a name, a user can quickly jump to the named location.

  1. Select the cell or range of cells that you want to name.

  2. Select Formulas > Define name.

  3. Enter the name and select OK.

Note: The name must start with a letter, an underscore (_), or a backslash (\) and cannot contain spaces.

Top of Page

Test the accessibility of your worksheets

When your spreadsheet is ready and you've run the Accessibility Checker to make sure it is inclusive, you can try navigating the spreadsheet using a screen reader, for example, Narrator. Narrator comes with Windows, so there's no need to install anything. This is one additional way to spot issues in the navigation, for example.

  1. Start the screen reader. For example, to start Narrator, press Ctrl+Windows logo key+Enter.

  2. Press F6 until the focus, the blue rectangle, is on the worksheet table grid.

  3. Do the following to test your worksheets:

    1. Use the arrow keys to move between the cells in the table grid.

    2. To check the worksheet names in your spreadsheet, press F6 until the focus is on the name of the current worksheet, and then use the Left and Right arrow keys to hear the other worksheet names.

    3. If your worksheet contains floating shapes such images, press Ctrl+Alt+5. Then, to cycle through the floating shapes, press the Tab key. To return to the normal navigation, press Esc.

  4. Fix any accessibility issues you spotted when navigating with a screen reader.

  5. Exit the screen reader. For example, to exit Narrator, press Ctrl+Windows logo key+Enter.

Note: Also make sure that your worksheets can be easily read on a mobile phone. This not only benefits people who have low vision and use magnification, but it also benefits a very broad set of mobile phone users.

Top of Page

See also

Rules for the Accessibility Checker

Everything you need to know to write effective alt text

Make your Word documents accessible to people with disabilities

Make your PowerPoint presentations accessible to people with disabilities

Make your Outlook email accessible to people with disabilities

Make your OneNote notebooks accessible to people with disabilities

Excel help & learning

In this topic

Best practices for making Excel spreadsheets accessible

The following table includes key best practices for creating Excel spreadsheets that are accessible to people with disabilities.

What to fix

How to find it

Why fix it

How to fix it

Avoid common accessibility issues such as missing alternative text (alt text) and low contrast colors.

Use the Accessibility Checker.

Make it easy for everyone to read your spreadsheet.

Check accessibility while you work in Excel

Use a simple table structure for data only, and specify column header information.

To ensure that tables don’t contain split cells, merged cells, or nested tables, use the Accessibility Checker.

Visually scan your tables to check that they don't have any completely blank rows or columns.

Screen readers keep track of their location in a table by counting table cells.

Screen readers also use header information to identify rows and columns.

Create accessible tables

Add text to cell A1.

Make sure that you have text in cell A1.

Screen readers start reading any worksheet from cell A1.

Add text to cell A1

Include alt text with all visuals.

To find all instances of missing alt text, use the Accessibility Checker.

Alt text helps people who can’t see the screen to understand what’s important in images and other visuals.

Add alt text to visuals

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 workbook.

People who use screen readers sometimes scan a list of links.

Add accessible hyperlink text and ScreenTips

Use sufficient contrast for text and background colors.

To find insufficient color contrast, use the Accessibility Checker.

You can also look for text in your spreadsheet that’s hard to read or to distinguish from the background.

If your spreadsheet has a high level of contrast between text and background, more people can see and use the content.

Use accessible font format and color

Use an accessible template

Give all worksheets unique names, and remove blank worksheets.

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 worksheets

Delete blank worksheets

Name cells and ranges.

Visually scan your workbook to see which cells and ranges would benefit from having a name.

When you name cells and ranges, screen reader users can quickly identify the purpose of cells and ranges.

Name cells and ranges

Top of Page

Check accessibility while you work in Excel

The Accessibility Checker is a tool that reviews your content and flags accessibility issues it comes across. It explains why each issue might be a potential problem for someone with a disability. The Accessibility Checker also suggests how you can resolve the issues that appear.

In Excel, the Accessibility Checker runs automatically in the background when you're creating a document. If the Accessibility Checker detects accessibility issues, you will get a reminder in the status bar.

To manually launch the Accessibility Checker, select Review > Check Accessibility. The Accessibility pane and the Accessibility ribbon open, and you can now review and fix accessibility issues. The Accessibility ribbon contains all the tools you need to create accessible spreadsheets in one place. For more info, go to Accessibility Ribbon and Improve accessibility with the Accessibility Checker.

Top of Page

Create accessible tables

Tables can help you identify a set of data by name, and you can format the table using styles that make the data stand out. When you carefully name and format your table, you can be sure that everyone can understand your data.

It is also important to specify column header information and use a simple table structure to make sure that screen reader users can navigate the tables easily.

Name a table

By default, Excel names the tables you create as Table1, Table2, Table3, and so on. To make it easier to refer to a table, give each table a descriptive name. A meaningful table name like "EmployeeList" is more helpful than the generic "Table1."

With the descriptive name, you can, for example, quickly jump to the table with the Go To command (Control+G) or the Name Manager dialog box. You can also easily refer to the table in formulas.

  1. Place the cursor anywhere in the table.

  2. On the Table tab, under Table Name, replace the default name, such as 'Table1,' with a more descriptive one.

Table Name field in Excel for Mac

Note: Table names must start with a letter, an underscore (_), or a backslash (\) and cannot contain spaces. For more info, see section "Important notes for names" in Rename an Excel table.

Select an accessible table style

Light colored tables with low contrast can be hard to read. To make your table more accessible, select a table style that has colors with a strong contrast. For example, choose a style that alternates between white and a dark color, such as black, dark grey, or dark blue.

  1. Place the cursor anywhere in the table.

  2. On the Table tab, in the table styles group, select the style you want.

Table Styles group in Excel for Mac

Use table headers

Screen readers use header information to identify rows and columns. Clear table headers provide context and make navigating the table content easier.

  1. Place the cursor anywhere in a table.

  2. On the Table tab, in the table styles group, select the Header Row checkbox.

  3. Type the column headings.

Header Row checkbox selected in the Table Styles group in Excel for Mac

For instructions on how to add headers to a new table, go to Create a table.

Table structures to avoid

Design your tables keeping in mind the following:

  • Avoid blank cells, columns, and rows. When navigating using the keyboard, a blank cell, column, or row might lead a screen reader user to believe there is nothing more in the table.

    • If there is no need for a blank cell, column, or row, consider deleting it.

    • If you cannot avoid a blank cell, column, or row, enter text explaining that it is blank. For example, type N/A or Intentionally Blank.

  • Avoid splitting or merging cells: 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. Merged or split cells can make navigating Excel tables with assistive technologies very difficult, if not impossible. Always keep your tables straightforward and simple. To ensure that tables don't contain split cells, merged cells, or nested tables, use the Accessibility Checker.

Top of Page

Use an accessible template

Use one of the accessible Excel templates to make sure that your spreadsheet design, colors, contrast, and fonts are accessible for all audiences. The templates are also designed so that screen readers can more easily read the spreadsheet content.

When selecting a template, look for a template that has several features that support accessibility. For example:

  • Using enough white space makes the spreadsheet easier to read.

  • Colors with contrast make them easier to tell apart for low vision and colorblind readers.

  • Larger fonts are easier for low-vision users.

  • Preset descriptive headings and labels make the spreadsheet easier to understand for users who navigate it with a screen reader.

  1. To find an accessible template, select File > New from Template.

  2. In the Search text field, type accessible templates and press Return.

  3. In the search results, select a suitable template.

Top of Page

Add text to cell A1

A screen reader starts reading any worksheet from cell A1. If you have a table on the worksheet, A1 should preferably be the title of the table.

If the sheet is long or complex, add instructions or an overview of the sheet in cell A1. This will inform people who are blind what’s being presented in your worksheet and how to use it. This instructional text can match the background color. This will hide it from people who can see, but allows it to be read by screen readers.

Top of Page

Add alt text to visuals

Alt text helps people who can’t see the screen to understand what’s important in visual content. Visual content includes pictures, SmartArt graphics, shapes, groups, charts, pivot charts, embedded objects, ink, and videos. In alt text, briefly describe the image and mention its intent. Screen readers read the text to describe the image to users who can’t see the image.

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.

Tip: To write a good alt text, make sure to convey the content and the purpose of the image in a concise and unambiguous manner. The alt text shouldn’t be longer than a short sentence or two—most of the time a few thoughtfully selected words will do. Do not repeat the surrounding textual content as alt text or use phrases referring to images, such as, "a graphic of" or "an image of." For more info on how to write alt text, go to Everything you need to know to write effective alt text.

For the step-by-step instructions on how to add alt text, go to Add alternative text to a shape, picture, chart, SmartArt graphic, or other object.

To find missing alt text, use the Accessibility Checker.

Note: For audio and video content, in addition to alt text, include closed captioning for people who are deaf or hard of hearing.

Top of Page

Use accessible font format and color

An accessible font doesn't exclude or slow down the reading speed of anyone reading a spreadsheet, including people with low vision or reading disability or people who are blind. The right font improves the legibility and readability of the spreadsheet.

For instructions on how to change the default font, go to Change the default font in Excel for Mac.

Use accessible font format

Here are some ideas to consider:

  • To reduce the reading load, select familiar sans serif fonts such as Arial or Calibri. Avoid using all capital letters and excessive italics or underlines.

  • A person with a vision disability might miss out on the meaning conveyed by particular colors. For example, add an underline to color-coded hyperlink text so that people who are colorblind know that the text is linked even if they can’t see the color.

  • For headings, consider adding bold or using a larger font.

Use accessible font color

The text in your spreadsheet should be readable in a high contrast mode. For example, use bright colors or high-contrast color schemes on opposite ends of the color spectrum. White and black schemes make it easier for people who are colorblind to distinguish text and shapes.

Here are some ideas to consider:

  • To ensure that text displays well in a high contrast mode, use the Automatic setting for font colors. For instructions on how to change the font color, go to Format text in cells.

  • Use the Accessibility Checker to analyze the spreadsheet and find insufficient color contrast. The tool now checks the documents for text color against page color, table cell backgrounds, highlight, textbox fill color, paragraph shading, shape and SmartArt fills, headers and footers, and links.

  • Use an accessible template.

Top of Page

Create accessible charts

Charts help make complex information easier to understand. To make charts accessible, use clear and descriptive language for the chart elements, such as the chart title, axis titles, and data labels. Also make sure their formatting is accessible.

For instructions on how to add chart elements to your chart and make them accessible, go to Create a chart in Excel for Mac and Video: Create accessible charts in Excel.

Format a chart element

  1. Select the chart element you want to format, for example, the chart title or data labels.

  2. Select the Format tab.

  3. Select Format Pane. The pane opens to the right.

  4. Select the formatting options that make your chart element accessible, such as well-contrasting colors.

Top of Page

Rename worksheets

Screen readers read worksheet names, so make sure those labels are clear and descriptive. Using unique names for worksheets makes it easier to navigate the workbook.

By default, Excel names worksheets as Sheet1, Sheet2, Sheet3, and so on, but you can easily rename them.

  1. Do one of the following:

    • Double-click the sheet tab, and type the new name.

    • On the Home tab, select Format > Rename Sheet, and type the new name.

Top of Page

Delete blank worksheets

Screen readers read worksheet names, so blank worksheets might be confusing. Do not include any blank sheets in your workbooks.

  1. Go to the worksheet you want to delete.

  2. On the Home tab, select Delete > Delete Sheet, and then select Delete to confirm the deletion.

Top of Page

Name cells and ranges

Name cells and ranges so that screen reader users can quickly identify the purpose of cells and ranges in Excel worksheets. Users can use the Go To command (Control+G) to open up a dialog box which lists all the defined names. By selecting a name, a user can quickly jump to the named location.

  1. Select the cell or range of cells that you want to name.

  2. Select Formulas > Define name.

  3. Enter the name and select OK.

Note: The name must start with a letter, an underscore (_), or a backslash (\) and cannot contain spaces.

Top of Page

Test the accessibility of your worksheets

When your spreadsheet is ready and you've run the Accessibility Checker to make sure it is inclusive, you can try navigating the spreadsheet using VoiceOver, the built-in macOS screen reader. This is one additional way to spot issues in the navigation, for example.

  1. To start VoiceOver, do one of the following:

    • Press Command+F5.

    • On the Apple menu, select System Preferences. Select Accessibility > VoiceOver, and then select the Enable VoiceOver checkbox.

  2. Put the focus to the worksheet table grid.

  3. Do the following to test your worksheets:

    1. Use the arrow keys to move between the cells in the table grid.

    2. To check the worksheet names in your spreadsheet, press Option+Right or Left arrow key to go to the next or previous worksheet and to hear its name. Check also that there are no blank sheets.

    3. To check that you have defined a descriptive and useful name for all tables and important cells in your worksheet, press Control+G and review the list in the Go To dialog box.

  4. Fix any accessibility issues you spotted when navigating with a screen reader.

  5. To exit VoiceOver, do one of the following:

    • Press Command+F5.

    • On the Apple menu, select System Preferences. Select Accessibility > VoiceOver, and then clear the Enable VoiceOver checkbox.

Note: Also make sure that your worksheets can be easily read on a mobile phone. This not only benefits people who have low vision and use magnification, but it also benefits a very broad set of mobile phone users.

Top of Page

See also

Rules for the Accessibility Checker

Everything you need to know to write effective alt text

Make your Word documents accessible to people with disabilities

Make your PowerPoint presentations accessible to people with disabilities

Make your Outlook email accessible to people with disabilities

Make your OneNote notebooks accessible to people with disabilities

Excel help & learning

In this topic

Best practices for making Excel spreadsheets accessible

The following table includes key best practices for creating Excel spreadsheets that are accessible to people with disabilities.

What to fix

Why fix it

How to fix it

Use a simple table structure for data only, and specify column header information.

Screen readers keep track of their location in a table by counting table cells.

Screen readers also use header information to identify rows and columns.

Create accessible tables

Add text to cell A1.

Screen readers start reading any worksheet from cell A1.

Add text to cell A1

Include alternative text (alt text) with all visuals.

Alt text helps people who can’t see the screen to understand what’s important in images and other visuals.

Add alt text to visuals

Add meaningful hyperlink text.

People who use screen readers sometimes scan a list of links.

Add accessible hyperlink text

Use sufficient contrast for text and background colors.

If your spreadsheet has a high level of contrast between text and background, more people can see and use the content.

Use accessible font format and color

Give all worksheets unique names, and remove blank worksheets.

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 worksheets

Delete blank worksheets

Top of Page

Create accessible tables

Tables can help you identify a set of data by name, and you can format the table using styles that make the data stand out. When you carefully name and format your table, you can be sure that everyone can understand your data.

It is also important to specify column header information and use a simple table structure to make sure that screen reader users can navigate the tables easily.

Name a table

By default, Excel names the tables you create as Table1, Table2, Table3, and so on. To make it easier to refer to a table, give each table a descriptive name. A meaningful table name like "EmployeeList" is more helpful than the generic "Table1."

With the descriptive name, you can, for example, easily refer to the table in formulas. When table names are used, you can also quickly jump to the table with the Go To command in the Excel desktop app.

  1. Place the cursor anywhere in the table.

  2. In the toolbar at the bottom of the screen, select  Cards View button in Excel for iOS (Cards View).

  3. At the upper-right corner, select Table settings button in Excel for Android (Table settings).

  4. Tap the default table name, and replace it with a descriptive name.

Table name text field in Excel for Android

Note: Table names must start with a letter, an underscore (_), or a backslash (\) and cannot contain spaces. For more info, see section "Important notes for names" in Rename an Excel table.

Select an accessible table style

Light colored tables with low contrast can be hard to read. To make your table more accessible, select a table style that has colors with a strong contrast. For example, choose a style that alternates between white and a dark color, such as black, dark grey, or dark blue.

  1. Place the cursor anywhere in the table.

  2. In the toolbar at the bottom of the screen, select  The Show ribbon button in Excel for iOS (Show ribbon).

  3. Open the tab menu and select the Table tab.

  4. Select Table Styles, and then select the style you want.

Use table headers

Screen readers use header information to identify rows and columns. Clear table headers provide context and make navigating the table content easier.

Add headers to an existing table

  1. Place the cursor anywhere in a table.

  2. In the toolbar at the bottom of the screen, select  The Show ribbon button in Excel for iOS (Show ribbon).

  3. Open the tab menu and select the Table tab.

  4. Select Style Options, and then select Header Row.

    Style Options command, with Header Row selected
  5. Type the column headings.

Add headers to a new table

  1. Select the cells you want to include in the table.

  2. In the toolbar at the bottom of the screen, select  The Show ribbon button in Excel for iOS (Show ribbon).

  3. Open the tab menu and select the Insert tab.

  4. Select Table.

  5. Turn on the Table has headers switch.

Table has headers option selected in Excel for iOS

Table structures to avoid

Design your tables keeping in mind the following:

  • Avoid blank cells, columns, and rows. When navigating using the keyboard, a blank cell, column, or row might lead a screen reader user to believe there is nothing more in the table.

    • If there is no need for a blank cell, column, or row, consider deleting it.

    • If you cannot avoid a blank cell, column, or row, enter text explaining that it is blank. For example, type N/A or Intentionally Blank.

  • Avoid splitting or merging cells: 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. Merged or split cells can make navigating Excel tables with assistive technologies very difficult, if not impossible. Always keep your tables straightforward and simple.

Top of Page

Add text to cell A1

A screen reader starts reading any worksheet from cell A1. If you have a table on the worksheet, A1 should preferably be the title of the table.

If the sheet is long or complex, add instructions or an overview of the sheet in cell A1. This will inform people who are blind what’s being presented in your worksheet and how to use it. This instructional text can match the background color. This will hide it from people who can see, but allows it to be read by screen readers.

Top of Page

Add alt text to visuals

Alt text helps people who can’t see the screen to understand what’s important in visual content. Visual content includes pictures, shapes, groups, charts, embedded objects, ink, and videos. In alt text, briefly describe the image and mention its intent. Screen readers read the text to describe the image to users who can’t see the image.

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.

Tip: To write a good alt text, make sure to convey the content and the purpose of the image in a concise and unambiguous manner. The alt text shouldn’t be longer than a short sentence or two—most of the time a few thoughtfully selected words will do. Do not repeat the surrounding textual content as alt text or use phrases referring to images, such as, "a graphic of" or "an image of." For more info on how to write alt text, go to Everything you need to know to write effective alt text.

Note: For audio and video content, in addition to alt text, include closed captioning for people who are deaf or hard of hearing.

  1. Select the visual.

  2. To open the Picture, Shape, or Chart tab, select  The Show ribbon button in Excel for iOS (Show ribbon) in the toolbar at the bottom of the screen.

  3. Select Alt Text.

  4. Type the alt text in the Description field.

    Alt Text dialog box in Excel for iOS.

  5. Select Done.

Top of Page

Use accessible font format and color

An accessible font doesn't exclude or slow down the reading speed of anyone reading a spreadsheet, including people with low vision or reading disability or people who are blind. The right font improves the legibility and readability of the spreadsheet.

Use accessible font format

Here are some ideas to consider:

  • To reduce the reading load, select familiar sans serif fonts such as Arial or Calibri. Avoid using all capital letters and excessive italics or underlines.

  • A person with a vision disability might miss out on the meaning conveyed by particular colors. For example, add an underline to color-coded hyperlink text so that people who are colorblind know that the text is linked even if they can’t see the color.

  • For headings, consider adding bold or using a larger font.

  1. Select the cells you want to format.

  2. In the toolbar at the bottom of the screen, select  The Show ribbon button in Excel for iOS (Show ribbon).

  3. Open the tab menu and select the Home tab.

  4. Select the current font type to open the font menu, and then select the font type you want or adjust the font size to your liking.

Font formatting options in Excel for iOS

Use accessible font color

The text in your spreadsheet should be readable in a high contrast mode. For example, use bright colors or high-contrast color schemes on opposite ends of the color spectrum. White and black schemes make it easier for people who are colorblind to distinguish text and shapes.

  1. Select the cells you want to format.

  2. In the toolbar at the bottom of the screen, select  The Show ribbon button in Excel for iOS (Show ribbon).

  3. Open the tab menu and select the Home tab.

  4. Select Font Color, and then pick the font color you want.

Top of Page

Create accessible charts

Charts help make complex information easier to understand. To make charts accessible, use clear and descriptive language for the chart elements, such as the chart title, axis titles, and data labels. Also make sure their formatting is accessible.

Format a chart element

  1. Select the chart element you want to format, for example, the chart title.

  2. In the toolbar at the bottom of the screen, select  The Show ribbon button in Excel for iOS (Show ribbon).

  3. Open the tab menu and select the Home tab.

  4. Select the formatting options that make your chart element accessible, such as a larger font or well-contrasting colors.

Top of Page

Rename worksheets

Screen readers read worksheet names, so make sure those labels are clear and descriptive. Using unique names for worksheets makes it easier to navigate the workbook.

By default, Excel names worksheets as Sheet1, Sheet2, Sheet3, and so on, but you can easily rename them.

  1. Tap a sheet tab, and then select Rename.

    Rename sheet option in Excel for iOS

  2. Type a brief, unique name for the sheet.

Top of Page

Delete blank worksheets

Screen readers read worksheet names, so blank worksheets might be confusing. Do not include any blank sheets in your workbooks.

  1. Tap a sheet tab.

  2. Swipe left in the context menu, and then select Delete Sheet.

  3. Select Delete to confirm the deletion.

Top of Page

Test the accessibility of your worksheets

When your spreadsheet is ready, you can try a few things to make sure it is accessible:

  • Switch to the full desktop or web version of Excel, and then run the Accessibility Checker. The Accessibility Checker is a tool that reviews your content and flags accessibility issues it comes across. It explains why each issue might be a potential problem for someone with a disability. The Accessibility Checker also suggests how you can resolve the issues that appear. For instructions, go to Improve accessibility with the Accessibility Checker.

  • In the Excel for iOS app, you can try navigating the pages using the built-in screen reader, VoiceOver.

    1. To turn on VoiceOver, select Settings > Accessibility > VoiceOver, and then turn on the VoiceOver switch.

    2. To navigate the content on the spreadsheet, swipe left or right.

    3. Fix any accessibility issues you spotted when navigating with a screen reader.

Top of Page

See also

Everything you need to know to write effective alt text

Make your Word documents accessible to people with disabilities

Make your PowerPoint presentations accessible to people with disabilities

Make your Outlook email accessible to people with disabilities

Make your OneNote notebooks accessible to people with disabilities

Excel help & learning

In this topic

Best practices for making Excel spreadsheets accessible

The following table includes key best practices for creating Excel spreadsheets that are accessible to people with disabilities.

What to fix

Why fix it

How to fix it

Use a simple table structure for data only, and specify column header information.

Screen readers keep track of their location in a table by counting table cells.

Screen readers also use header information to identify rows and columns.

Create accessible tables

Add text to cell A1.

Screen readers start reading any worksheet from cell A1.

Add text to cell A1

Include alternative text (alt text) with all visuals.

Alt text helps people who can’t see the screen to understand what’s important in images and other visuals.

Add alt text to visuals

Add meaningful hyperlink text.

People who use screen readers sometimes scan a list of links.

Add accessible hyperlink text

Use sufficient contrast for text and background colors.

If your spreadsheet has a high level of contrast between text and background, more people can see and use the content.

Use accessible font format and color

Give all worksheets unique names, and remove blank worksheets.

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 worksheets

Delete blank worksheets

Top of Page

Create accessible tables

Tables can help you identify a set of data by name, and you can format the table using styles that make the data stand out. When you carefully name and format your table, you can be sure that everyone can understand your data.

It is also important to specify column header information and use a simple table structure to make sure that screen reader users can navigate the tables easily.

Name a table

By default, Excel names the tables you create as Table1, Table2, Table3, and so on. To make it easier to refer to a table, give each table a descriptive name. A meaningful table name like "EmployeeList" is more helpful than the generic "Table1."

With the descriptive name, you can, for example, easily refer to the table in formulas. When table names are used, you can also quickly jump to the table with the Go To command in the Excel desktop app.

  1. Place the cursor anywhere in the table.

  2. In the toolbar at the bottom of the screen, select Cards View button in Excel for Android (Cards View).

  3. At the upper-right corner, select Table settings button in Excel for Android (Table settings).

  4. Tap the default table name, and replace it with a descriptive name.

Table name text field in Excel for Android

Note: Table names must start with a letter, an underscore (_), or a backslash (\) and cannot contain spaces. For more info, see section "Important notes for names" in Rename an Excel table.

Select an accessible table style

Light colored tables with low contrast can be hard to read. To make your table more accessible, select a table style that has colors with a strong contrast. For example, choose a style that alternates between white and a dark color, such as black, dark grey, or dark blue.

  1. Place the cursor anywhere in the table.

  2. In the toolbar at the bottom of the screen, select The More options button in Excel for Android (More options).

  3. Open the tab menu and select the Table tab.

  4. Select Table Styles, and then select the style you want.

Use table headers

Screen readers use header information to identify rows and columns. Clear table headers provide context and make navigating the table content easier.

Add headers to an existing table

  1. Place the cursor anywhere in a table.

  2. In the toolbar at the bottom of the screen, select The More options button in Excel for Android (More options).

  3. Open the tab menu and select the Table tab.

  4. Select the Header Row option.

    Tip: When the option is selected, it’s gray.

    Header row option selected for a table in Excel for Android

  5. Type the column headings.

Add headers to a new table

  1. Select the cells you want to include in the table.

  2. In the toolbar at the bottom of the screen, select The More options button in Excel for Android (More options).

  3. Open the tab menu and select the Insert tab.

  4. Select Table.

  5. Select the Table has headers checkbox.

Table, with the Table has headers check box selected

Table structures to avoid

Design your tables keeping in mind the following:

  • Avoid blank cells, columns, and rows. When navigating using the keyboard, a blank cell, column, or row might lead a screen reader user to believe there is nothing more in the table.

    • If there is no need for a blank cell, column, or row, consider deleting it.

    • If you cannot avoid a blank cell, column, or row, enter text explaining that it is blank. For example, type N/A or Intentionally Blank.

  • Avoid splitting or merging cells: 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. Merged or split cells can make navigating Excel tables with assistive technologies very difficult, if not impossible. Always keep your tables straightforward and simple.

Top of Page

Add text to cell A1

A screen reader starts reading any worksheet from cell A1. If you have a table on the worksheet, A1 should preferably be the title of the table.

If the sheet is long or complex, add instructions or an overview of the sheet in cell A1. This will inform people who are blind what’s being presented in your worksheet and how to use it. This instructional text can match the background color. This will hide it from people who can see, but allows it to be read by screen readers.

Top of Page

Add alt text to visuals

Alt text helps people who can’t see the screen to understand what’s important in visual content. Visual content includes pictures, graphics, shapes, groups, charts, embedded objects, ink, and videos. In alt text, briefly describe the image and mention its intent. Screen readers read the text to describe the image to users who can’t see the image.

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.

Tip: To write a good alt text, make sure to convey the content and the purpose of the image in a concise and unambiguous manner. The alt text shouldn’t be longer than a short sentence or two—most of the time a few thoughtfully selected words will do. Do not repeat the surrounding textual content as alt text or use phrases referring to images, such as, "a graphic of" or "an image of." For more info on how to write alt text, go to Everything you need to know to write effective alt text.

Note: For audio and video content, in addition to alt text, include closed captioning for people who are deaf or hard of hearing.

  1. Select the visual.

  2. To open the Picture, Shape, or Chart tab, select The More options button in Excel for Android (More options) in the toolbar at the bottom of the screen.

  3. Select Alt Text.

  4. Type a description.

Alt Text dialog box in Excel for Android.

Top of Page

Use accessible font format and color

An accessible font doesn't exclude or slow down the reading speed of anyone reading a spreadsheet, including people with low vision or reading disability or people who are blind. The right font improves the legibility and readability of the spreadsheet.

Use accessible font format

Here are some ideas to consider:

  • To reduce the reading load, select familiar sans serif fonts such as Arial or Calibri. Avoid using all capital letters and excessive italics or underlines.

  • A person with a vision disability might miss out on the meaning conveyed by particular colors. For example, add an underline to color-coded hyperlink text so that people who are colorblind know that the text is linked even if they can’t see the color.

  • For headings, consider adding bold or using a larger font.

  1. Select the cells you want to format.

  2. In the toolbar at the bottom of the screen, select The More options button in Excel for Android (More options).

  3. Open the tab menu and select the Home tab.

  4. Select the current font type to open the font menu, and then select the font type you want or adjust the font size to your liking.

Font formatting options in Excel for Android

Use accessible font color

The text in your spreadsheet should be readable in a high contrast mode. For example, use bright colors or high-contrast color schemes on opposite ends of the color spectrum. White and black schemes make it easier for people who are colorblind to distinguish text and shapes.

  1. Select the cells you want to format.

  2. In the toolbar at the bottom of the screen, select The More options button in Excel for Android (More options).

  3. Open the tab menu and select the Home tab.

  4. Select Font Color, and then pick the font color you want.

Top of Page

Create accessible charts

Charts help make complex information easier to understand. To make charts accessible, use clear and descriptive language for the chart elements, such as the chart title, axis titles, and data labels. Also make sure their formatting is accessible.

Format a chart element

  1. Select the chart element you want to format, for example, the chart title.

  2. From the context menu, select the Edit Text.

  3. Select the formatting options that make your chart element accessible, such as a larger font or well-contrasting colors.

Top of Page

Rename worksheets

Screen readers read worksheet names, so make sure those labels are clear and descriptive. Using unique names for worksheets makes it easier to navigate the workbook.

By default, Excel names worksheets as Sheet1, Sheet2, Sheet3, and so on, but you can easily rename them.

  1. Tap and hold a sheet tab, and then select Rename.

  2. Type a brief, unique name for the sheet.

Selected sheet tab, showing the Rename command

Top of Page

Delete blank worksheets

Screen readers read worksheet names, so blank worksheets might be confusing. Do not include any blank sheets in your workbooks.

  1. Tap and hold a sheet tab, and then select Delete Sheet.

  2. Select Delete to confirm the deletion.

Top of Page

Test the accessibility of your worksheets

When your spreadsheet is ready, you can try a few things to make sure it is accessible:

  • Switch to the full desktop or web version of Excel, and then run the Accessibility Checker. The Accessibility Checker is a tool that reviews your content and flags accessibility issues it comes across. It explains why each issue might be a potential problem for someone with a disability. The Accessibility Checker also suggests how you can resolve the issues that appear. For instructions, go to Improve accessibility with the Accessibility Checker.

  • In the Excel for Android app, you can try navigating the pages using the built-in screen reader, TalkBack.

    1. To turn on Talkback, select Settings > Accessibility > TalkBack, and then turn on the Use service switch.

    2. To navigate the content on the spreadsheet, swipe left or right.

    3. Fix any accessibility issues you spotted when navigating with a screen reader.

Top of Page

See also

Everything you need to know to write effective alt text

Make your Word documents accessible to people with disabilities

Make your PowerPoint presentations accessible to people with disabilities

Make your Outlook email accessible to people with disabilities

Make your OneNote notebooks accessible to people with disabilities

Excel help & learning

In this topic

Best practices for making Excel for the web spreadsheets accessible

The following table includes key best practices for creating Excel for the web spreadsheets that are accessible to people with disabilities.

What to fix

How to find it

Why fix it

How to fix it

Avoid common accessibility issues such as missing alternative text (alt text) and low contrast colors.

Use the Accessibility Checker.

Make it easy for everyone to read your spreadsheet.

Check accessibility while you work in Excel

Use a simple table structure for data only, and specify column header information.

To ensure that tables don’t contain split cells, merged cells, or nested tables, use the Accessibility Checker.

Visually scan your tables to check that they don't have any completely blank rows or columns.

Screen readers keep track of their location in a table by counting table cells.

Screen readers also use header information to identify rows and columns.

Create accessible tables

Add text to cell A1.

Make sure that you have text in cell A1.

Screen readers start reading any worksheet from cell A1.

Add text to cell A1

Include alt text with all visuals.

To find all instances of missing alt text, use the Accessibility Checker.

Alt text helps people who can’t see the screen to understand what’s important in images and other visuals.

Add alt text to visuals

Add meaningful hyperlink text.

To determine whether hyperlink text makes sense as standalone information and whether it gives readers accurate information about the destination target, visually scan the workbook.

People who use screen readers sometimes scan a list of links.

Add accessible hyperlink text

Use sufficient contrast for text and background colors.

To find insufficient color contrast, use the Accessibility Checker.

You can also look for text in your spreadsheet that’s hard to read or to distinguish from the background.

If your spreadsheet has a high level of contrast between text and background, more people can see and use the content.

Use accessible font format and color

Use an accessible template

Give all worksheets unique names, and remove blank worksheets.

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 worksheets

Delete blank worksheets

Top of Page

Check accessibility while you work in Excel

The Accessibility Checker is a tool that reviews your content and flags accessibility issues it comes across. It explains why each issue might be a potential problem for someone with a disability. The Accessibility Checker also suggests how you can resolve the issues that appear.

To launch the Accessibility Checker, select Review > Check Accessibility. The Accessibility pane opens, and you can now review and fix accessibility issues. For more info, go to Improve accessibility with the Accessibility Checker.

Top of Page

Create accessible tables

Tables can help you identify a set of data by name, and you can format the table using styles that make the data stand out. When you carefully name and format your table, you can be sure that everyone can understand your data.

It is also important to specify column header information and use a simple table structure to make sure that screen reader users can navigate the tables easily.

Name a table

By default, Excel names the tables you create as Table1, Table2, Table3, and so on. To make it easier to refer to a table, give each table a descriptive name. A meaningful table name like "EmployeeList" is more helpful than the generic "Table1."

With the descriptive name, you can, for example, quickly jump to the table with the Go To command (Ctrl+G). You can also easily refer to the table in formulas.

Note: Table names must start with a letter, an underscore (_), or a backslash (\) and cannot contain spaces.

For the step-by-step instruction on how to name a table, go to Rename an Excel table.

Select an accessible table style

Light colored tables with low contrast can be hard to read. To make your table more accessible, select a table style that has colors with a strong contrast. For example, choose a style that alternates between white and a dark color, such as black, dark grey, or dark blue.

  1. Place the cursor anywhere in the table.

  2. On the Table Design tab, in the Table Styles group, select the style you want.

Use table headers

Screen readers use header information to identify rows and columns. Clear table headers provide context and make navigating the table content easier.

Add headers to a new table

  1. Select the cells you want to include in the table.

  2. Select the Insert tab and then Table.

  3. Do one of the following:

    • If the selected range of cells contains data that you want to display as table headers, select the My table has headers checkbox.

    • If the selected range of cells does not contain data that you want to display as table headers, do not select the My table has headers checkbox. Excel will create a new header row above the selected cells, with the default header names (Column1, Column2, and so on)

  4. Select OK.

    The Create Table dialog box with the checkbox selected for the "My table has headers" option.

  5. Replace the default header names with new, descriptive names.

Add headers to an existing table

  1. Place the cursor anywhere in a table.

  2. On the Table Design tab, in the Table Style Options group, select the Header Row checkbox.

  3. Type the column headings.

Table structures to avoid

Design your tables keeping in mind the following:

  • Avoid blank cells, columns, and rows. When navigating using the keyboard, a blank cell, column, or row might lead a screen reader user to believe there is nothing more in the table.

    • If there is no need for a blank cell, column, or row, consider deleting it.

    • If you cannot avoid a blank cell, column, or row, enter text explaining that it is blank. For example, type N/A or Intentionally Blank.

  • Avoid splitting or merging cells: 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. Merged or split cells can make navigating Excel tables with assistive technologies very difficult, if not impossible. Always keep your tables straightforward and simple. To ensure that tables don't contain split cells, merged cells, or nested tables, use the Accessibility Checker.

Top of Page

Use an accessible template

Use one of the accessible Excel templates to make sure that your spreadsheet design, colors, contrast, and fonts are accessible for all audiences. The templates are also designed so that screen readers can more easily read the spreadsheet content.

When selecting a template, look for a template that has several features that support accessibility. For example:

  • Using enough white space makes the spreadsheet easier to read.

  • Colors with contrast make them easier to tell apart for low vision and colorblind readers.

  • Larger fonts are easier for low-vision users.

  • Preset descriptive headings and labels make the spreadsheet easier to understand for users who navigate it with a screen reader.

  1. In your browser, choose an accessible Excel template.

  2. Select Download. The template sampler is downloaded to your device.

  3. Open the sampler in the Excel desktop app, select the template you want to use, and then select Download template.

  4. A web page for the template opens. To open a new workbook with the selected template in Excel for the web, select Customize in Excel.

Top of Page

Add text to cell A1

A screen reader starts reading any worksheet from cell A1. If you have a table on the worksheet, A1 should preferably be the title of the table.

If the sheet is long or complex, add instructions or an overview of the sheet in cell A1. This will inform people who are blind what’s being presented in your worksheet and how to use it. This instructional text can match the background color. This will hide it from people who can see, but allows it to be read by screen readers.

Top of Page

Add alt text to visuals

Alt text helps people who can’t see the screen to understand what’s important in visual content. Visual content includes pictures, shapes, charts, pivot charts, ink, and videos. In alt text, briefly describe the image and mention its intent. Screen readers read the text to describe the image to users who can’t see the image.

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.

Tip: To write a good alt text, make sure to convey the content and the purpose of the image in a concise and unambiguous manner. The alt text shouldn’t be longer than a short sentence or two—most of the time a few thoughtfully selected words will do. Do not repeat the surrounding textual content as alt text or use phrases referring to images, such as, "a graphic of" or "an image of." For more info on how to write alt text, go to Everything you need to know to write effective alt text.

To find missing alt text, use the Accessibility Checker.

Note: For audio and video content, in addition to alt text, include closed captioning for people who are deaf or hard of hearing.

  1. Right-click the visual, and then select Alt Text to open the Alternative Text dialog box.

  2. In the Description text box, type 1-2 sentences to describe the visual and its context to someone who cannot see it.

    Note: We recommend only putting text in the description field and leaving the title blank. This will provide the best experience with most major screen readers including Narrator.

    Tip: To spell check and correct a word you typed, right-click the word and select from the suggested alternatives.

  3. Select OK.

Top of Page

Use accessible font format and color

An accessible font doesn't exclude or slow down the reading speed of anyone reading a spreadsheet, including people with low vision or reading disability or people who are blind. The right font improves the legibility and readability of the spreadsheet.

Use accessible font format

Here are some ideas to consider:

  • To reduce the reading load, select familiar sans serif fonts such as Arial or Calibri. Avoid using all capital letters and excessive italics or underlines.

  • A person with a vision disability might miss out on the meaning conveyed by particular colors. For example, add an underline to color-coded hyperlink text so that people who are colorblind know that the text is linked even if they can’t see the color.

  • For headings, consider adding bold or using a larger font.

For the step-by-step instructions on how to change the font style and size, go to Change the font style and size for a worksheet.

Use accessible font color

The text in your spreadsheet should be readable in a high contrast mode. For example, use bright colors or high-contrast color schemes on opposite ends of the color spectrum. White and black schemes make it easier for people who are colorblind to distinguish text and shapes.

Here are some ideas to consider:

  • To ensure that text displays well in a high contrast mode, use the Automatic setting for font colors. For the step-by-step instructions on how to change the font color, go to Format text in cells.

  • Use the Accessibility Checker to analyze the spreadsheet and find insufficient color contrast. The tool now checks the documents for text color against page color, table cell backgrounds, highlight, textbox fill color, paragraph shading, shape and SmartArt fills, headers and footers, and links.

  • Use an accessible template.

Top of Page

Create accessible charts

Charts help make complex information easier to understand. To make charts accessible, use clear and descriptive language for the chart elements, such as the chart title, axis titles, and data labels. Also make sure their formatting is accessible.

For the step-by-step instructions on how to add chart elements to your chart and make them accessible, go to Add or remove titles in a chart and Video: Create accessible charts in Excel.

Format a chart element

  1. Select the chart element you want to format, for example, the chart title or data labels.

  2. On the Chart tab, select Format. The Chart pane opens to the right, with the options available for the selected chart element.

  3. Select the formatting options that make your chart element accessible, such as a larger font or well-contrasting colors.

Top of Page

Rename worksheets

Screen readers read worksheet names, so make sure those labels are clear and descriptive. Using unique names for worksheets makes it easier to navigate the workbook.

By default, Excel names worksheets as Sheet1, Sheet2, Sheet3, and so on, but you can easily rename them. For the step-by-step instructions on how to rename worksheets, go to Rename a worksheet.

Top of Page

Delete blank worksheets

Screen readers read worksheet names, so blank worksheets might be confusing. Do not include any blank sheets in your workbooks.

For the step-by-step instructions on how to delete worksheets, go to Insert or delete a worksheet.

Top of Page

Test the accessibility of your worksheets

When your spreadsheet is ready and you've run the Accessibility Checker to make sure it is inclusive, you can try navigating the spreadsheet using a screen reader, for example, Narrator. Narrator comes with Windows, so there's no need to install anything. This is one additional way to spot issues in the navigation, for example.

  1. Start the screen reader. For example, to start Narrator, press Ctrl+Windows logo key+Enter.

  2. Do the following to test your worksheets:

    • Press Ctrl+F6 until the focus, the blue rectangle, is on the worksheet table grid. Use the arrow keys to move between the cells in the table grid.

    • If your worksheet contains floating shapes such images, press Ctrl+F6 until the focus is on the worksheet table grid, and then press Ctrl+F6 one more time. You hear "Grid," and the focus is on one of the floating shapes. Then, to cycle through the floating shapes, press the Tab key or Shift+Tab. To return to the normal navigation, press Esc.

    • To check the worksheet names in your spreadsheet, press Ctrl+F6 until the focus is on the name of the current worksheet, and then use the Tab key and Shift+Tab to hear the other worksheet names.

  3. Fix any accessibility issues you spotted when navigating with a screen reader.

  4. Exit the screen reader. For example, to exit Narrator, press Ctrl+Windows logo key+Enter.

Note: Also make sure that your worksheets can be easily read on a mobile phone. This not only benefits people who have low vision and use magnification, but it also benefits a very broad set of mobile phone users.

Top of Page

See also

Rules for the Accessibility Checker

Everything you need to know to write effective alt text

Make your Word documents accessible to people with disabilities

Make your PowerPoint presentations accessible to people with disabilities

Make your Outlook email accessible to people with disabilities

Make your OneNote notebooks accessible to people with disabilities

Excel help & learning

Technical support for customers with disabilities

Microsoft wants to provide the best possible experience for all our customers. If you have a disability or questions related to accessibility, please contact the Microsoft Disability Answer Desk for technical assistance. The Disability Answer Desk support team is trained in using many popular assistive technologies and can offer assistance in English, Spanish, French, and American Sign Language. Please go to the Microsoft Disability Answer Desk site to find out the contact details for your region.

If you are a government, commercial, or enterprise user, please contact the enterprise Disability Answer Desk.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Find solutions to common problems or get help from a support agent.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×