The information pertains to both Excel and Google Sheets. Differences between the two are specified where they exist. In this article, a “worksheet” or “sheet” refers to an individual sheet (or tab). “Workbook” refers to the entire spreadsheet file, including all the individual sheets. A sheet (tab) can contain multiple data tables. 

Write a Worksheet Summary 

A1 is the first cell that will be read by adaptive technologies. Therefore, you should place a worksheet summary in the A1 cell of every sheet in your workbook. The summary should orient the user to the content, providing both a general description and instructions on how to navigate the data effectively. For example: "This worksheet includes two data tables. The first begins at cell A3 and lists travel expenses. The second begins at cell A50 and lists moving expenses." 

Each sheet (tab) should have a unique name that describes exactly what information is contained in the sheet. In other words, do not leave the sheets as their default “Sheet1”, “Sheet2” and so on. 

Write Clear and Meaningful Row and Column Labels 

Screen readers read the cells starting from A1 and moving left to right, announcing both the cell number and the contents of the cell. 

Screenshot of Spreadsheet

A screen reader would read cell A1 in this screenshot as “City Name A1”. 

You should strive to write clear, concise, and meaningful labels for each column and row. “City Name” as a column heading is a better choice than “Name” (which is not descriptive) or “Name of City” (which is not as concise).  

For columns that include header rows, define the parameters for datasets (e.g., lowest and highest values, rows/columns that define the limits of the dataset). 

Freeze Rows or Columns to Aid Usability 

Long lists of data are much easier to read if you freeze column or row headings to allow users to keep both the heading and the data visible. Freezing data aids usability by minimizing cognitive load, and prevents interference with a screen reader’s ability to read the data.  

Use Cell Styles to Indicate Heading Rows 

Visual manual formatting is largely inaccessible to people who use screen readers. For example, if you visually differentiate a header row by changing the font weight or background color of the cells, screen readers will not be able to see the difference. In Excel, you can use cell styles (similar to paragraph styles in word processing applications) to differentiate the header row. You will be prompted to indicate the header row when you transform a range of data (Insert > Table). 

Screenshot of Create Table Dialogue Box

This step may seem superfluous, but you need to tell Excel that you want to create a table from a selected range of data. This screenshot shows the dialog box you will use to tell Excel what cell range contains your data and the checkbox that lets you indicate the presence of a header row. 

Write Text-based Alternatives for Charts and Graphs 

Provide both a title and a text-based alternative for charts and graphs. The descriptive title that is displayed visually should be clear and descriptive, including the date range for the data, if applicable.  

Alternative text should describe the story of the results. Learn more about alternative text for charts and graphs

Avoid Merging Cells 

Avoid merging cells wherever possible, as merged cells can be confusing for screen reader users and difficult to navigate for keyboard-only users. 

Avoid Blank Cells 

Sometimes we want to place blank columns or rows in between to visually indicate different tables located in the same sheet. When you do this, make sure your table summary is descriptive enough to let screen reader users know there is more than one table; a screen reader user might encounter a blank cell and believe that cell to indicate the end of the data set. 

Formulas are A-OK 

Screen readers will read the formulas contained in cells.  

Filters are A-OK 

Filters allow you to display or hide select pieces of information, which can help you achieve your data display goals. Feel free to use filters to control the display of content, as they do not affect the screen reader user’s ability to read the content of cells. 

Pivot Tables are A-OK 

Pivot tables are accessible to screen readers, and they can assist with your ability to present a cohesive story using data. Go ahead and use pivot tables wherever they make sense for your data and goals. 

Notes and Comments are A-OK 

Both comments and notes are screen reader accessible according to Google documentation. The screen reader will announce the presence of notes and comments as they are encountered, and Excel keyboard shortcuts include one that lets users skip from one note or comment to the next.


Article ID: 115374
Wed 9/2/20 12:33 PM
Wed 4/7/21 9:54 AM