DOCUMENT ACCESSIBILITY / EXCEL

Make a workbook people can find their way around

A useful spreadsheet helps people find a sheet, understand its numbers, and complete a task. Give the workbook a clear starting point, then check its tables, charts, and interactions.

Start with the first stepKeep review notes

Excel workbooks (.xlsx) · 8 practical steps · Updated 23 September 2026

START HERE

Work on a copy of the workbook. These steps focus on Microsoft 365 Excel; menus and assistive-technology behavior vary between Windows, Mac, and the web. Named Windows paths apply to that version.

Work through your Excel file

STEP 01

Give the workbook a clear starting point

Readers should not have to explore dozens of cells to discover what a sheet contains or where to begin.

  1. Give sheets short, distinct names such as 'Read first', 'Workshop bookings', and 'Monthly totals'. In Excel for Windows, open a sheet tab's context menu and choose Rename.
  2. Put a brief title or introduction in A1, with instructions near the top of each sheet. Say where the data starts; do not assume a screen reader always opens at A1.
  3. Order sheets to match the task. Use consistent labels and layouts across related sheets, and add a contents sheet for a larger workbook.
  4. Remove unused blank sheets after checking that they are not needed. Explain abbreviations, units, reporting dates, and what readers can edit.

Check it: Open the workbook as a new reader. Can you identify its purpose, choose the right sheet, and find the first useful cell?

Microsoft: Rename a worksheet · Microsoft: Excel accessibility best practices · Section508.gov: Accessible spreadsheet design

STEP 02

Make the data's structure clear

A reader needs to connect each value with its label. Bold cells and borders alone do not establish those relationships.

  1. For a rectangular data set, select its range and use Insert > Table. Confirm the range, select My table has headers when appropriate, and replace generic headers with meaningful labels.
  2. Give each table a useful name, such as WorkshopBookings. In Excel for Windows, select a table cell and use Table Design > Table Name.
  3. Keep one item or value per cell. Avoid merged headers and merged data cells that make movement or interpretation difficult; divide complex data into simpler, clearly labeled tables.
  4. Keep each data region continuous. Remove unnecessary blank rows and columns inside it; use formatting for separation. Explain missing values without changing numeric data or breaking formulas.

Check it: Move through a data row and then a column. Can you identify the relevant labels and understand what each value means?

Microsoft: Create more accessible tables in Excel · Section508.gov: Accessible spreadsheet design

STEP 03

Help people move around without a mouse

Large sheets are easier to use when movement, links, and visible labels remain predictable.

  1. Try the main task using only the keyboard: change sheets, move between cells, reach a table, and operate any filters or links. Keep instructions in the same predictable place on related sheets.
  2. Use descriptive links such as 'Read the booking instructions' or 'Open monthly totals'. Check their destination and permissions, including links within the workbook.
  3. Consider meaningful names for important ranges. Test that a reader can use Excel's Go To command to reach them, and explain the names in the workbook's introduction.
  4. In Excel for Windows, View > Freeze Panes can keep labels visible while scrolling. Freeze only what helps, use it consistently, and check the remaining space when enlarged. Freeze Panes does not establish semantic table headers.

Check it: Follow a link, find a particular total, and return to the instructions using the keyboard. Confirm that frozen areas do not obscure the cells you need.

Microsoft: Navigate Excel with a screen reader · Microsoft: Work with links in Excel · Microsoft: Freeze panes

STEP 04

Explain charts and visual meaning

A chart needs to communicate its message to someone who cannot see its colors, labels, or shape.

  1. Give charts meaningful titles, axis labels, and units. Make labels large enough to read in the intended view, and check that text and important graphical elements stand out from their backgrounds.
  2. Add useful alt text to a chart or meaningful image. For a chart, explain the main comparison or trend and say where readers can find the fuller explanation or data.
  3. Provide the values and relationships readers need in an accessible table or nearby text. A short alt-text label such as 'Sales chart' does not replace that information.
  4. Use labels, patterns, or other cues alongside color. Write 'Overdue' or 'Complete' in a status cell instead of depending on a red or green fill.

Check it: Read the chart explanation and supporting data without looking at the chart. Can you answer the same question the chart is intended to answer?

Microsoft: Create more accessible charts in Excel · W3C: Complex image descriptions · Section508.gov: Accessible spreadsheet design

STEP 05

Make data entry and instructions understandable

People need to know what they can enter, which formats are accepted, and how to correct a mistake.

  1. Label input cells and explain units, date formats, permitted values, and required entries in ordinary worksheet cells. Distinguish input and calculated cells with words as well as formatting.
  2. In Excel for Windows, review Data > Data Validation. Give input messages and error alerts specific, helpful wording, then try both a valid and an invalid entry.
  3. Test dropdowns and validation messages with the keyboard and the assistive technology your readers use. Keep essential instructions visible in cells as well; a popup may be missed.
  4. Review threaded comments and notes separately. Comments support discussions; notes add annotations. Move any essential directions into the sheet itself and check that any retained comments or notes can be reached.

Check it: Can someone enter a value, understand a rejected entry, and correct it without hovering over cells or relying on color?

Microsoft: Apply data validation to cells · Microsoft: Threaded comments and notes

STEP 06

Check what is hidden and what is calculated

Missing context and unexplained errors can make a workbook difficult to trust or use. Their accessibility impact depends on the task and how information is presented.

  1. Review hidden rows, columns, and sheets. Make information needed for the reader's task available, and explain any intentional filtering or hidden detail. Hidden content is not automatically an accessibility failure.
  2. Check formulas and totals with realistic inputs, including empty or missing data. In Excel for Windows, use Formulas > Formula Auditing > Error Checking to investigate flagged results.
  3. Explain or fix unexpected values such as #REF! or #DIV/0!. Do not replace every error with zero: zero, missing data, and a failed calculation mean different things.
  4. Explain important assumptions beside results. If formulas depend on another workbook, check that readers can obtain the necessary information or understand the saved results.

Check it: Can someone understand a total and its assumptions without discovering a hidden sheet? Do missing data and calculation problems have an understandable explanation?

Microsoft: Hide or unhide worksheets · Microsoft: Detect formula errors · Microsoft: Display relationships between formulas and cells

STEP 07

Use the checker, then try the reader's task

A checker can flag some problems, but it cannot judge every label, explanation, interaction, or data relationship.

  1. Open Review > Check Accessibility and work through the findings. Review generated descriptions and suggested changes before accepting them.
  2. Enlarge the workbook and inspect each sheet. Check for clipped text, unreadable labels, weak contrast, and a layout that becomes difficult to follow.
  3. Repeat the main task using only the keyboard. Then use a screen reader, or work with someone familiar with one, to check sheet names, table headers, values, charts, links, and inputs.
  4. Record the Excel version, operating system, assistive technology, tasks tested, and unresolved issues. A clean checker result or completed worksheet is not proof of conformance.

Check it: Can a reader find a record, identify its headers, understand a chart, and enter or filter data where the task requires it?

Microsoft: Accessibility Checker rules and limitations · Microsoft: Navigate Excel with a screen reader

STEP 08

Review the workbook people will receive

Sharing settings, exports, and different applications can change what a reader can access. Check the delivered version as well as your working copy.

  1. Save with a descriptive filename and open the actual attachment or shared link. Check the intended permissions and whether people can read or edit what the task requires.
  2. Repeat the key navigation and data-entry checks in the expected application. If recipients use Excel for the web or another spreadsheet program, check that environment too.
  3. If you also supply a PDF, inspect that file separately for clipped content, missing sheets, reading order, and structure. A checked workbook does not guarantee an accessible PDF.
  4. Keep the checked workbook available when readers need its data or calculations. Tell recipients how to report a barrier or request another usable format.

Check it: Download or reopen the final file as a recipient. Can you still find the instructions, follow the data, and complete the intended task?

Section508.gov: Accessible spreadsheets · Microsoft: Print a worksheet or workbook · Microsoft: Create accessible PDFs

Content that may need additional review

These checks cover common issues. Specialist content, interactive elements and unusual layouts can need more testing and repair. Take extra care with:

  • Equations, footnotes and endnotes; tracked changes and comments.
  • Forms, content controls, signatures and embedded Office objects.
  • SmartArt, complex diagrams and tables, columns and watermarks.
  • Mixed-language text and unusual writing directions.
  • Animations, flashing or moving content, and linked or embedded audio and video.

Try the actual task in the software people will use. Record what you could not test and involve someone with the relevant document and assistive-technology experience when needed.

What that looks like in practice

A workbook with a starting point

Before

Sheet1 opens to empty cells. Bookings start at H18, and instructions are stored in a note.

Try this

The 'Workshop bookings' sheet starts with a title and short instructions in A1. A named table follows, with a 'Read first' sheet explaining the workbook.

Readers can discover the task and find the data without exploring the whole grid.

A chart that explains the result

Before

A chart called 'Chart 2' uses three colored bars and the alt text 'Attendance'.

Try this

The chart is titled 'Workshop attendance, April to June'. Its description explains the increase from 12 to 25 people and points to a table containing all three monthly totals.

Readers get the message and can look up the values without interpreting the colors.

An error someone can correct

Before

A red input cell displays 'Invalid value' after someone enters 35.

Try this

The cell is labeled 'Number of participants (1 to 30)'. Its error message says 'Enter a whole number from 1 to 30', and the same instruction appears beside the input.

The reader knows what went wrong and how to correct it without depending on the cell's color.

When something still isn’t working

A reader cannot tell which heading belongs to a value.

Use a simple table with meaningful headers, remove ambiguous merged cells, and test header announcements in the reader's Excel and screen-reader combination. Frozen labels alone do not solve this.

The sheet seems to end before all the data is reached.

Look for unnecessary empty rows or columns within the data region, hidden content, and active filters. Keep the region continuous and explain any deliberate exclusions.

A chart has alt text but still does not explain the data.

Describe the useful comparison or trend and provide the values and relationships in an accessible table or text. Check that the chart and explanation agree.

A dropdown or input message cannot be used reliably.

Put instructions in worksheet cells, retest keyboard and screen-reader operation, and provide a usable alternative for the task if the interaction still blocks readers.

Go to the original instructions

App menus and features can change. Use the instructions for your version, then check the file people will receive.

Original explanations and examples informed by these references. This guide supports practical checks; it does not replace a complete accessibility evaluation. Understand authoring, review and formal evaluation.