Create an Accessible Spreadsheet in Excel
Titles
Cell A1
Font
Color Contrast
Alt Text
Tables
Using Blank Rows for Layout
Charts and Graphs
Name cells and ranges
Headings
Hyperlinks
End of Worksheet
How to Check Accessibility
Things to consider
Resources
When developing an Excel spreadsheet, it is crucial to ensure accessibility for all users, including those who rely on assistive technologies. This guide provides a summary of best practices for creating an accessible Excel document that follows Web Content Accessibility Guidelines (WCAG) and Washington State University (WSU) standards.
When creating documents in Excel, use the formatting tools provided within the program. These tools are built to maximize accessibility to documents for all users.
All documents must have a default document title.
To set a default document title:
In your main menu bar select File.
Next, select Info, and under Properties select the Title field.
Write the title of your document there.
Excel spreadsheets must be saved in a xlsx format.
Worksheet titles must be distinct and clearly define the sheet's content. Note that sheet titles are limited to thirty-one characters, so be concise.
Ensure cell A1 contains information for a screen reader to identify the starting point. This could be the spreadsheet or table title. For complex spreadsheets, use this cell to provide an overview or instructions.
While the WCAG require that you use a plain easy to read font, WSU has several recommended fonts. The three Microsoft Office fonts are Corbel, Arial, and Baskerville Old Face (seen here as a 12-point version). WSU recommends that you use 12 points or larger.
Outside of titles and headings, text should be in the "normal" style.
Understanding Accessible Fonts and Topography for Section 508 Compliance
Avoid using color as the sole method to convey information, as individuals with visual impairments may not perceive it. Use additional methods like text labels or patterns.
When using color:
Ensure a 4.5:1 contrast ratio for readability.
Use an application such as Colour Contrast Analyser to check if you are not sure about your document’s color contrast or an online checker such as WebAIM: Color Contrast Checker and/or WebAIM: Link Color Contrast Checker to check contrast.
WSU Digital Accessibility Core Concepts – Color Contrast
Alt Text allows a screen reader to scan a description of an added table, figure or image and state what is important about it.
To add alt text:
Right-click on image and select View Alt Text.
A box will appear on the left. Excel will automatically describe the image. Adjust the description as needed.
Once the description is complete, close the box. Note: selecting 'Generate alt text for me' will overwrite any description in the box with a generated description.
Repeat this process for all images in the document.
For images that are purely decorative, select the "Mark as Decorative" option.
Note: You can keep the Alt Text box open when working with several images.
Example:
WSU Digital Accessibility Core Concepts - Images
Create accessible data tables using Excel's built-in features.
Ensure all tables have a clear structure with headers.
Add a title in the Table Name field (found in the Table Design tab) that clearly describes the table's content. For example, use "May 2025 Payroll Expenses for Parttime Staff" instead of "Last Month's Numbers." Note: table names must start with an "_" and cannot include spaces (_May2025PayrollExpensesforParttimeStaff).
Refrain from splitting or merging cells that contain data. Merged cells can be used for titles outside of your table but note that some older screen readers may have difficulty with merged cells.
When using multiple tables, maintain consistent row and column numbers. Leave space between tables to keep them distinct.
Do not use images of tables.
WSU Digital Accessibility Core Concepts - Tables
Microsoft Tutorial – Accessibility Best Practices with Excel Spreadsheets
When using a blank row for layout, merge the cells to match the width of the content area. Add the text "No Data" or "Intentionally Left Blank" in the row. This text can be hidden by using a font color that matches the background color (e.g., white text on a white background).
Charts and graphs that use color to convey meaning must have another visual element like a symbol or text to convey the same meaning.
Use clear, descriptive language for the title, axis titles, and data labels.
Provide alt text for all charts and graphs. If the information is too complex to describe in the alt text, a detailed description should be provided elsewhere. Provide a summary and instructions for where to find the full description in the alt text.
Data Visualizations, Charts and Graphs
Name cells and ranges so screen reader users can quickly identify the purpose of cells and ranges in worksheets. Users can use Ctrl+G to open the dialog box which lists all the defined names. By selecting a name, a user can quickly jump to that information.
Select the cell or range of cells that you want to name.
Select Formulas > Define name.
Enter the name and select OK.
Note: The name must start with a letter, an underscore (_), or a backslash () and cannot contain spaces.
While headings are not often used in spreadsheets, it is important to understand that headings help a screen reader follow information hierarchies. If you have hierarchal information, such as topics with subtopics, it is a good practice to use the Headings within the Microsoft environment.
Customize headings by selecting Home > Cell Styles, right clicking the style, and choosing Modify.
Ensure hyperlinks have clear labels for screen readers.
Use concise, meaningful link text.
Verify the hyperlink's destination by right-clicking and selecting Edit Hyperlink.
Note: hyperlinks can move within a document or outside of the document.
Define the end of the worksheet by merging a single blank row with the text 'End of Worksheet.' This text can be hidden by using a font color that matches the background color (e.g., white text on a white background).
To check accessibility in Excel:
Select the "Review" tab in the main menu ribbon.
Select Check Accessibility to identify and fix issues.
Review your spreadsheet with a screen reader like Narrator:
Start Narrator with Ctrl+Windows logo key+Enter.
Use F6 to navigate and arrow keys to move between cells.
Test worksheet names and floating shapes.
Fix any issues identified.
Exit Narrator with Ctrl+Windows logo key+Enter.
Use Excel's accessible templates by searching for 'accessible templates' under File > New.
Ensure worksheets are readable on mobile phones.
Print your spreadsheet in greyscale to check readability.
Microsoft Tutorial – Accessibility Best Practices with Excel Spreadsheets
Section 508 Content Creation – Create Accessible Spreadsheets
Section 508 Spreadsheets
Accessibility.com How to Make Microsoft Excel Documents More Accessible