Topics

moderated Excel rows and columns

Gudrun Brunot
 

Hi gang: As often is the case for me since I filter my list messages, I may be late in the game to offer my suggestion, but here it is based on a spreadsheet I made up for bank info where I wanted to be able to update the spreadsheet as I was getting the info over the phone.

I had 15 columns, a-o. I figure that, to start with, it will take me a long time to fill up 100 rows, so that is what I decided I needed.

Place cursor on first column title. Alt to upper ribbon. Right arrow to Formulas. tab to Define name split btn. Enter. Enter again, type exactly minus the brackets: [TitleRegion1..o100 which means I estimate that O will be the last column needed, and row 100 the last row needed for this spreadsheet.
So, if you add another column after the 15th column plus another 50 rows, just change what you type: [TitleRegion1..p150 which means I estimate that P will be the last column needed, and row 150 the last row needed for this spreadsheet.

Now, Jaws will read the column titles correctly as you tab from row to row.

Hope this helps.
Gudrun

Please note my new email of brunotgudrun@...

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Sieghard Weitzel
Sent: Sunday, June 09, 2019 8:14 AM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

First I have to get it to work in the first place. For some reason I can’t get automatic readings of row and column headings to work using this method at all.

I already have a template of this workbook set up and I usually just open it each time a new month starts and then use F12 to save it but giving it the name of the month.

For example, my template is Sales Summary and I then save it, for example, as Sales Summary June 2019.

I wouldn’t mind setting up the row and column title reading on each sheet separately if I could just get it to work.



From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Russell Solowoniuk
Sent: Sunday, June 9, 2019 7:38 AM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns



Hi Sieghard,



I’m not able to set this up by defining a name on a worksheet and then copying that sheet multiple times. Even if I set the scope to the worksheet rather than the workbook, Jaws doesn’t read column or row headings on the next sheets.



What you want can be done easily manually by first creating copies of your first sheet 31 times, one sheet for each day of the month. Then, place your cursor in the cell of the first sheet where you want to define the name, press the applications key, up arrow to “Define name…” and press enter. Type “Title” if you wish both column and row headings to be read by Jaws and press enter. Now, move to sheet two and do the same, except this time type “Title2” as the name. Continue doing this on subsequent sheets, each time increasing the number after “Title”. Note that there is no space between “Title” and the number.



Not sure if this helps or if you wanted a more automatic method, but I can’t seem to do it any other way. I even tried grouping the sheets and then defining a name, but this doesn’t work.



Cheers,



Russell



From: main@jfw.groups.io <mailto:main@jfw.groups.io> <main@jfw.groups.io <mailto:main@jfw.groups.io> > On Behalf Of Sieghard Weitzel
Sent: Friday, June 7, 2019 12:08 AM
To: main@jfw.groups.io <mailto:main@jfw.groups.io>
Subject: Re: Excel rows and columns



Hi Brian,



I attached a little sample spreadsheet I made. I thought I followed your steps to set it up so Jaws will read the column and row titles, but I can’t get it to work, what am I doing wrong?



Sieghard



From: main@jfw.groups.io <mailto:main@jfw.groups.io> <main@jfw.groups.io <mailto:main@jfw.groups.io> > On Behalf Of Brian Vogel
Sent: Thursday, June 6, 2019 8:42 PM
To: main@jfw.groups.io <mailto:main@jfw.groups.io>
Subject: Re: Excel rows and columns



Pardon my error, that last technique is the "when I only want it during this session" method with JAWS. This is how to set them in the spreadsheet itself such that JAWS will recognize their existence and announce them whenever you open a specific spreadsheet:

Assigning a Title Row (Column Titles) and/or Title Column (Row Titles) in Excel

You can assign column and row titles in Excel. These are nice because they always work with Excel and are saved to the workbook. There's no risk of losing a setting in your screen reader.

To add column and row title names:

a. Focus on the first cell in the row or column or at the first cell where the title row and title column intersect
b. Open the Name dialog:

i. Open the Formula ribbon (ALT-M)

ii. Activate the “Define Name” command (M)

iii. Within the drop-down list, activate “Define Name”

iv. The “New Name” dialog opens



Focus is placed in the name field. Within the name field, you can name the focused cell or selected range of cells. In this case, we’re naming the column or row title:

a. Name the cell using the following rules

i. Start the range name with the label that tells Excel you’re creating a title range

1. Title – This tells Excel the column and row that intersect at the active cell are a title row and column
2. ColumnTitle – This tells Excel the focused column contains the titles for the rows within the range
3. RowTitle – this tells Excel the focused row contains titles for the columns in the range

ii. Add a name for the range

1. Title_WidgetSales
2. ColumnTitle_WidgetSales
3. RowTitle_WidgetSales

iii. Optional - Add the last cell in the range preceded by two periods

1. Use this when you have multiple regions in a worksheet
2. Title_WidgetSales..J25
3. ColumTitle_WidgetSales..h32
4. RowTitle_WidgetSales..r12
5. Remember the cell address referenced is the last cell in the range for which you are creating titles

The next field in the dialog sets the scope for the name. this is a combo box. Use UP and DOWN ARROW to choose from between:

* Workbook - the title Is unique and can’t be used elsewhere in a workbook
* A Specific Worksheet - the name can be used elsewhere in a workbook

You can add a comment for the named cell or region, this is strictly for your personal reference and doesn’t affect the echo of the column or row title name

The last field references the cell name or range of selected cells you’re naming. You can leave this field alone.

Activate the OK button to save the name and close the dialog.

Save the workbook and the titles are permanently saved and will work on any computer.

If you have titles set to echo in JAWS, the titles will echo and you won’t lose the settings.

--

Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763

Here is a test to find out whether your mission in life is complete. If you’re alive, it isn’t.

~ Lauren Bacall

 

On Wed, Jun 12, 2019 at 01:02 AM, Sieghard Weitzel wrote:
Except that one never sticks for long
That's why I don't go that route unless I know that this is a "one time review," which I have very seldom found to be the case in real life.   It's far better to use Excel's own features to embed information about a set of column titles (using the RowTitle feature - because it is a row of titles for columns) or row titles (using the ColumnTitle feature - because it is a column of titles for each respective row).

Doing it using Excel's features also ensures that if you are setting up, say, a monthly worksheet that you then want to duplicate 12 times in the same workbook, that you only need to do the setup once and those formatting options will carry over to each month's copy, provided you set the scope of the titles to the worksheet, not the workbook as a whole.

It's somewhat more tedious at the outset, but so much less time consuming over the long run.
 
--

Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763  

Here is a test to find out whether your mission in life is complete.  If you’re alive, it isn’t.

       ~ Lauren Bacall

 

Except that one never sticks for long whereas the other one, if done correctly, gets saved with your workbook and even if I were to email the file to somebody else who used Jaws they column and row headers would read for them.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Palmer Loux
Sent: Tuesday, June 11, 2019 7:07 PM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

Hello
Get to the first cell of your first column Press insert the 0 on numpad with numlock off, and control with your right hand, with the left hand press alt and R you should hear “setting row headers”. Then press insert control with right hand and with left hand press alt and the letter C. You should head “setting Column headers” it is a 4 key press for each .
On Jun 6, 2019, at 8:29 AM, Brian Switzer <brian.switzer12@...> wrote:

Good morning,

I know this can be done somehow. How do you get JAWS to read the row and column headers in Excel? Thanks!

All the Best,
Brian Switzer


--
Palmer from CBVI

Palmer Loux
 

Hello
Get to the first cell of your first column
Press insert the 0 on numpad with numlock off, and control with your right hand, with the left hand press alt and R you should hear “setting row headers”. Then press insert control with right hand and with left hand press alt and the letter C. You should head “setting Column headers” it is a 4 key press for each .

On Jun 6, 2019, at 8:29 AM, Brian Switzer <brian.switzer12@...> wrote:

Good morning,

I know this can be done somehow. How do you get JAWS to read the row and column headers in Excel? Thanks!

All the Best,
Brian Switzer

--
Palmer from CBVI

 

As an aside, there's an upcoming free webinar on June 20th on JAWS and Excel, as well as an archived one from last year.  See:  https://support.freedomscientific.com/Services/TrainingAndCertification/FreeWebinars

--

Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763  

Here is a test to find out whether your mission in life is complete.  If you’re alive, it isn’t.

       ~ Lauren Bacall

Ann Byrne
 

The JAWS training materials has a couple of tutorials on Excel, one illustrating the speaking of row and column titles using the bookmark feature of the Excel application.

At 07:44 PM 6/9/2019, you wrote:
I have been working on this and my original instructions, with some slight modifications, do work (or do for me with JAWS 2019 and Excel 2016).  That being said, there are multiple ways to accomplish what's being sought and I really have no idea how most who can't actually see a spreadsheet deal with across row or down column selection.One can select a range of cells, then define it as a Title Row (which is the titles of the respective columns that row is above), and the same for a Title Column, and define it that way. Or one can simply select the first cell of the title row/column, and use a special Excel Keyword for the name followed by dot dot (with no spaces) and the designation of the cell that ends the series (which will be a cell to the right if it's a Title Row or a cell below if it's a Title Column).There also exists the option of using an Excel table in the spreadsheet, too, and that can be very convenient for dealing with needs for insertion of additional rows and things like Total rows, which can just slide on down (or up, if rows are deleted) and the formulae handle this seamlessly.How do you, here, set this sort of thing up, and how do you go about multi-selection of ranges in a single row or column. Knowing about common selection methods used for blocks of cells would be interesting, too.I've never had a client where I was working with them doing heavy duty work with Excel spreadsheet creation or modification. Most of the work was about accessing existing spreadsheets, which is an entirely different kettle of fish. That's how the stuff related to designating titles came about, because it becomes rather hellish to know where you are in a complex Excel table if you are distracted, or need to shift focus to something else, and come back in without knowing the row/column you're working with and what it represents.--

Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763 Â

Here is a test to find out whether your mission in life is complete. If you’re alive, it isn’t.

    ~ Lauren Bacall

 

I have been working on this and my original instructions, with some slight modifications, do work (or do for me with JAWS 2019 and Excel 2016).   That being said, there are multiple ways to accomplish what's being sought and I really have no idea how most who can't actually see a spreadsheet deal with across row or down column selection.

One can select a range of cells, then define it as a Title Row (which is the titles of the respective columns that row is above), and the same for a Title Column, and define it that way.  Or one can simply select the first cell of the title row/column, and use a special Excel Keyword for the name followed by dot dot (with no spaces) and the designation of the cell that ends the series (which will be a cell to the right if it's a Title Row or a cell below if it's a Title Column).

There also exists the option of using an Excel table in the spreadsheet, too, and that can be very convenient for dealing with needs for insertion of additional rows and things like Total rows, which can just slide on down (or up, if rows are deleted) and the formulae handle this seamlessly.

How do you, here, set this sort of thing up, and how do you go about multi-selection of ranges in a single row or column.  Knowing about common selection methods used for blocks of cells would be interesting, too.

I've never had a client where I was working with them doing heavy duty work with Excel spreadsheet creation or modification.  Most of the work was about accessing existing spreadsheets, which is an entirely different kettle of fish.  That's how the stuff related to designating titles came about, because it becomes rather hellish to know where you are in a complex Excel table if you are distracted, or need to shift focus to something else, and come back in without knowing the row/column you're working with and what it represents.

--

Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763  

Here is a test to find out whether your mission in life is complete.  If you’re alive, it isn’t.

       ~ Lauren Bacall

 

No, I deleted them all.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Russell Solowoniuk
Sent: Sunday, June 9, 2019 8:40 AM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

Hi Sieghard,

Yes, if you go to Save As and save the workbook with a new name, the defined cell names are saved to the new workbook.

I wonder if you go to "Name Manager", under the Formula tab, press CTRL+ right arrow and you should land on "Name Manager", and from there delete any names you have defined, and then define all your cell names again? I wonder if there are names defined already that might be causing things not to work as they ought to?

Cheers,

Russell

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Sieghard Weitzel
Sent: Sunday, June 9, 2019 9:15 AM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

I assume if I could get it to work for the template I made and then as you said use F12 to save the Excel file with a different name that the name definitions should also be saved in the new file.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne
Sent: Sunday, June 9, 2019 8:13 AM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

If you use save-as for the new sheets, it works.
At 09:37 AM 6/9/2019, you wrote:
Hi Sieghard,

I’m not able to set this up by defining a name on a worksheet and
then copying that sheet multiple times. Even if I set the scope to the
worksheet rather than the workbook, Jaws doesn’t read column or row
headings on the next sheets.

What you want can be done easily manually by first creating copies of
your first sheet 31 times, one sheet for each day of the month.
Then, place your cursor in the cell of the first sheet where you want
to define the name, press the applications key, up arrow to “Define
name…â€&#65533; and press enter. Type “Titleâ€&#65533;&#65533; if you
wish both column and row headings to be read by Jaws and press enter.
Now, move to sheet two and do the same, except this time type
“Title2â€&#65533; as the name. Continue doing this on subsequent
sheets, each time increasing the number after “Titleâ€&#65533;. Note
that there is no space between “Titleâ€&#65533; and the number.

Not sure if this helps or if you wanted a more automatic method, but I
can’t seem to do it any other way. I even tried grouping the sheets
and then defining a name, but this doesn’t work.

Cheers,

Russell

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Sieghard
Weitzel
Sent: Friday, June 7, 2019 12:08 AM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

Hi Brian,

I attached a little sample spreadsheet I made. I thought I followed
your steps to set it up so Jaws will read the column and row titles,
but I can’t get it to work, what am I doing wrong?

Sieghard

From:
<mailto:main@jfw.groups.io>main@jfw.groups.io
<<mailto:main@jfw.groups.io>main@jfw.groups.io> On Behalf Of Brian
Vogel
Sent: Thursday, June 6, 2019 8:42 PM
To: <mailto:main@jfw.groups.io>main@jfw.groups.io
Subject: Re: Excel rows and columns

Pardon my error, that last technique is the "when I only want it during
this session" method
with JAWS. This is how to set them in the
spreadsheet itself such that JAWS will recognize their existence and
announce them whenever you open a specific spreadsheet:

Assigning a Title Row (Column Titles) and/or Title Column (Row Titles)
in Excel

You can assign column and row titles in Excel.
These are nice because they always work with Excel and are saved to the
workbook. There's no risk of losing a setting in your screen reader.

To add column and row title names:
* Focus on the first cell in the row or column or at the first
cell where the title row and title column intersect
* Open the Name dialog:


i. Open the Formula ribbon (ALT-M)


ii. Activate the “Define Nameâ€&#65533; command (M)


iii. Within the drop-down list, activate “Define Nameâ€&#65533;


iv. The “New Nameâ€&#65533; dialog opens



Focus is placed in the name field. Within the name field, you can name
the focused cell or selected range of cells. In this case, we’re
naming the column or row title:
* Name the cell using the following rules

i. Start the range name with the label
that tells Excel you’re creating a title range
* Title – This tells Excel the column and row that intersect at
the active cell are a title row and column
* ColumnTitle – This tells Excel the focused column contains the
titles for the rows within the range
* RowTitle – this tells Excel the focused row contains titles for
thee columns in the range

ii. Add a name for the range
* Title_WidgetSales
* ColumnTitle_WidgetSales
* RowTitle_WidgetSales

iii.
Optional - Add the last cell in the range preceded by two periods
* Use this when you have multiple regions in a worksheet
* Title_WidgetSales..J25
* ColumTitle_WidgetSales..h32
* RowTitle_WidgetSales..r12
* Remember the cell address referenced is the last cell in the
range for which you are creating titles

The next field in the dialog sets the scope for the name. this is a
combo box. Use UP and DOWN ARROW to choose from between:
* Workbook - the title Is unique and can’t be used elsewhere in
a workbook
* A Specific Worksheet - the name can be used elsewhere in a
workbook

You can add a comment for the named cell or region, this is strictly
for your personal reference and doesn’t affect the echo of the column
or row title name

The last field references the cell name or range of selected cells
you’re naming. You can leave this field alone.

Activate the OK button to save the name and close the dialog.

Save the workbook and the titles are permanently saved and will work on
any computer.

If you have titles set to echo in JAWS, the titles will echo and you
won’t lose the settings.
--

Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763

Here is a test to find out whether your mission in life is complete.
If you’re alive, it isn’t.

~ Lauren Bacall

Russell Solowoniuk
 

Hi Sieghard,

Yes, if you go to Save As and save the workbook with a new name, the defined cell names are saved to the new workbook.

I wonder if you go to "Name Manager", under the Formula tab, press CTRL+ right arrow and you should land on "Name Manager", and from there delete any names you have defined, and then define all your cell names again? I wonder if there are names defined already that might be causing things not to work as they ought to?

Cheers,

Russell

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Sieghard Weitzel
Sent: Sunday, June 9, 2019 9:15 AM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

I assume if I could get it to work for the template I made and then as you said use F12 to save the Excel file with a different name that the name definitions should also be saved in the new file.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne
Sent: Sunday, June 9, 2019 8:13 AM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

If you use save-as for the new sheets, it works.
At 09:37 AM 6/9/2019, you wrote:
Hi Sieghard,

I’m not able to set this up by defining a name on a worksheet and
then copying that sheet multiple times. Even if I set the scope to the
worksheet rather than the workbook, Jaws doesn’t read column or row
headings on the next sheets.

What you want can be done easily manually by first creating copies of
your first sheet 31 times, one sheet for each day of the month.
Then, place your cursor in the cell of the first sheet where you want
to define the name, press the applications key, up arrow to “Define
name…â€&#65533; and press enter. Type “Titleâ€&#65533;&#65533; if you
wish both column and row headings to be read by Jaws and press enter.
Now, move to sheet two and do the same, except this time type
“Title2â€&#65533; as the name. Continue doing this on subsequent
sheets, each time increasing the number after “Titleâ€&#65533;. Note
that there is no space between “Titleâ€&#65533; and the number.

Not sure if this helps or if you wanted a more automatic method, but I
can’t seem to do it any other way. I even tried grouping the sheets
and then defining a name, but this doesn’t work.

Cheers,

Russell

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Sieghard
Weitzel
Sent: Friday, June 7, 2019 12:08 AM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

Hi Brian,

I attached a little sample spreadsheet I made. I thought I followed
your steps to set it up so Jaws will read the column and row titles,
but I can’t get it to work, what am I doing wrong?

Sieghard

From:
<mailto:main@jfw.groups.io>main@jfw.groups.io
<<mailto:main@jfw.groups.io>main@jfw.groups.io> On Behalf Of Brian
Vogel
Sent: Thursday, June 6, 2019 8:42 PM
To: <mailto:main@jfw.groups.io>main@jfw.groups.io
Subject: Re: Excel rows and columns

Pardon my error, that last technique is the "when I only want it during
this session" method
with JAWS. This is how to set them in the
spreadsheet itself such that JAWS will recognize their existence and
announce them whenever you open a specific spreadsheet:

Assigning a Title Row (Column Titles) and/or Title Column (Row Titles)
in Excel

You can assign column and row titles in Excel.
These are nice because they always work with Excel and are saved to the
workbook. There's no risk of losing a setting in your screen reader.

To add column and row title names:
* Focus on the first cell in the row or column or at the first
cell where the title row and title column intersect
* Open the Name dialog:


i. Open the Formula ribbon (ALT-M)


ii. Activate the “Define Nameâ€&#65533; command (M)


iii. Within the drop-down list, activate “Define Nameâ€&#65533;


iv. The “New Nameâ€&#65533; dialog opens



Focus is placed in the name field. Within the name field, you can name
the focused cell or selected range of cells. In this case, we’re
naming the column or row title:
* Name the cell using the following rules

i. Start the range name with the label
that tells Excel you’re creating a title range
* Title – This tells Excel the column and row that intersect at
the active cell are a title row and column
* ColumnTitle – This tells Excel the focused column contains the
titles for the rows within the range
* RowTitle – this tells Excel the focused row contains titles for
thee columns in the range

ii. Add a name for the range
* Title_WidgetSales
* ColumnTitle_WidgetSales
* RowTitle_WidgetSales

iii.
Optional - Add the last cell in the range preceded by two periods
* Use this when you have multiple regions in a worksheet
* Title_WidgetSales..J25
* ColumTitle_WidgetSales..h32
* RowTitle_WidgetSales..r12
* Remember the cell address referenced is the last cell in the
range for which you are creating titles

The next field in the dialog sets the scope for the name. this is a
combo box. Use UP and DOWN ARROW to choose from between:
* Workbook - the title Is unique and can’t be used elsewhere in
a workbook
* A Specific Worksheet - the name can be used elsewhere in a
workbook

You can add a comment for the named cell or region, this is strictly
for your personal reference and doesn’t affect the echo of the column
or row title name

The last field references the cell name or range of selected cells
you’re naming. You can leave this field alone.

Activate the OK button to save the name and close the dialog.

Save the workbook and the titles are permanently saved and will work on
any computer.

If you have titles set to echo in JAWS, the titles will echo and you
won’t lose the settings.
--

Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763

Here is a test to find out whether your mission in life is complete.
If you’re alive, it isn’t.

~ Lauren Bacall

 

I assume if I could get it to work for the template I made and then as you said use F12 to save the Excel file with a different name that the name definitions should also be saved in the new file.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne
Sent: Sunday, June 9, 2019 8:13 AM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

If you use save-as for the new sheets, it works.
At 09:37 AM 6/9/2019, you wrote:
Hi Sieghard,

I’m not able to set this up by defining a name on a worksheet and
then copying that sheet multiple times. Even if I set the scope to the
worksheet rather than the workbook, Jaws doesn’t read column or row
headings on the next sheets.

What you want can be done easily manually by first creating copies of
your first sheet 31 times, one sheet for each day of the month.
Then, place your cursor in the cell of the first sheet where you want
to define the name, press the applications key, up arrow to “Define
name…â€&#65533; and press enter. Type “Titleâ€&#65533;&#65533; if you
wish both column and row headings to be read by Jaws and press enter.
Now, move to sheet two and do the same, except this time type
“Title2â€&#65533; as the name. Continue doing this on subsequent
sheets, each time increasing the number after “Titleâ€&#65533;. Note
that there is no space between “Titleâ€&#65533; and the number.

Not sure if this helps or if you wanted a more automatic method, but I
can’t seem to do it any other way. I even tried grouping the sheets
and then defining a name, but this doesn’t work.

Cheers,

Russell

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Sieghard
Weitzel
Sent: Friday, June 7, 2019 12:08 AM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

Hi Brian,

I attached a little sample spreadsheet I made. I thought I followed
your steps to set it up so Jaws will read the column and row titles,
but I can’t get it to work, what am I doing wrong?

Sieghard

From:
<mailto:main@jfw.groups.io>main@jfw.groups.io
<<mailto:main@jfw.groups.io>main@jfw.groups.io> On Behalf Of Brian
Vogel
Sent: Thursday, June 6, 2019 8:42 PM
To: <mailto:main@jfw.groups.io>main@jfw.groups.io
Subject: Re: Excel rows and columns

Pardon my error, that last technique is the "when I only want it during
this session" method
with JAWS. This is how to set them in the
spreadsheet itself such that JAWS will recognize their existence and
announce them whenever you open a specific spreadsheet:

Assigning a Title Row (Column Titles) and/or Title Column (Row Titles)
in Excel

You can assign column and row titles in Excel.
These are nice because they always work with Excel and are saved to the
workbook. There's no risk of losing a setting in your screen reader.

To add column and row title names:
* Focus on the first cell in the row or column or at the first
cell where the title row and title column intersect
* Open the Name dialog:


i. Open the Formula ribbon (ALT-M)


ii. Activate the “Define Nameâ€&#65533; command (M)


iii. Within the drop-down list, activate “Define Nameâ€&#65533;


iv. The “New Nameâ€&#65533; dialog opens



Focus is placed in the name field. Within the name field, you can name
the focused cell or selected range of cells. In this case, we’re
naming the column or row title:
* Name the cell using the following rules

i. Start the range name with the label
that tells Excel you’re creating a title range
* Title – This tells Excel the column and row that intersect at
the active cell are a title row and column
* ColumnTitle – This tells Excel the focused column contains the
titles for the rows within the range
* RowTitle – this tells Excel the focused row contains titles for
thee columns in the range

ii. Add a name for the range
* Title_WidgetSales
* ColumnTitle_WidgetSales
* RowTitle_WidgetSales

iii.
Optional - Add the last cell in the range preceded by two periods
* Use this when you have multiple regions in a worksheet
* Title_WidgetSales..J25
* ColumTitle_WidgetSales..h32
* RowTitle_WidgetSales..r12
* Remember the cell address referenced is the last cell in the
range for which you are creating titles

The next field in the dialog sets the scope for the name. this is a
combo box. Use UP and DOWN ARROW to choose from between:
* Workbook - the title Is unique and can’t be used elsewhere in
a workbook
* A Specific Worksheet - the name can be used elsewhere in a
workbook

You can add a comment for the named cell or region, this is strictly
for your personal reference and doesn’t affect the echo of the column
or row title name

The last field references the cell name or range of selected cells
you’re naming. You can leave this field alone.

Activate the OK button to save the name and close the dialog.

Save the workbook and the titles are permanently saved and will work on
any computer.

If you have titles set to echo in JAWS, the titles will echo and you
won’t lose the settings.
--

Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763

Here is a test to find out whether your mission in life is complete.
If you’re alive, it isn’t.

~ Lauren Bacall

 

First I have to get it to work in the first place. For some reason I can’t get automatic readings of row and column headings to work using this method at all.

I already have a template of this workbook set up and I usually just open it each time a new month starts and then use F12 to save it but giving it the name of the month.

For example, my template is Sales Summary and I then save it, for example, as Sales Summary June 2019.

I wouldn’t mind setting up the row and column title reading on each sheet separately if I could just get it to work.

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Russell Solowoniuk
Sent: Sunday, June 9, 2019 7:38 AM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

 

Hi Sieghard,

 

I’m not able to set this up by defining a name on a worksheet and then copying that sheet multiple times. Even if I set the scope to the worksheet rather than the workbook, Jaws doesn’t read column or row headings on the next sheets.

 

What you want can be done easily manually by first creating copies of your first sheet 31 times, one sheet for each day of the month. Then, place your cursor in the cell of the first sheet where you want to define the name, press the applications key, up arrow to “Define name…” and press enter. Type “Title” if you wish both column and row headings to be read by Jaws and press enter. Now, move to sheet two and do the same, except this time type “Title2” as the name. Continue doing this on subsequent sheets, each time increasing the number after “Title”. Note that there is no space between “Title” and the number.

 

Not sure if this helps or if you wanted a more automatic method, but I can’t seem to do it any other way. I even tried grouping the sheets and then defining a name, but this doesn’t work.

 

Cheers,

 

Russell

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Sieghard Weitzel
Sent: Friday, June 7, 2019 12:08 AM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

 

Hi Brian,

 

I attached a little sample spreadsheet I made. I thought I followed your steps to set it up so Jaws will read the column and row titles, but I can’t get it to work, what am I doing wrong?

 

Sieghard

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Brian Vogel
Sent: Thursday, June 6, 2019 8:42 PM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

 

Pardon my error, that last technique is the "when I only want it during this session" method with JAWS.   This is how to set them in the spreadsheet itself such that JAWS will recognize their existence and announce them whenever you open a specific spreadsheet:

Assigning a Title Row (Column Titles) and/or Title Column (Row Titles) in Excel

You can assign column and row titles in Excel. These are nice because they always work with Excel and are saved to the workbook. There's no risk of losing a setting in your screen reader.

To add column and row title names:

    1. Focus on the first cell in the row or column or at the first cell where the title row and title column intersect
    2. Open the Name dialog:

                                                               i.      Open the Formula ribbon (ALT-M)

                                                             ii.      Activate the “Define Name” command (M)

                                                           iii.      Within the drop-down list, activate “Define Name”

                                                           iv.      The “New Name” dialog opens

 

Focus is placed in the name field. Within the name field, you can name the focused cell or selected range of cells. In this case, we’re naming the column or row title:

    1. Name the cell using the following rules

                           i.  Start the range name with the label that tells Excel you’re creating a title range

        1. Title – This tells Excel the column and row that intersect at the active cell are a title row and column
        2. ColumnTitle – This tells Excel the focused column contains the titles for the rows within the range
        3. RowTitle – this tells Excel the focused row contains titles for the columns in the range

                            ii.      Add a name for the range

        1. Title_WidgetSales
        2. ColumnTitle_WidgetSales
        3. RowTitle_WidgetSales

                              iii.      Optional - Add the last cell in the range preceded by two periods

        1. Use this when you have multiple regions in a worksheet
        2. Title_WidgetSales..J25
        3. ColumTitle_WidgetSales..h32
        4. RowTitle_WidgetSales..r12
        5. Remember the cell address referenced is the last cell in the range for which you are creating titles

The next field in the dialog sets the scope for the name. this is a combo box. Use UP and DOWN ARROW to choose from between:

  • Workbook - the title Is unique and can’t be used elsewhere in a workbook
  • A Specific Worksheet - the name can be used elsewhere in a workbook

You can add a comment for the named cell or region, this is strictly for your personal reference and doesn’t affect the echo of the column or row title name

The last field references the cell name or range of selected cells you’re naming. You can leave this field alone.

Activate the OK button to save the name and close the dialog.

Save the workbook and the titles are permanently saved and will work on any computer.

If you have titles set to echo in JAWS, the titles will echo and you won’t lose the settings.

--

Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763  

Here is a test to find out whether your mission in life is complete.  If you’re alive, it isn’t.

       ~ Lauren Bacall

Ann Byrne
 

If you use save-as for the new sheets, it works.

At 09:37 AM 6/9/2019, you wrote:
Hi Sieghard,

I’m not able to set this up by defining a name on a worksheet and then copying that sheet multiple times. Even if I set the scope to the worksheet rather than the workbook, Jaws doesn’t read column or row headings on the next sheets.

What you want can be done easily manually by first creating copies of your first sheet 31 times, one sheet for each day of the month. Then, place your cursor in the cell of the first sheet where you want to define the name, press the applications key, up arrow to “Define name…â€&#65533; and press enter. Type “Titleâ€&#65533;&#65533; if you wish both column and row headings to be read by Jaws and press enter. Now, move to sheet two and do the same, except this time type “Title2â€&#65533; as the name. Continue doing this on subsequent sheets, each time increasing the number after “Titleâ€&#65533;. Note that there is no space between “Titleâ€&#65533; and the number.

Not sure if this helps or if you wanted a more automatic method, but I can’t seem to do it any other way. I even tried grouping the sheets and then defining a name, but this doesn’t work.

Cheers,

Russell

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Sieghard Weitzel
Sent: Friday, June 7, 2019 12:08 AM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

Hi Brian,

I attached a little sample spreadsheet I made. I thought I followed your steps to set it up so Jaws will read the column and row titles, but I can’t get it to work, what am I doing wrong?

Sieghard

From: <mailto:main@jfw.groups.io>main@jfw.groups.io <<mailto:main@jfw.groups.io>main@jfw.groups.io> On Behalf Of Brian Vogel
Sent: Thursday, June 6, 2019 8:42 PM
To: <mailto:main@jfw.groups.io>main@jfw.groups.io
Subject: Re: Excel rows and columns

Pardon my error, that last technique is the "when I only want it during this session" method with JAWS. This is how to set them in the spreadsheet itself such that JAWS will recognize their existence and announce them whenever you open a specific spreadsheet:

Assigning a Title Row (Column Titles) and/or Title Column (Row Titles) in Excel

You can assign column and row titles in Excel. These are nice because they always work with Excel and are saved to the workbook. There's no risk of losing a setting in your screen reader.

To add column and row title names:
* Focus on the first cell in the row or column or at the first cell where the title row and title column intersect
* Open the Name dialog:

i. Open the Formula ribbon (ALT-M)

ii. Activate the “Define Nameâ€&#65533; command (M)

iii. Within the drop-down list, activate “Define Nameâ€&#65533;

iv. The “New Nameâ€&#65533; dialog opens



Focus is placed in the name field. Within the name field, you can name the focused cell or selected range of cells. In this case, we’re naming the column or row title:
* Name the cell using the following rules

i. Start the range name with the label that tells Excel you’re creating a title range
* Title – This tells Excel the column and row that intersect at the active cell are a title row and column
* ColumnTitle – This tells Excel the focused column contains the titles for the rows within the range
* RowTitle – this tells Excel the focused row contains titles for thee columns in the range

ii. Add a name for the range
* Title_WidgetSales
* ColumnTitle_WidgetSales
* RowTitle_WidgetSales

iii. Optional - Add the last cell in the range preceded by two periods
* Use this when you have multiple regions in a worksheet
* Title_WidgetSales..J25
* ColumTitle_WidgetSales..h32
* RowTitle_WidgetSales..r12
* Remember the cell address referenced is the last cell in the range for which you are creating titles

The next field in the dialog sets the scope for the name. this is a combo box. Use UP and DOWN ARROW to choose from between:
* Workbook - the title Is unique and can’t be used elsewhere in a workbook
* A Specific Worksheet - the name can be used elsewhere in a workbook

You can add a comment for the named cell or region, this is strictly for your personal reference and doesn’t affect the echo of the column or row title name

The last field references the cell name or range of selected cells you’re naming. You can leave this field alone.

Activate the OK button to save the name and close the dialog.

Save the workbook and the titles are permanently saved and will work on any computer.

If you have titles set to echo in JAWS, the titles will echo and you won’t lose the settings.
--

Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763

Here is a test to find out whether your mission in life is complete. If you’re alive, it isn’t.

~ Lauren Bacall

Russell Solowoniuk
 

Hi Sieghard,

 

I’m not able to set this up by defining a name on a worksheet and then copying that sheet multiple times. Even if I set the scope to the worksheet rather than the workbook, Jaws doesn’t read column or row headings on the next sheets.

 

What you want can be done easily manually by first creating copies of your first sheet 31 times, one sheet for each day of the month. Then, place your cursor in the cell of the first sheet where you want to define the name, press the applications key, up arrow to “Define name…” and press enter. Type “Title” if you wish both column and row headings to be read by Jaws and press enter. Now, move to sheet two and do the same, except this time type “Title2” as the name. Continue doing this on subsequent sheets, each time increasing the number after “Title”. Note that there is no space between “Title” and the number.

 

Not sure if this helps or if you wanted a more automatic method, but I can’t seem to do it any other way. I even tried grouping the sheets and then defining a name, but this doesn’t work.

 

Cheers,

 

Russell

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Sieghard Weitzel
Sent: Friday, June 7, 2019 12:08 AM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

 

Hi Brian,

 

I attached a little sample spreadsheet I made. I thought I followed your steps to set it up so Jaws will read the column and row titles, but I can’t get it to work, what am I doing wrong?

 

Sieghard

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Brian Vogel
Sent: Thursday, June 6, 2019 8:42 PM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

 

Pardon my error, that last technique is the "when I only want it during this session" method with JAWS.   This is how to set them in the spreadsheet itself such that JAWS will recognize their existence and announce them whenever you open a specific spreadsheet:

Assigning a Title Row (Column Titles) and/or Title Column (Row Titles) in Excel

You can assign column and row titles in Excel. These are nice because they always work with Excel and are saved to the workbook. There's no risk of losing a setting in your screen reader.

To add column and row title names:

    1. Focus on the first cell in the row or column or at the first cell where the title row and title column intersect
    2. Open the Name dialog:

                                                               i.      Open the Formula ribbon (ALT-M)

                                                             ii.      Activate the “Define Name” command (M)

                                                           iii.      Within the drop-down list, activate “Define Name”

                                                           iv.      The “New Name” dialog opens

 

Focus is placed in the name field. Within the name field, you can name the focused cell or selected range of cells. In this case, we’re naming the column or row title:

    1. Name the cell using the following rules

                           i.  Start the range name with the label that tells Excel you’re creating a title range

        1. Title – This tells Excel the column and row that intersect at the active cell are a title row and column
        2. ColumnTitle – This tells Excel the focused column contains the titles for the rows within the range
        3. RowTitle – this tells Excel the focused row contains titles for the columns in the range

                            ii.      Add a name for the range

        1. Title_WidgetSales
        2. ColumnTitle_WidgetSales
        3. RowTitle_WidgetSales

                              iii.      Optional - Add the last cell in the range preceded by two periods

        1. Use this when you have multiple regions in a worksheet
        2. Title_WidgetSales..J25
        3. ColumTitle_WidgetSales..h32
        4. RowTitle_WidgetSales..r12
        5. Remember the cell address referenced is the last cell in the range for which you are creating titles

The next field in the dialog sets the scope for the name. this is a combo box. Use UP and DOWN ARROW to choose from between:

  • Workbook - the title Is unique and can’t be used elsewhere in a workbook
  • A Specific Worksheet - the name can be used elsewhere in a workbook

You can add a comment for the named cell or region, this is strictly for your personal reference and doesn’t affect the echo of the column or row title name

The last field references the cell name or range of selected cells you’re naming. You can leave this field alone.

Activate the OK button to save the name and close the dialog.

Save the workbook and the titles are permanently saved and will work on any computer.

If you have titles set to echo in JAWS, the titles will echo and you won’t lose the settings.

--

Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763  

Here is a test to find out whether your mission in life is complete.  If you’re alive, it isn’t.

       ~ Lauren Bacall

 

Sieghard,

           Please send the sample spreadsheet to me via e-mail, as attachments get stripped (or at least they do on the web interface) by this Groups.io group.  I'll take a look and download JAWS so I have it in 40 minute mode.

           Also let me know whether it's column headings, row titles, or both that you're looking to have spoken as you traverse the table.  I do know that when I was last working with Excel and JAWS it will only read the column title once, when you land in that column, if you stay within it (move up/down) and the same was true of the row title (move left/right).

--

Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763  

Here is a test to find out whether your mission in life is complete.  If you’re alive, it isn’t.

       ~ Lauren Bacall

 

Hi Brian,

 

I attached a little sample spreadsheet I made. I thought I followed your steps to set it up so Jaws will read the column and row titles, but I can’t get it to work, what am I doing wrong?

 

Sieghard

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Brian Vogel
Sent: Thursday, June 6, 2019 8:42 PM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

 

Pardon my error, that last technique is the "when I only want it during this session" method with JAWS.   This is how to set them in the spreadsheet itself such that JAWS will recognize their existence and announce them whenever you open a specific spreadsheet:

Assigning a Title Row (Column Titles) and/or Title Column (Row Titles) in Excel

You can assign column and row titles in Excel. These are nice because they always work with Excel and are saved to the workbook. There's no risk of losing a setting in your screen reader.

To add column and row title names:

    1. Focus on the first cell in the row or column or at the first cell where the title row and title column intersect
    2. Open the Name dialog:

                                                               i.      Open the Formula ribbon (ALT-M)

                                                             ii.      Activate the “Define Name” command (M)

                                                           iii.      Within the drop-down list, activate “Define Name”

                                                           iv.      The “New Name” dialog opens

 

Focus is placed in the name field. Within the name field, you can name the focused cell or selected range of cells. In this case, we’re naming the column or row title:

    1. Name the cell using the following rules

                           i.  Start the range name with the label that tells Excel you’re creating a title range

        1. Title – This tells Excel the column and row that intersect at the active cell are a title row and column
        2. ColumnTitle – This tells Excel the focused column contains the titles for the rows within the range
        3. RowTitle – this tells Excel the focused row contains titles for the columns in the range

                            ii.      Add a name for the range

        1. Title_WidgetSales
        2. ColumnTitle_WidgetSales
        3. RowTitle_WidgetSales

                              iii.      Optional - Add the last cell in the range preceded by two periods

        1. Use this when you have multiple regions in a worksheet
        2. Title_WidgetSales..J25
        3. ColumTitle_WidgetSales..h32
        4. RowTitle_WidgetSales..r12
        5. Remember the cell address referenced is the last cell in the range for which you are creating titles

The next field in the dialog sets the scope for the name. this is a combo box. Use UP and DOWN ARROW to choose from between:

  • Workbook - the title Is unique and can’t be used elsewhere in a workbook
  • A Specific Worksheet - the name can be used elsewhere in a workbook

You can add a comment for the named cell or region, this is strictly for your personal reference and doesn’t affect the echo of the column or row title name

The last field references the cell name or range of selected cells you’re naming. You can leave this field alone.

Activate the OK button to save the name and close the dialog.

Save the workbook and the titles are permanently saved and will work on any computer.

If you have titles set to echo in JAWS, the titles will echo and you won’t lose the settings.

--

Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763  

Here is a test to find out whether your mission in life is complete.  If you’re alive, it isn’t.

       ~ Lauren Bacall

 

How can I set this up in a workbook which has let’s say 31 sheets, one for each day of the month. Each sheet is set up identically and I would like to se this up on the first sheet and have it so Jaws reads row and column titles on each subsequent sheet. I tried this so many times and just can’t figure it out.

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Brian Vogel
Sent: Thursday, June 6, 2019 8:42 PM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

 

Pardon my error, that last technique is the "when I only want it during this session" method with JAWS.   This is how to set them in the spreadsheet itself such that JAWS will recognize their existence and announce them whenever you open a specific spreadsheet:

Assigning a Title Row (Column Titles) and/or Title Column (Row Titles) in Excel

You can assign column and row titles in Excel. These are nice because they always work with Excel and are saved to the workbook. There's no risk of losing a setting in your screen reader.

To add column and row title names:

    1. Focus on the first cell in the row or column or at the first cell where the title row and title column intersect
    2. Open the Name dialog:

                                                               i.      Open the Formula ribbon (ALT-M)

                                                             ii.      Activate the “Define Name” command (M)

                                                           iii.      Within the drop-down list, activate “Define Name”

                                                           iv.      The “New Name” dialog opens

 

Focus is placed in the name field. Within the name field, you can name the focused cell or selected range of cells. In this case, we’re naming the column or row title:

    1. Name the cell using the following rules

                           i.  Start the range name with the label that tells Excel you’re creating a title range

        1. Title – This tells Excel the column and row that intersect at the active cell are a title row and column
        2. ColumnTitle – This tells Excel the focused column contains the titles for the rows within the range
        3. RowTitle – this tells Excel the focused row contains titles for the columns in the range

                            ii.      Add a name for the range

        1. Title_WidgetSales
        2. ColumnTitle_WidgetSales
        3. RowTitle_WidgetSales

                              iii.      Optional - Add the last cell in the range preceded by two periods

        1. Use this when you have multiple regions in a worksheet
        2. Title_WidgetSales..J25
        3. ColumTitle_WidgetSales..h32
        4. RowTitle_WidgetSales..r12
        5. Remember the cell address referenced is the last cell in the range for which you are creating titles

The next field in the dialog sets the scope for the name. this is a combo box. Use UP and DOWN ARROW to choose from between:

  • Workbook - the title Is unique and can’t be used elsewhere in a workbook
  • A Specific Worksheet - the name can be used elsewhere in a workbook

You can add a comment for the named cell or region, this is strictly for your personal reference and doesn’t affect the echo of the column or row title name

The last field references the cell name or range of selected cells you’re naming. You can leave this field alone.

Activate the OK button to save the name and close the dialog.

Save the workbook and the titles are permanently saved and will work on any computer.

If you have titles set to echo in JAWS, the titles will echo and you won’t lose the settings.

--

Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763  

Here is a test to find out whether your mission in life is complete.  If you’re alive, it isn’t.

       ~ Lauren Bacall

Marty Hutchings
 

Or,  Here is the quick and durty way to get JAWS to read the row  and columb titles.
1.  Place the curser at the beginning of the row and at the top of the columb that you want spoken.
2.  To get Jaws to say the row titles, press and hold Insert, Alt, Control and press R.
3.  To get Jaws to say the columb titles, press and hold Insert, Alt, Control and press C.
It is a bit like playing finger twister, but it works.
 
Love in Christ
Marty
For our struggle is not against flesh and blood, but against the rulers, against the powers, against the world forces of this darkness, against the spiritual forces of wickedness in the heavenly places.
Therefore, take up the full armor of God, so that you will be able to resist in the evil day, and having done everything, to stand firm.
Ephesians 6:12, 13
 

Sent: Thursday, June 06, 2019 10:41 PM
Subject: Re: Excel rows and columns
 
Pardon my error, that last technique is the "when I only want it during this session" method with JAWS.   This is how to set them in the spreadsheet itself such that JAWS will recognize their existence and announce them whenever you open a specific spreadsheet:

Assigning a Title Row (Column Titles) and/or Title Column (Row Titles) in Excel

You can assign column and row titles in Excel. These are nice because they always work with Excel and are saved to the workbook. There's no risk of losing a setting in your screen reader.

To add column and row title names:

    1. Focus on the first cell in the row or column or at the first cell where the title row and title column intersect
    2. Open the Name dialog:

                                                               i.      Open the Formula ribbon (ALT-M)

                                                             ii.      Activate the “Define Name” command (M)

                                                           iii.      Within the drop-down list, activate “Define Name”

                                                           iv.      The “New Name” dialog opens

 

Focus is placed in the name field. Within the name field, you can name the focused cell or selected range of cells. In this case, we’re naming the column or row title:

    1. Name the cell using the following rules

                           i.  Start the range name with the label that tells Excel you’re creating a title range

        1. Title – This tells Excel the column and row that intersect at the active cell are a title row and column
        2. ColumnTitle – This tells Excel the focused column contains the titles for the rows within the range
        3. RowTitle – this tells Excel the focused row contains titles for the columns in the range

                            ii.      Add a name for the range

        1. Title_WidgetSales
        2. ColumnTitle_WidgetSales
        3. RowTitle_WidgetSales

                              iii.      Optional - Add the last cell in the range preceded by two periods

        1. Use this when you have multiple regions in a worksheet
        2. Title_WidgetSales..J25
        3. ColumTitle_WidgetSales..h32
        4. RowTitle_WidgetSales..r12
        5. Remember the cell address referenced is the last cell in the range for which you are creating titles

The next field in the dialog sets the scope for the name. this is a combo box. Use UP and DOWN ARROW to choose from between:

  • Workbook - the title Is unique and can’t be used elsewhere in a workbook
  • A Specific Worksheet - the name can be used elsewhere in a workbook

You can add a comment for the named cell or region, this is strictly for your personal reference and doesn’t affect the echo of the column or row title name

The last field references the cell name or range of selected cells you’re naming. You can leave this field alone.

Activate the OK button to save the name and close the dialog.

Save the workbook and the titles are permanently saved and will work on any computer.

If you have titles set to echo in JAWS, the titles will echo and you won’t lose the settings.

--

Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763  

Here is a test to find out whether your mission in life is complete.  If you’re alive, it isn’t.

       ~ Lauren Bacall

 

Pardon my error, that last technique is the "when I only want it during this session" method with JAWS.   This is how to set them in the spreadsheet itself such that JAWS will recognize their existence and announce them whenever you open a specific spreadsheet:

Assigning a Title Row (Column Titles) and/or Title Column (Row Titles) in Excel

You can assign column and row titles in Excel. These are nice because they always work with Excel and are saved to the workbook. There's no risk of losing a setting in your screen reader.

To add column and row title names:

    1. Focus on the first cell in the row or column or at the first cell where the title row and title column intersect
    2. Open the Name dialog:

                                                               i.      Open the Formula ribbon (ALT-M)

                                                             ii.      Activate the “Define Name” command (M)

                                                           iii.      Within the drop-down list, activate “Define Name”

                                                           iv.      The “New Name” dialog opens

 

Focus is placed in the name field. Within the name field, you can name the focused cell or selected range of cells. In this case, we’re naming the column or row title:

    1. Name the cell using the following rules

                           i.  Start the range name with the label that tells Excel you’re creating a title range

        1. Title – This tells Excel the column and row that intersect at the active cell are a title row and column
        2. ColumnTitle – This tells Excel the focused column contains the titles for the rows within the range
        3. RowTitle – this tells Excel the focused row contains titles for the columns in the range

                            ii.      Add a name for the range

        1. Title_WidgetSales
        2. ColumnTitle_WidgetSales
        3. RowTitle_WidgetSales

                              iii.      Optional - Add the last cell in the range preceded by two periods

        1. Use this when you have multiple regions in a worksheet
        2. Title_WidgetSales..J25
        3. ColumTitle_WidgetSales..h32
        4. RowTitle_WidgetSales..r12
        5. Remember the cell address referenced is the last cell in the range for which you are creating titles

The next field in the dialog sets the scope for the name. this is a combo box. Use UP and DOWN ARROW to choose from between:

  • Workbook - the title Is unique and can’t be used elsewhere in a workbook
  • A Specific Worksheet - the name can be used elsewhere in a workbook

You can add a comment for the named cell or region, this is strictly for your personal reference and doesn’t affect the echo of the column or row title name

The last field references the cell name or range of selected cells you’re naming. You can leave this field alone.

Activate the OK button to save the name and close the dialog.

Save the workbook and the titles are permanently saved and will work on any computer.

If you have titles set to echo in JAWS, the titles will echo and you won’t lose the settings.

--

Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763  

Here is a test to find out whether your mission in life is complete.  If you’re alive, it isn’t.

       ~ Lauren Bacall

 

From a tutorial I put together for a former student.  There is another way to do this via JAWS such that it "doesn't stick," but my client always wanted JAWS to read column headers (and, sometimes, row titles) every time he needed to touch a given spreadsheet, so this is how to set things up in the spreadsheet itself such that JAWS will read these any time it's opened:

You will receive many files where the column title row has not been defined such that JAWS can read it.  Once you figure out which row contains the column titles, do the following:

1.     INS+V, Bring up JAWS Verbosity Settings

2.     Type column, in the Verbosity Search Box

3.     Arrow down to Column Titles Row Range Set

4.     Hit Spacebar, this should cause JAWS to announce the row number you were sitting on that contains the column titles.  (If this is on the first row JAWS will say one but if it’s the fifth row it will say five.)

If you also want JAWS to announce the rows by the data that you have in the first column, you will want to continue as follows:

1.     Hit Down Arrow to move to the Row Titles for Column Range Set

2.     Hit spacebar and JAWS will announce the column letter that contains the data that will be used to announce the row title.  So you will hear A if it’s column A, B if column B, etc.

--

Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763  

Here is a test to find out whether your mission in life is complete.  If you’re alive, it isn’t.

       ~ Lauren Bacall

Brian Switzer
 

Good morning,

I know this can be done somehow. How do you get JAWS to read the row and column headers in Excel? Thanks!

All the Best,
Brian Switzer