Microsoft Excel

Important Highlights

  • Table Headers: use simple table structure with column headers.

  • Table Title: be sure to title your table.

  • Tab Names: each sheet tab should have its own unique name.

  • Avoid Blanks: blank cells can cause confusion. If a cell must be blank, type "blank" or "no data" in the cell and change the font color to match the background.

  • Denote End of Sheet: this allows listeners to know that they have reached the end of the data. Type "end of worksheet" in the row following the last row of the table.

  • Hyperlinks: avoid using statements such as "click here" and "this link"; instead, use descriptive text for your hyperlinks so that students using assistive technologies know what they are clicking on.

  • Use of Color: ensure that the colors you use are of sufficient contrast; one good way to test this is to print the page in black and white and confirm that the differences can still be interpreted; WebAIM's Contrast Checker is also a good resource.

  • Alt Text: add alt text to visual content including tables, images, and graphs; right click on the content, select "Format [content type]", in the pane that appears select "Layout & Properties", and type your alt text into the description section.

Table Headers

Header information is used to identify rows and columns for those using assistive technology.

  • Select the cells you want to include in your table.

  • Click the "Insert" table and click "Table".

  • Ensure that the "My table has headers" checkbox is selected, then click "OK".

Table Title

The table title should be in the first cell of the first column of the worksheet. Do not merge and center your title.

If you number your table titles, type a period or colon after the table number, followed by a description of the table content.

Tab Names

Sheet tabs explain what is in each page and makes it easier to navigate, so each should have a unique name.

  • Right-click the sheet tab at the bottom of your Excel document (defaults to "Sheet#").

  • Click "Rename".

  • Type a name that describes the sheet contents and press Enter.

Avoid Blanks

Blank rows can cause confusion to those utilizing assistive technology by wrongly signaling the end of information.

Delete all blank rows and columns.

For blank cells, type the words "blank" or "no data" in the cell. If you don't want it to be visible, match the text color to the background color.

Denote End of Sheet

This enables listeners to know that they have reached the end of the data. Type "end of worksheet" or "end of data" in the row following the last row of your document. If Excel automatically extends the table to include this, just click on the "AutoCorrect Options" button that pops up and click "Undo Table AutoExpansion". Remember - if you do not want this text to be visible, change the text color to match the background color.

Hyperlinks

Hyperlinks are important to send a reader to more information, but the reader should know where they are going when they click the link and why.

  • Always use descriptive hyperlinks.

    • "Click here to learn more" doesn't help a person know where the link will take them.

    • Try to make the hyperlink a few words long so that people with weak motor skills can still use the mouse to click.

  • Hyperlink URL addresses should begin with http:// or https://.

Ensure that the content that the link takes the reader to is also accessible.

Use of Color

A significant portion of the population has some form of color blindness. It is important to not rely solely on color to convey the necessary information.

  • Partner color with other meaningful information like text, shape, or pattern.

  • Use high contrasting colors. If you're unsure if your colors contrast enough, check out WebAIM's online contrast checker.

One great way to check this is printing the document in black and white and reviewing - can the meaning still be understood without color?

Be conscientious of the theme options - not all of them have sufficient contrast.

Alt Text

When descriptive text is added to any visual element, communication is clear and direct because users can read and know the exact information others want them to know. Without descriptive text, communication is indirect and unclear because it relies on the user to be able to see and interpret the information in the picture.

  • Right click on the content

  • Hover over "Table"

  • Select "Alternative Text"

  • Type your alt text into the description section

Additional Considerations

  • Avoid serif fonts and italics unless it is required by specific formatting guidelines such as APA or MLA.

Difference between serif and sans serif fonts.

Accessibility Checker

All Microsoft Office products have a built-in Accessibility Checker to help ensure that the document is accessible. The Accessibility Checker for Excel is accessed in the same way as that for Microsoft Word.

  • Click on the "File" tab.

  • If needed, click "Info" at the top of the navigation pane that appears to the left of the screen. Usually, it will automatically open to the "Info" section.

  • Click the "Check for Issues" square towards the middle of the screen.

  • Click "Check Accessibility".

  • An Accessibility Checker pane will open to the right of the document.

  • When clicking on an issue listed in the Accessibility Checker pane, "Additional Information" will appear at the bottom of the pane with a scroll box explaining why the issue should be fixed as well as how to fix it.

  • Edit all errors/warnings listed in the Accessibility Checker pane as directed.