Seven Steps to Creating an Accessible Excel Worksheet

1 Seven Steps to Creating an Accessible Excel Worksheet Disability Access Services i About Disability Access Services Centralized Resource and Information on Disability Access Disability Access Services provides technical assistance and informational guidance to promote the civil rights and equality for persons with disabilities in the following areas: Employment Reasonable Accommodation Physical Access of built environments Access to private sector goods and services Digital Access of electronic and information technology Access to government programs, services, and activities Disability Access Services Website Disability Access Services CA Department of Rehabilitation 721 Capitol Mall, 4th Floor Sacramento, CA 95814.

2 DAS Email: Voice (916) 558-5755. Fax (916) 558-5757. TTY (916) 558-5758. Telecommunications Relay Service 711. Promoting an Accessible Future through Education and Information ii Seven Steps to Creating an Accessible Excel Document TABLE OF CONTENTS. STEP ONE: ADD ALTERNATIVE TEXT TO IMAGES AND OBJECTS .. 1. STEP TWO: SPECIFY COLUMN HEADER INFO IN TABLES .. 4. STEP THREE: CREATE MEANINGFUL HYPERLINK TEXT .. 5. STEP FOUR: OTHER CONSTRUCTION CONSIDERATIONS .. 7. STEP FIVE: GIVE ALL SHEET TABS UNIQUE NAMES .. 7. STEP SIX: INCLUDE ALTERNATE FORMATS FOR MULTIMEDIA .. 8. STEP Seven : CHECK 8. Alternative Formats In accordance with ADA requirements, this document can be made available in Braille or large print as a reasonable accommodation for an individual with a disability.

3 To request a copy of alternative formats, please contact Disability Access Services. Equal Opportunity Employer/Program A Note About Hyperlinks in This Document All links in this document have been created with meaningful text. The Uniform Resource Locator (URL) is also published to be available as a resource for those persons who print the document. The URL addresses that are spelled out in the document are not active links to avoid the confusion of presenting duplicate links. iii Introduction It is estimated that up to 4% of the population relies on some sort of Assistive Technology to access electronic documents and Web pages. Assistive Technology includes; Screen Reading software, Refreshable Braille displays, and Screen Magnifiers.

4 In the United States alone that equals million people. If electronic documents are not created with accessibility issues in mind, they become very difficult if not impossible to read or navigate for this large number of people. Accessibility to electronic documents is a right that is protected by both Federal and State law. Creating Accessible electronic documents is important to ensure access to persons with disabilities and the company or agency is protected against legal action. Additionally, it is just good business, when a very large segment of the population can equally participate and take advantage of the products or services that the company or agency provides.

5 Disability Access Services of California Department of Rehabilitation has put together this list of Seven easy Steps to follow when Creating Excel documents. Take a few moments to be acquainted with these Seven simple Steps to ensure that Excel documents are fully Accessible to everyone. These Steps are explained utilizing Microsoft Excel 2007 and 2010. The Menu map of other versions of Microsoft Excel may be different. iv A Note About Excel and Section 508. Excel files must be Section 508 compliant or the content contained made Accessible through accommodation. The application of the Excel standard will be dependent upon the purpose of the Excel file.

6 If the purpose of the Excel Worksheet is to present a data set, the Excel file should be presented on the internet as a Comma Separated Value (CSV). file and not as an xls file. The link must clearly state that the CSV is a raw data set. A separate data definition document must accompany all CSV. files. An Excel data set that would be presented as a CSV has the following characteristics: A single row of headings in the first row. The data set contains no formulas. Rationale Excel is a widely used/distributed application used by both the general public and business. While most site visitors have the full Microsoft Excel program, which is 508 compliant, the free Microsoft Excel downloadable reader is not compliant.

7 Exemptions Excel files may be granted an accommodations waiver when files contain program modules and macros developed to perform automated analysis or to draw in data sets from external or legacy databases. Sources Section 508 Website Access Board Website v Step One: Add Alternative Text to Images and Objects Images, Charts and Graphics included in a Worksheet need to have alternative text. Otherwise these items will not be perceived, nor properly understood by persons who have visual disabilities. Alternative text is read by screen readers allowing the content and function of these images, charts or graphics to be Accessible to those with visual or certain cognitive disabilities.

8 To add alternative text (Alt text) to an image, chart or graphic Right Click (Shift+F10) on the image, click Format, choose Alt Text. Figure 1: Graphic showing the Alt Text tab of the Size menu. Type a description into the Title and Description boxes. When finished click Close. 1. Add Alternative Text to a Table Beginning with Microsoft Office 2010 alternative text can be added to Tables in Excel . First Right Click (Shift+F10) anywhere within the table. Select Table', then Alternative Text'. Figure 2: Drop down menu after 'Right Clicking' on Table. 2. When the Alternative Text dialog box appears, fill in both the Title and Description boxes.

9 Then click OK. Figure 3: Alternative Text dialog box. 3. Step Two: Specify Column Header Info in Tables Having clear column headings can help provide context and assist navigation of the table's contents. To specify a header row in a new block of cells: 1. Highlight the cells to be included in the table. 2. On the Insert tab, in the Tables group, click Table. 3. Select the My table has headers check box. 4. Click OK. Figure 4: Image showing Steps to adding a Header row in a Table. Because Excel knows that all Tables have to have a Header row, it will automatically add one. If you don't check the My table has headers' check box the row immediately above your table will be assigned as the Header row.

10 4. Step Three: Create Meaningful Hyperlink Text Hyperlink text provides a clear description of the link destination, rather than providing either the Uniform Resource Locator (URL) or simply words such as, Click Here'. People who utilize screen reading software can navigate by going from link' to link'. Meaningful text enables them to know what each link is for, and where it will take them. To add a hyperlink to a table: 1. Place the cursor in the cell where the hyperlink is to be added. 2. In the Insert tab, in the Links group, click on Hyperlink and a dialog box will open. 3. In the Text to Display box, type in the name or phrase that briefly describes the link destination.