Creating Accessible Excel Sheets

Overview 

This guide covers best practices for creating accessible Excel workbooks in alignment with WCAG 2.1 and Section 508 standards. Here is a brief overview of what the guide covers: 

• File properties
• Document structure
• Tables
• Hyperlinks
• Color
• Images and non-text objects
• Embedded multimedia
  
  

File Properties 

A workbook's accessibility starts with how it is initially prepared. The document properties, or metadata, are identifiers embedded within a file, such as title, author, and language. 

Saving an Excel File 

Save Excel worksheets with a descriptive file name in the .xlsx format. Having names like "Document1" won't provide enough information about the file's contents. Descriptive file names make it easier for users to locate files without opening them and navigate between open documents.  

To save a file, go to the File tab in the navigation ribbon. Select Save As, choose Excel Workbook as the file type, and enter your file name in the "Enter file name here" field. 

File Title 

The file title should not be confused with the external file name used when initially saving a workbook or the title of the first sheet. The external file name is used within applications such as File Explorer and Finder to search for files. A file name can be easily changed by anyone with the file downloaded, but the title embedded within the workbook's properties will remain unless deliberately edited. This helps preserve the creator's intended label for the content, regardless of how the file is renamed externally. 

To edit the title of a workbook: 

1. Go to the File tab and select Info. 
2. In the Properties section locate the Title field. 
3. Enter the title of the workbook. 
   
   

When reviewing the document properties, ensure that the title describes the content within the workbook accurately. 

Set Language 

Assistive technology uses the document's set language to determine how to pronounce the words. To set the language, go to the Review tab, select Language, then Set Proofing Language, and choose English language. If any portion of your workbook is written in a different language than the rest, highlight the text and set its language separately. 

Document Structure 

Use Excel's built-in tools to create and organize content to ensure compatibility with assistive technology. Avoid creating custom elements for layout design by using visual devices such as color, shading, or patterns to create tables. These custom elements have no underlying structure and can't be read by assistive technology. 

Vital Background Information 

Vital information embedded in watermarks, headers, and footers in Excel may not be read during normal screen reader navigation and could be missed by users relying on assistive technology. Common examples include confidentiality notices or time-sensitive details that appear in headers, as well as watermarks. To ensure that all users can access this information, duplicate the vital information and place it within cell A1. 

Navigation and Headings 

Accessible Excel worksheet content must follow a logical reading order from left to right and from top to bottom beginning at cell A1. For this reason, users should avoid creating visual layouts using unconventional methods such as adding white space between rows. Instead, use built-in formatting and spacing tools to create the desired layout. 

Naming Your Worksheets

When working with multiple worksheets, ensure that all worksheet tabs have a descriptive name. This name should be short and should clearly hint at the overall topic of the worksheet.  

By default, the sheet is named "Sheet1." To rename it, locate the tab at the bottom of the window and either double-click it to edit the name directly, or right-click and select Rename. 

Utilizing the Navigation Pane

When working in large workbooks, navigating through a large number of worksheets can become time-consuming. Excel's “Navigation Pane” makes this easier by providing a quick way to move through content. This feature is in View > Show > Navigation Pane. 

Heading Styles

Once your workbook is organized, use Cell Styles to help structure the content within each worksheet. Heading styles reflect hierarchy and importance within a worksheet. Use Cell Style tools to apply headings to your worksheet, beginning with Heading 1 to describe the overall page content, then use Heading 2 through Heading 4 for progressively nested sub-sections. Note that in Excel, the "Title" style is not a recognized or navigable heading style. 

To customize a heading appearance, right-click the desired heading style, select Modify, then select Format. This will open a window with choices for formatting such as Font, Alignment, Fill, and Border. 

Named ranges

When naming ranges, use descriptive names that clearly tell the user about the purpose of the range. Avoid generic names like "Range1" as these provide no context for users navigating the workbook. To name a range, select the desired cells, then type a descriptive name directly into the Name Box located to the left of the formula bar and press Enter. 

Ending the Worksheet

A good practice is to place an “End of Worksheet” marker in the first cell below your content using a heading style. This notifies the user that they’ve reached the end of the worksheet's content. 

Testing Navigation

When testing worksheet navigation, confirm that the sheet can be navigated using directional arrows and keyboard shortcuts, and that content follows a logical reading order matching the visual layout. If either condition is not met, the document fails to meet accessibility standards. For a final test, ensure that no blank sheets exist throughout the workbook. 

Tables 

A worksheet can visually resemble a table through borders, shading, and bold headers, but without using Excel's built-in Table features, the content lacks the structure that assistive technology needs to interpret information. 

Information from images of tables will not be accurately conveyed by screen readers and should be avoided. Merged or split cells and nested tables are also inaccessible, because they follow an illogical reading order and will not be read properly by assistive technology.  

Creating a Table 

When content needs to be converted to data table format, highlight the desired content and use the Format as Table tool in the Styles tab or Insert > Table. Both options will open the Table Design Tab in the navigation ribbon, where you can edit the elements of the table. 

Note: Tables should be used for tabular data and not just for visual layout organization.  

Naming a Table 

Naming components throughout the worksheet adds context and helps users understand the information present. To name a table: 

1. Locate the Properties section of the Table Design tab. 
2. Enter a descriptive name in the Table Name field.
    

Once the table is created, update column and row headings with descriptive names so users understand their relationship to table cells. 

Testing Table Accessibility 

Use the following tests to verify the accessibility of tables within Excel worksheets. 

• Table Name: Select the desired table, then locate the Editing section of the Home tab and use Find & Select > “Go To” to view all tables in the worksheet. Select a table and view the table properties in the Table Design tab. If a table name is not present, it fails to meet accessibility standards.  
  
  
• Table Headers: Select the first row/column cell of the table and verify that the Header Row and First Column checkboxes are selected in the Table Style options. If not, the table fails this test.  
  
  
• Table Structure: Select the desired table. If the Picture Format tab is in the ribbon instead of the Table Design tab, this is an image of a table and is inaccessible. 
  
  

Hyperlinks 

Hyperlinks and surrounding context should provide enough information about the destination and set user expectation before following the link. For example, instead of using phrases like "click here for more information," use descriptive text like "Download the 2026 Accessibility Guidelines (PDF)." Avoid using raw URL addresses because they will not give context to the user on what the purpose of the link is and where the destination will take them. The following steps describe how to create or edit a hyperlink. 

• To insert a link, copy the URL address, select the desired text, right-click and select the Link option. Paste the URL into the address field and select OK.  
  
  
• To edit the link text, right click the link and select Edit Hyperlink. In the Text to Display field update the link text. 
  
  

Ensuring Accessible Color 

People who are blind, with low vision, or colorblindness won’t have full access to information without sufficient contrast ratios between foreground and background present. This applies to images and graphical objects in addition to text.  

To meet WCAG standards, standard text (12pt) and images of text require a minimum contrast ratio of 4.5:1. Large scale text, images of large-scale text, graphical objects, and user interface components must have a contrast ratio of at least 3:1. 

Use of Color to Convey Information 

When elements such as color, size, and shape alone are used to convey meaning, a barrier to information is created for people who are blind, low vision, or colorblind. Text should always be the default for conveying information, so if you are going to use color for meaning, ensure that information is not lost for users who cannot perceive color as intended. 

Testing Color Contrast 

When using color for content, remember to check the contrast ratio using verification tools. Check contrast ratios using the  WebAIM Contrast Checker for a reliable tool that gives accurate readings based on up-to-date WCAG standards. If contrast does not meet a ratio of at least 4.5:1, adjust your colors until your contrast ratio meets the required standards. 

Images and Non-text Objects 

If an image or non-text object is present, descriptive alternative text must be provided so assistive technology can convey its purpose to the user. When writing alternative text, describe the object's purpose rather than its appearance.  

Visit our guide on Authoring Alternative Text for more information. 

Embedded Multimedia Descriptions 

Generally, it is not recommended to embed audio, video, or multimedia directly into an Excel worksheet as it can affect accessibility. When multimedia is necessary, consider linking to an external source rather than embedding it directly. 

If audio, video, or multimedia files are present, they should provide captions and/or transcripts for the user. Captions are synchronous text that plays with a video, and transcripts are separate text for users who cannot access the media directly or need visual descriptions from the video. Depending on the type of media, the guidelines will require different types of additional information. 

• Videos with audio must provide synchronized captions and audio descriptions. 
• Video-only content with no audio requires a descriptive transcript that includes visual information. Captures actions, movements, on-screen text, and visual events. A deaf user doesn't need it, but a blind user does. 
• Audio-only media such as podcasts must provide at least a basic transcript. Provides speaker dialogue and meaningful sounds like music or sound effects. A blind user doesn't need it, but a deaf user does.  
  
  

This guide was developed using Section 508 accessibility guidelines and related training resources. It is intended as a practical reference to support accessible design