John,
Send me the file and I'll tell you if it works or not. Did you get the point
that the defined name stays with the file unlike the dynamic row and column
settings that can be set by the screen reader?
All the best,
Cearbhall
m +353 (0)833323487 Ph: _353 (0)1-2864623 e: cearbhall.omeadhra@xxxxxxx
-----Original Message-----
From: fb-exchange-bounce@xxxxxxxxxxxxx <fb-exchange-bounce@xxxxxxxxxxxxx> On
Behalf Of John Acton
Sent: Thursday, November 25, 2021 1:41 PM
To: fb-exchange@xxxxxxxxxxxxx
Subject: [fb-exchange] Re: Reading Column and Row headings in Excel further
notes
Hi Cearbhall
Thanks. I will have a go at defining the titles in excel and hear if that
works with nvda calling out the cell contents and the associated column
titles.
Much appreciated.
John
On Thu, 25 Nov 2021 at 12:07, Cearbhall O'Meadhra <
cearbhall.omeadhra@xxxxxxx> wrote:
Hi all and Mary,
I described the simple operation of setting rows and column headings
using the JAWS keystrokes JAWS-key+control+alt+c or
JAWS-key+control+alt+r. These are enabled in JAWS by default.
For NVDA users the keystrokes are NVDA-key+shift +c or NVDA-key+shift+r.
These are not enabled by default so the user must make sure both "Tables"
and
"Row/column headers" are checked in the tables grouping In Document
settings (NVDA+control+d) to enable this feature.
Both of the above only report rows and columns that are filled with
data and stop at the first blank cell in any row or column.
Excel has a built-in feature using "Defined Names" that is easy to
apply but may seem more complicated at first. JAWS users will need to
have " define names override" set to "off".
NVDA users can access Define Names by default.
Procedure:
* First you must identify the bottom rightmost cell that you want to
define.
Then, position the cursor on the first cell in the top left corner of
the worksheet where your column and row headings intersect.
* Now open "Define Names", by pressing control+F3 followed by the
letter "n"
for "new".
This opens on the edit box where you can type the new name.
*In this box type any name ie "beads", "title1", "Cars" ... followed
immediately by two full stops followed by the cell coordinates of the
bottom righthand corner of the area you want to cover The result
should look like: "Cars..Z25"
* Tab severaltimes to OK if that is available or simply close the
define names dialogue.
Now both JAWS and NVDA will report the column headings or the row
headings when your cursor is anywhere within the area you are
covering. This will keep going even if there are blank rows or columns
within the area.
Here is a friendly video that might make it clearer. It uses JAWS as
the screen reader but it is the same for NVDA without the need to set
the override.
https://www.youtube.com/watch?v=Uv2K2lv9-jY
All the best,
Cearbhall
m +353 (0)833323487 Ph: _353 (0)1-2864623 e:
cearbhall.omeadhra@xxxxxxx
--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
===========================================================
The fb-exchange mailing list
Manage account,
List Page: https://www.freelists.org/list/fb-exchange
Subscribe: mailto:fb-exchange-request@xxxxxxxxxxxxx?Subject=subscribe
Unsubscribe:
mailto:fb-exchange-request@xxxxxxxxxxxxx?Subject=unsubscribe
Archive: https://www.freelists.org/archive/fb-exchange
Administrative contact: insight@xxxxxxxxxxxxxxxxxxxx
===========================================================