LCC's Accessibility Guidelines
Google Sheets
Google Sheets
General
Google Sheets Accessibility Rule | How To Fix |
---|---|
Spreadsheet has a proper title. The title of a document identifies the content of the document. Titles are important because they distinguish documents from one another and identify the focus of the document. |
To add or edit the title:
|
All sheet tabs have unique names, and blank sheets are deleted. Sheets in the workbook should include a descriptive title. Blank sheets should be deleted. Screen readers read sheet names, which provides information about what is found on the worksheet. Descriptive sheet names, such as “October sales totals,” make it easier to understand the contents of and navigate through workbooks. |
To rename a sheet:
To delete sheet tabs:
|
Sufficient contrast between text and background is present. People with low vision, poor vision, or color blindness often find it hard to read text that does not contrast with the background. Avoid the use of font colors such as pink, yellow and orange. |
To edit text font color:
|
Negative numbers are identified using multiple means, not just red font color. Users who have difficulty distinguishing colors will not be able to tell the difference between positive and negative values. |
To Add Additional Means:
Note: Red font color may be used as well as the parenthesis format as an indicator that the number is negative. |
Spreadsheet has a simple structure. Users rely on simple spreadsheet structures to navigate via keyboard shortcuts and screen reading technologies. Spreadsheets should have a simple, two-dimensional structure so that they can be easily navigated and understood. This means there should be no merged cells, or nesting tables within another table as they can change the reading order of the spreadsheet. |
To remove merged cells:
Restructure nested items by: Reformatting the content into a simple format- bulleted list, numbered list, etc. |
Images
Google Sheets Accessibility Rule | How To Fix |
---|---|
Alternative text (alt text) is provided for all non-text content, including Images, Drawings, Elements (arrows, lines, etc.), or Charts. Alternative text is a textual alternative for an image that makes it easier to connect the image to its context and allows users with visual impairments to perceive the image. Images that do not provide any meaning or content, also known as decorative images, should be identified as such. Images identified as decorative will be skipped over by screen readers so be purposeful when identifying images as decorative. |
To add/edit/review alternative text:
Repeat this process for all images throughout the document/presentation. |
Images do not have contrast issues. Images that contain text with low contrast between the text and its background can cause the text to be difficult to read, especially for those with low vision, poor eyesight or color blindness. |
If you have access to an editing program, such as Photoshop: Upload the image into a program to increase the contrast. If you do not have access to an image editing program:
|
Images or other multimedia are not prone to induce seizures. Animated images that contain flashing or contrasting lights or patterns can lead to seizures for people that suffer from photosensitive epilepsy. In addition, animated images with these characteristics can be generally unpleasant to look at, even for those not prone to seizures. |
Find an alternative image. Do not use this image. |
Tables
Google Sheets Accessibility Rule | How To Fix |
---|---|
Table layouts are structured for easy navigation and proper reading order. Users rely on the table layout to navigate through the content. Tables must be ordered logically for users to understand and navigate the content. It is important to ensure that the reading order of the table makes sense. Screen reader technologies read tables from left to right, top to bottom, one cell at a time (no repeats). |
To test the reading order:
This will be the reading order that assistive technologies follow. |
Tables specify column header information. Users rely on the table headings to understand the content that is subsequently read by the screen reader. Also, screen reading technologies often use the table header row to help convey to the user the current cursor location in the table and to provide information that enables the user to navigate the table. Tables should not be used for layout purposes. If a table does not need headings (the top row or first column does not serve as a label for the data/info underneath/beside) then do not use a table. |
Note: Currently, there is not a way to identify header information in Google Slides. Instead, users are encouraged to download and open the Google Sheet in MS Excel to set the header row.
|
This page content is offered under a CC Attribution license.