WebAIM - Web Accessibility In Mind

E-mail List Archives

Re: Accessible spreadsheets

for

From: Ryan E. Benson
Date: Jun 24, 2018 2:47PM

> assign header cells

With newer versions of excel you should be able to select the table and
data, then use the "format as a table" function on the home tab. If you
select the "table has headers option, the top row should become effectively
THs. andhave an experience like you would in Word. You can't mark row
headers though.


--
Ryan E. Benson

On Fri, Jun 22, 2018 at 1:43 PM, Birkir R. Gunnarsson <
<EMAIL REMOVED> > wrote:

> Quite accessible with a screen reader, Jaws in particular.
> YOu can browse spreadsheets by cels, review formulas and comments with
> keystrokes, assign header cells (Jaws only), name and move worksheets
> around (I think Jaws only, but not sure), you can get a list of
> objects (at least in Jaws) that enable you to e.g. click buttons to
> run scripts (I used to work full-time writing VBA scripts for massive
> risk monitoring applications for a bank, the fact that the bank went
> under is not my fault, I promise).
>
> There are some difficulties navigating custom dropdowns in Excel (have
> not tested with latest version, both in Jaws and NVDA.
> I've not been able to create or use pivot tables.
>
> Hope this helps, if you just want a number I'd say 85% with Jaws, 75% with
> NVDA.
>
>
>
> On 6/22/18, <EMAIL REMOVED> < <EMAIL REMOVED> > wrote:
> > The recent thread about Sec. 508 regarding Excel prompted this question:
> >
> >
> >
> > How accessible are spreadsheets with current assistive technologies?
> >
> >
> >
> > I'm sure the answer will be "it depends," but let's take 2 basic samples:
> >
> >
> >
> > 1. A spreadsheet of just plain data, such as a directory with names,
> > addresses and emails in rows and columns.
> > 2. A spreadsheet with common, basic formulas, such as summation of a
> > column of numbers.
> >
> >
> >
> > - - -
> >
> > Bevi Chagnon, founder/CEO | <EMAIL REMOVED> <mailto: <EMAIL REMOVED> >
> >
> > - - -
> >
> > PubCom: Technologists for Accessible Design + Publishing
> >
> > consulting . training . development . design . sec. 508 services
> >
> > Upcoming classes at www.PubCom.com/classes
> >
> > - - -
> >
> >
> >
> >
> >
> > > > > > > > > >
>
>
> --
> Work hard. Have fun. Make history.
> > > > >