How to Make Footnotes Accessible in MS Excel
Today’s post explores four practical methods for making footnotes and references accessible in Microsoft Excel. Each is designed to align with WCAG 2.1 AA standards and improve usability for screen reader users.
Video Guide
Microsoft Excel doesn’t offer a way to programmatically connect references or footnotes to the data they describe. You can’t use superscripts or linked notes the way you might in Word or PDF. But there are four effective techniques that bring you closer to accessibility standards like WCAG 2.1 AA.
1. Inline Integration
The most accessible approach is to embed the note directly into the spreadsheet. You can do this in one of two ways:
Option 1: Use a “Notes” Column
Add a new column labeled “Notes” or something similar. In each row, insert the full explanatory text for the related data. If a row doesn’t need a note, enter “None” or leave it blank.
This approach keeps everything visible and lets screen readers capture the context in one pass. Use the “Wrap Text” setting (found under Format Cells > Alignment) to display long text cleanly within each cell.
Option 2: Write the Note Inside the Same Cell
If you don’t want to use an additional column, write the note in brackets inside the same cell. For example:
Effective 12/15/25 [Results are preliminary]
This method increases the cell’s length, but it places all information in one location without requiring extra navigation.
2. Referencing Notes with Brackets and a Secondary Table
When you need to use multiple notes, create references with bracketed labels like [Note 1], [Note 2], etc., and build a separate table below your main data with matching note information.
In the data cell, remove any superscript and insert [Note 1].
Below your table, create a new table with two columns: “Note” and “Note Information.”
Add rows like:
| Note | Note Information |
|---|---|
| Note 1 | Offer valid until 12/15/2025 |
| Note 2 | Includes extended service coverage |
This method maintains structure and lets users match the reference easily without relying on superscripts.
3. Using Comments for Supplementary Information
You can also use Excel’s comment feature, but only for non-essential information.
Right-click the data cell and choose “New Comment.”
Enter the supplementary information and save the comment.
This method isn’t ideal for critical content because screen readers won’t detect comments unless the user actively enters the cell and uses a keyboard command to read the note. Comments also won’t export well if you convert the file to other formats.
4. Linking with Named Ranges and Hyperlinks
Advanced users can create internal links that jump from a data cell to a related note elsewhere in the workbook.
Select the cell that contains the full note.
Go to the Formulas tab and open the Name Manager.
Define a new name, like
Note1, for the selected cell.Return to the original data cell and insert a hyperlink.
Choose “Place in This Document,” then select the named range (
Note1).Click “Edit Hyperlink” to add a screen tip like “See note details.”
This approach lets users click the cell and jump directly to the note, improving navigation. It requires setup and clear labeling, but works well for large spreadsheets.
These four methods provide flexible ways to handle references in Excel, even without built-in accessibility features. Choosing the right approach depends on the type of information you’re presenting and how essential it is to the data. With the right structure, you can keep your spreadsheets organized, readable, and accessible.
And when your spreadsheet is complete, don’t forget to run it through the accessibility checker!
Let me be your champion for inclusion. I offer tailored solutions (and self-paced courses!) to ensure your documents meet and exceed compliance expectations. For more detailed insights, tutorials, and in-depth discussions on accessibility and related topics, don’t forget to check out my YouTube channel: The Accessibility Guy on YouTube. Subscribe for regular updates!
Responses