NVDA can also do this. the info is below.
10.2. Microsoft Excel
10.2.1. Automatic Column and Row Header Reading
NVDA is able to automatically announce appropriate row and column
headers when navigating around Excel worksheets. This firstly requires
that the Report Table row / column headers option In NVDA's Document
Formatting dialog be turned on. Secondly, NVDA needs to know which row
or column contains the headers. After moving to the first cell in the
column or row containing the headers, use one of the following commands:
Name
Key
Description
Set column headers
NVDA+shift+c
Pressing this once tells NVDA this is the first header cell in the row
that contains column headers, which should be automatically announced
when moving between columns below this row. Pressing twice will clear
the setting.
Set row headers
NVDA+shift+r
Pressing this once tells NVDA this is the first header cell in the
column that contains row headers, which should be automatically
announced when moving between rows after this column. Pressing twice
will clear the setting.
These settings will be stored in the workbook as defined name ranges
compatible with other screen readers such as Jaws. This means that users
of other screen readers who open this workbook at a later date will
automatically have the row and column headers already set.
10.2.2. The Elements List
Similar to the web, NVDA has an Elements List for Microsoft Excel that
allows you to list and access several different types of information. To
access the Elements List in Excel, press NVDA+f7. The various types of
information available in the Elements List are:
• Charts: This lists all charts in the active worksheet. Selecting a
chart and pressing enter or the Move to button focuses the chart for
navigating and reading with the arrow keys.
• Comments: This lists all cells in the active worksheet containing
comments. The cell address along with its comments are shown for each
cell. Pressing enter or the Move To button when on a listed comment will
move directly to that cell.
• Formulas: This lists all cells in the worksheet containing a formula.
The cell address along with its formula are shown for each cell.
Pressing enter or the Move To button on a listed formula will move
directly to that cell.
• Sheets: This lists all sheets in the workbook. Pressing f2 when on a
listed sheet allows you to rename the sheet. Pressing enter or the Move
To button while on the listed sheet will switch to that sheet.
• Form fields: This lists all form fields in the active worksheet. For
each form field, the Elements List shows the alternative text of the
field along with the addresses of the cells it covers. Selecting a form
field and pressing enter or the Move to button moves to that field in
browse mode.
10.2.3. Reporting Comments
To report any comments for the currently focused cell, press NVDA+alt+c.
All comments for the worksheet can also be listed in the NVDA Elements
List.
10.2.4. Reading Protected Cells
If a workbook has been protected, it may not be possible to move focus
to particular cells that have been locked for editing. To allow moving
to locked cells, switch to Browse Mode by pressing NVDA+space, and then
use standard Excel movement commands such as the arrow keys to move
around all cells on the current worksheet.
10.2.5. Form Fields
Excel worksheets can include form fields. You can access these using the
Elements List or the f and shift+f form field single letter navigation
keys. Once you move to a form field in browse mode, you can press enter
or space to either activate it or switch to focus mode so you can
interact with it, depending on the control. For further information
about Browse mode and single letter navigation, see the Browse Mode
section.
On 9/12/2017 7:07 AM, Carol and Roger via Talk wrote:
Hi David,
You can do this. Place your cursor in the header row, i.e., a4.
If you have more than one row in the header, press shift and arrow
down to include all header rows. I have a3 and a4, so I down arrow
with shift once.
Press ctrl-alt-jawskey -c to label columns
For rows, select the row header you want spoken and press
alt-cntrl-jawskey-r.
Save your file before closing it and your new settings should carry
over each time you open the file.
Carol
On 9/12/2017 4:49 AM, David via Talk wrote:
Trying to wrap my brain cells around the usage of Jaws. Those of you who
are more driven in using Jaws with Excel, maybe you can give me some
directions here, please. OK, I am using Excel 2007, but think my issue
would be similarly worked out under any later version of Excel. So all
feedback is welcome.
Under WinEyes, it is possible to define a column, that should be read,
whenever you land on a row. You defined it under the hotkey of
Ctrl-Shift-H, if memory serves me right. What it does, is this:
I have a spreadsheet, holding a list of products, prices and amounts.
The amount column is the first of each row, like A1, A2, A3 and so on.
Each row, in column C, holds the product name. So, C1, C2, C3 and on
we go.
Benefit of the WinEyes feature, is that I can move down the first cell
of each row, and have its contents (the amount) spoken, along with the
screen reader automatically read out to me what is in cell C of the same
row (the product name).
It for instance might read:
2, Milk;
3, Bread;
5, chocolate bars.
Milk, Bread and Chocolate bars, are all found in the C column of the
spreadsheet, but I do never have to move out of the first (A) cell of
each row, since cell C automatically is being spoken, as I move up and
down the individual rows.
For anyone who are familiar with the feature, i am sure you know what I
mean. Those who have not yet tried it, sorry for not being very good at
explaining the material.
My big question now, is IF there is a corresponding feature in Jaws.
What is it called, How do I get to it, and could someone give easy
step-by-step instructions of setting it up? Once I have a sample, I
might be able to work out the specifics for other spreadsheets as well.
I really hope there is such a feature, as otherwise I will have to jump
back and forth between the individual cells, which is really
counter-productive.
Thanks for all feedbacks, ideas and workarounds, you might have.
_______________________________________________
Any views or opinions presented in this email are solely those of the
author and do not necessarily represent those of Ai Squared.
For membership options, visit
http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/joshuakennedy201%40comcast.net.
For subscription options, visit
http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com
List archives can be found at
http://lists.window-eyes.com/private.cgi/talk-window-eyes.com
--
sent with mozilla thunderbird
_______________________________________________
Any views or opinions presented in this email are solely those of the author
and do not necessarily represent those of Ai Squared.
For membership options, visit
http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/archive%40mail-archive.com.
For subscription options, visit
http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com
List archives can be found at
http://lists.window-eyes.com/private.cgi/talk-window-eyes.com
