Use the following steps to create a spreadsheet in Microsoft Excel so it is accessible to all users.
Any unused worksheets should be deleted from the workbook.
All documents should have a meaningful title add which represents its content.
Open your Excel spreadsheet and select File from the Main Tabs then select Info from the list of items on the left side of the screen.
On the Info screen, type your descriptive title into the text field marked Title.
Each worksheet needs to have a distinctive title which references the spreadsheet's content. "Sheet 1" and "Sheet 2" are not considered descriptive titles.
To add a title to the worksheet, double click on the worksheet tab or use the keystrokes Alt+O, H, R.
Type in descriptive title then press enter to move focus off the renamed tab. Title all worksheet titles in a workbook should be unique values.
Be careful choosing color styles on your table. Make sure you do not present color as the only source of information and use high contrasting colors.
All images, charts, and graphics within a worksheet need to have alternative text. Microsoft products use the same steps to add alternative text to images and objects.
When designing accessible data tables it is important to remember that not everyone is able see the structure of the table and may need help the understand how the data is being presented. Oftentimes a data table may be used as an alternative text for complex images, graphs, and charts so it must to be accessible to assistive technologies.
Long URLs can be confusing and take up a lot of space in your spreadsheet.
Rick click on URL hyperlink then select Edit Hyperlink from drop down.
Type Descriptive text (i.e. purpose or target of the link) into the Text to Display field.
Note: If it is not possible to use descriptive link language in the Text to Display use the full URL, but add a ScreenTip. The Add a ScreenTip option is located to the right of the Text to Display field.
Hide all extra rows and columns outside the area being used to define the print area. This designates what cells to print when you don't want to print an entire worksheet. At the same time, setting the print area allows assistive technology users and keyboard-only users the ability to work only within the spreadsheet's data, and helps to keep them from getting lost in the unnecessary blank cells of the spreadsheet.
To hide rows and columns, select the first empty row or column closest to your data.
Hold the Shift Key down and press and release the End Key on your keyboard. Don't let go of the Shift key.
While still holding the Shift key press the Right Arrow to select all the blank columns to the end of the spreadsheet (use Down Arrow to select the blank rows). Keep holding down the Shift key.
Press and release the F10 key to open options drop down menu. Choose Hide (or press the H key) to hide all the blank cells. You can release the Shift key now.
Run the Microsoft Accessibility Checker.