WebAIM - Web Accessibility In Mind

E-mail List Archives

Re: excel best practices

for

From: R.U. Steinberg
Date: Jan 11, 2019 9:25AM

There is a tutorial for Excel forms by State of Texas
https://gov.texas.gov/organization/disabilities/accessibledocs2013-16

How to Make Accessible Excel Forms, Part 1

[image: YouTube Video: How to Make Accessible Excel Forms, Part 1]
<http://www.youtube.com/watch?v=71EuSZwCtVE&;feature=plcp>This is the first
of a two-part set of Excel forms modules. This module covers the basics
for creating accessible Excel forms, as well as a brief review of Excel
accessibility best practices.



- Watch YouTube Video: How to Make Accessible Excel Forms, Part 1
<http://www.youtube.com/watch?v=71EuSZwCtVE&;feature=plcp>
- Download Audio MP3 File: How to Make Accessible Excel Forms, Part 1
<https://gov.texas.gov/uploads/files/organization/disabilities/16_ExcelForms_01.mp3>
- Download Instructional Word Document: How to Make Accessible Excel
Forms, Part 1
<https://gov.texas.gov/uploads/files/organization/disabilities/16_ExcelForms_01.docx>
- Download Instructional Adobe PDF: How to Make Accessible Excel Forms,
Part 1
<https://gov.texas.gov/uploads/files/organization/disabilities/16_ExcelForms_01.pdf>


How to Make Accessible Excel Forms, Part 2

[image: YouTube Video: How to Make Accessible Forms, Part 2]
<http://www.youtube.com/watch?v=VMQPeUqB258&;feature=plcp>This is the second
of a two-part set of Excel forms modules. This module gives more advanced
instructions on controlling the type of data being entered, and also
locking and protecting your form.


- Watch YouTube Video: How to Make Accessible Excel Forms, Part 2
<http://www.youtube.com/watch?v=VMQPeUqB258&;feature=plcp>
- Download Audio MP3 File: How to Make Accessible Excel Forms, Part 2
<https://gov.texas.gov/uploads/files/organization/disabilities/17_ExcelForms_02.mp3>
- Download Instructional Word Document: How to Make Accessible Excel
Forms, Part 2
<https://gov.texas.gov/uploads/files/organization/disabilities/17_ExcelForms_02.docx>
- Download Instructional Adobe PDF: How to Make Accessible Excel Forms,
Part 2
<https://gov.texas.gov/uploads/files/organization/disabilities/17_ExcelForms_02.pdf>



On Fri, Jan 11, 2019 at 10:05 AM Sarah Ferguson < <EMAIL REMOVED> > wrote:

> I've been asked to create an excel sheet that can be used like a form. I've
> never really had to make accessible excel sheets before. High-contrast need
> is a given. I applied table style to the two sections of the sheet that are
> meant to be filled, but not the parts with the sheet title or the
> directions for filling the form. I used the locked and hidden features so
> you can tab to all cells with text or cells meant to be filled out, but not
> to surrounding blank cells. I only used merging in the cells with
> directions, not in any of the "table" cells. Is this how I should be
> treating this document? Anything I should keep in mind as best practices or
> things I am doing that will actually make it harder to use?
>
> Thanks
>
> Sarah Ferguson
> Web Accessibility Specialist
> > > > >