WebAIM - Web Accessibility In Mind

E-mail List Archives

Re: excel best practices

for

From: Sarah Ferguson
Date: Jan 11, 2019 2:03PM

thanks!

Sarah Ferguson
Web Accessibility Specialist
Office of Digital Communications
Brandeis University *|* 781.736.4259

*Web Accessibility Help Desk < <EMAIL REMOVED> >*
*Web Accessibility at Brandeis <http://www.brandeis.edu/web-accessibility>;*
*Sign up for Training
<https://www.brandeis.edu/web-accessibility/training/index.html> | **Email
to set up a 1-on-1*




On Fri, Jan 11, 2019 at 11:26 AM R.U. Steinberg < <EMAIL REMOVED> >
wrote:

> 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
> > > > > > > > > >
> > > > >