E-mail List Archives
Thread: Excel and Jaws
Number of posts in this thread: 6 (In chronological order)
From: Alan Zaitchik
Date: Fri, Jun 02 2017 9:11AM
Subject: Excel and Jaws
No previous message | Next message →
I'm working on some excel spreadsheets that are basically just tables. They have column headings in the top row. Jaws reads cells announcing their cell ids like A10 or B5-- but I can't seem to get it to repeat the column headings the way it would for an html or PDF table. Is it incapable of doing so, or have I simply missed something in excel or in jaws? And is this reason enough to convert to PDF as our accessible version? Note: the intended use is READ ONLY for these files.
Thanks,
A
From: Wee, Kim (MNIT)
Date: Fri, Jun 02 2017 9:22AM
Subject: Re: Excel and Jaws
← Previous message | Next message →
In order to have JAWS read the row and column headers in Excel, you need to assign the TitleRegion. You can do so by doing the following:
First, we need to know three things about our table:
1) Is this the first (or only) table on this worksheet? (table#)
2) What are the addresses of the top left and bottom right cells in the table? (upperleft, lowerright)
3) Is this worksheet the first (or only) worksheet in this workbook? (worksheet#)
Example: TitleRegion#.upperleft.lowerright.worksheet#
Next, do the following:
1) Put your cursor in the top-left cell in the table. Don't count the table titles, but you do count all row and column headers as part of the table
2) Go to the Formulas tab in the Ribbon, and choose Name Manager in the Defined Names group. Choose New in the top left corner. A new dialog box opens
3) Type TitleRegion then add the (table#), then a period.
4) Next add the range of cells in your table from top left to bottom right, like this - (upperleft) 'period- (lowerright) 'period-
5) Then the worksheet number (worksheet#). Your Title code should look like this: TitleRegion1.a2.g45.1
6) Select Ok and Close
Kim Wee
Webmaster and Accessibility Coordinator| Operations Team
Minnesota IT Services | Partnering with Education
1500 Highway 36
Roseville, MN, 55113
O: 651-582-8548
Information Technology for Minnesota Government|mn.gov/mnit
-----Original Message-----
From: WebAIM-Forum [mailto: = EMAIL ADDRESS REMOVED = ] On Behalf Of Alan Zaitchik
Sent: Friday, June 02, 2017 10:12 AM
To: = EMAIL ADDRESS REMOVED =
Subject: [WebAIM] Excel and Jaws
I'm working on some excel spreadsheets that are basically just tables. They have column headings in the top row. Jaws reads cells announcing their cell ids like A10 or B5-- but I can't seem to get it to repeat the column headings the way it would for an html or PDF table. Is it incapable of doing so, or have I simply missed something in excel or in jaws? And is this reason enough to convert to PDF as our accessible version? Note: the intended use is READ ONLY for these files.
Thanks,
A
From: Andrews, David B (DEED)
Date: Fri, Jun 02 2017 9:31AM
Subject: Re: Excel and Jaws
← Previous message | Next message →
If I am remembering correctly -- and I may get this wrong, but with JAWS, put the cursor in the first cell of the header row and hit jaws+control+alt+C. That should monitor the cells.
Dave
-----Original Message-----
From: WebAIM-Forum [mailto: = EMAIL ADDRESS REMOVED = ] On Behalf Of Alan Zaitchik
Sent: Friday, June 02, 2017 10:12 AM
To: = EMAIL ADDRESS REMOVED =
Subject: [WebAIM] Excel and Jaws
I'm working on some excel spreadsheets that are basically just tables. They have column headings in the top row. Jaws reads cells announcing their cell ids like A10 or B5-- but I can't seem to get it to repeat the column headings the way it would for an html or PDF table. Is it incapable of doing so, or have I simply missed something in excel or in jaws? And is this reason enough to convert to PDF as our accessible version? Note: the intended use is READ ONLY for these files.
Thanks,
A
From: JP Jamous
Date: Fri, Jun 02 2017 10:53AM
Subject: Re: Excel and Jaws
← Previous message | Next message →
You are correct david. Also Insert + CTRL + Alt + r will work for row headings.
-----Original Message-----
From: WebAIM-Forum [mailto: = EMAIL ADDRESS REMOVED = ] On Behalf Of Andrews, David B (DEED)
Sent: Friday, June 2, 2017 10:32 AM
To: WebAIM Discussion List < = EMAIL ADDRESS REMOVED = >
Subject: Re: [WebAIM] Excel and Jaws
If I am remembering correctly -- and I may get this wrong, but with JAWS, put the cursor in the first cell of the header row and hit jaws+control+alt+C. That should monitor the cells.
Dave
-----Original Message-----
From: WebAIM-Forum [mailto: = EMAIL ADDRESS REMOVED = ] On Behalf Of Alan Zaitchik
Sent: Friday, June 02, 2017 10:12 AM
To: = EMAIL ADDRESS REMOVED =
Subject: [WebAIM] Excel and Jaws
I'm working on some excel spreadsheets that are basically just tables. They have column headings in the top row. Jaws reads cells announcing their cell ids like A10 or B5-- but I can't seem to get it to repeat the column headings the way it would for an html or PDF table. Is it incapable of doing so, or have I simply missed something in excel or in jaws? And is this reason enough to convert to PDF as our accessible version? Note: the intended use is READ ONLY for these files.
Thanks,
A
From: Alan Zaitchik
Date: Fri, Jun 02 2017 3:44PM
Subject: Re: Excel and Jaws
← Previous message | Next message →
Thanks for the various suggestions. At first I could not find the Excel Name Manager functionality-- because I was on a Mac. The version of Excel I switched to on a PC had it.
Thanks, too, for the JAWS keystroke suggestions.
This is a wonderful list!
Thanks,
A
> On Jun 2, 2017, at 12:53 PM, JP Jamous < = EMAIL ADDRESS REMOVED = > wrote:
>
> You are correct david. Also Insert + CTRL + Alt + r will work for row headings.
>
> -----Original Message-----
> From: WebAIM-Forum [mailto: = EMAIL ADDRESS REMOVED = ] On Behalf Of Andrews, David B (DEED)
> Sent: Friday, June 2, 2017 10:32 AM
> To: WebAIM Discussion List < = EMAIL ADDRESS REMOVED = >
> Subject: Re: [WebAIM] Excel and Jaws
>
> If I am remembering correctly -- and I may get this wrong, but with JAWS, put the cursor in the first cell of the header row and hit jaws+control+alt+C. That should monitor the cells.
>
> Dave
>
>
>
> -----Original Message-----
> From: WebAIM-Forum [mailto: = EMAIL ADDRESS REMOVED = ] On Behalf Of Alan Zaitchik
> Sent: Friday, June 02, 2017 10:12 AM
> To: = EMAIL ADDRESS REMOVED =
> Subject: [WebAIM] Excel and Jaws
>
> I'm working on some excel spreadsheets that are basically just tables. They have column headings in the top row. Jaws reads cells announcing their cell ids like A10 or B5-- but I can't seem to get it to repeat the column headings the way it would for an html or PDF table. Is it incapable of doing so, or have I simply missed something in excel or in jaws? And is this reason enough to convert to PDF as our accessible version? Note: the intended use is READ ONLY for these files.
> Thanks,
> A
> > > >
>
From: Jonathan Cohn
Date: Sat, Jun 03 2017 8:33PM
Subject: Re: Excel and Jaws
← Previous message | No next message
Apple creates its own spreadsheet for the Macintosh called "numbers". In Numbers there is a way to define a row or column as a header. Generally when this is done, Numbers does read you prompts much like with JAWS on the Windows platform.
Best wishes,
Jonathan Cohn
> On Jun 2, 2017, at 5:44 PM, Alan Zaitchik < = EMAIL ADDRESS REMOVED = > wrote:
>
> Thanks for the various suggestions. At first I could not find the Excel Name Manager functionality-- because I was on a Mac. The version of Excel I switched to on a PC had it.
> Thanks, too, for the JAWS keystroke suggestions.
>
> This is a wonderful list!
>
> Thanks,
> A
>
>> On Jun 2, 2017, at 12:53 PM, JP Jamous < = EMAIL ADDRESS REMOVED = > wrote:
>>
>> You are correct david. Also Insert + CTRL + Alt + r will work for row headings.
>>
>> -----Original Message-----
>> From: WebAIM-Forum [mailto: = EMAIL ADDRESS REMOVED = ] On Behalf Of Andrews, David B (DEED)
>> Sent: Friday, June 2, 2017 10:32 AM
>> To: WebAIM Discussion List < = EMAIL ADDRESS REMOVED = >
>> Subject: Re: [WebAIM] Excel and Jaws
>>
>> If I am remembering correctly -- and I may get this wrong, but with JAWS, put the cursor in the first cell of the header row and hit jaws+control+alt+C. That should monitor the cells.
>>
>> Dave
>>
>>
>>
>> -----Original Message-----
>> From: WebAIM-Forum [mailto: = EMAIL ADDRESS REMOVED = ] On Behalf Of Alan Zaitchik
>> Sent: Friday, June 02, 2017 10:12 AM
>> To: = EMAIL ADDRESS REMOVED =
>> Subject: [WebAIM] Excel and Jaws
>>
>> I'm working on some excel spreadsheets that are basically just tables. They have column headings in the top row. Jaws reads cells announcing their cell ids like A10 or B5-- but I can't seem to get it to repeat the column headings the way it would for an html or PDF table. Is it incapable of doing so, or have I simply missed something in excel or in jaws? And is this reason enough to convert to PDF as our accessible version? Note: the intended use is READ ONLY for these files.
>> Thanks,
>> A
>> >> >> >>
>>
> > > >