moderated removing column and/or row titles in excel


Gene Warner
 

Hi everyone!

I know how to define a row or column as a column or row title, insert+control+alt+C or insert+control+alt+R.

But I cannot find how to remove a previously defined column or row title. Anybody know?

Thanks!
Gene...


Justin Williams
 

I would have to look for it, but some where in verbosity should be clarn column and row titles.

Justin

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Gene Warner
Sent: Sunday, July 17, 2022 2:35 PM
To: JAWS support list <main@jfw.groups.io>
Subject: removing column and/or row titles in excel

Hi everyone!

I know how to define a row or column as a column or row title,
insert+control+alt+C or insert+control+alt+R.

But I cannot find how to remove a previously defined column or row title. Anybody know?

Thanks!
Gene...


Gene Warner
 

That's not what I'm looking for. The insert+control+alt+C or R commands tells JAWS which column or row I want it to use for the titles, on the spreadsheet I am working on, I accidentally set column titles when I wanted row titles, now I want to undo that mistake, but still have JAWS read the titles if I choose later to define it again.

What you are proposing would turn off reading column and/or row titles for spreadsheets as well as for html and PDFs.

Gene...

Gene...

On 7/17/2022 2:48 PM, Justin Williams wrote:
I would have to look for it, but some where in verbosity should be clarn column and row titles.
Justin
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Gene Warner
Sent: Sunday, July 17, 2022 2:35 PM
To: JAWS support list <main@jfw.groups.io>
Subject: removing column and/or row titles in excel
Hi everyone!
I know how to define a row or column as a column or row title,
insert+control+alt+C or insert+control+alt+R.
But I cannot find how to remove a previously defined column or row title. Anybody know?
Thanks!
Gene...


Gene Warner
 

That's not what I'm looking for. The insert+control+alt+C or R commands tells JAWS which column or row I want it to use for the titles, on the spreadsheet I am working on, I accidentally set column titles when I wanted row titles, now I want to undo that mistake, but still have JAWS read the titles if I choose later to define it again.

What you are proposing would turn off reading column and/or row titles for spreadsheets as well as for html and PDFs.

For now I manually edited the .JSI file for the spreadsheet to accomplish my goal, but I'm thinking that there has to be a better way.

Thanks!
Gene...

Gene...

On 7/17/2022 2:48 PM, Justin Williams wrote:
I would have to look for it, but some where in verbosity should be clarn column and row titles.
Justin
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Gene Warner
Sent: Sunday, July 17, 2022 2:35 PM
To: JAWS support list <main@jfw.groups.io>
Subject: removing column and/or row titles in excel
Hi everyone!
I know how to define a row or column as a column or row title,
insert+control+alt+C or insert+control+alt+R.
But I cannot find how to remove a previously defined column or row title. Anybody know?
Thanks!
Gene...


Justin Williams
 

Okay, I apologize, then. I was in th emiddle of something, and I'd have to go searching.

Justin

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Gene Warner
Sent: Sunday, July 17, 2022 2:55 PM
To: main@jfw.groups.io
Subject: Re: removing column and/or row titles in excel

That's not what I'm looking for. The insert+control+alt+C or R commands tells JAWS which column or row I want it to use for the titles, on the spreadsheet I am working on, I accidentally set column titles when I wanted row titles, now I want to undo that mistake, but still have JAWS read the titles if I choose later to define it again.

What you are proposing would turn off reading column and/or row titles for spreadsheets as well as for html and PDFs.

Gene...

Gene...


On 7/17/2022 2:48 PM, Justin Williams wrote:
I would have to look for it, but some where in verbosity should be clarn column and row titles.

Justin


-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Gene
Warner
Sent: Sunday, July 17, 2022 2:35 PM
To: JAWS support list <main@jfw.groups.io>
Subject: removing column and/or row titles in excel

Hi everyone!

I know how to define a row or column as a column or row title,
insert+control+alt+C or insert+control+alt+R.

But I cannot find how to remove a previously defined column or row title. Anybody know?

Thanks!
Gene...











Gene Warner
 

No problem, and no apologies needed, perhaps my explanation of what I was looking for could have been better.

Like you, I am in the middle of an important project. In my case it is causing me a bit of stress so I'm not thinking as clearly as I could be.

Thanks!
Gene...

On 7/17/2022 3:12 PM, Justin Williams wrote:
Okay, I apologize, then. I was in th emiddle of something, and I'd have to go searching.
Justin
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Gene Warner
Sent: Sunday, July 17, 2022 2:55 PM
To: main@jfw.groups.io
Subject: Re: removing column and/or row titles in excel
That's not what I'm looking for. The insert+control+alt+C or R commands tells JAWS which column or row I want it to use for the titles, on the spreadsheet I am working on, I accidentally set column titles when I wanted row titles, now I want to undo that mistake, but still have JAWS read the titles if I choose later to define it again.
What you are proposing would turn off reading column and/or row titles for spreadsheets as well as for html and PDFs.
Gene...
Gene...
On 7/17/2022 2:48 PM, Justin Williams wrote:
I would have to look for it, but some where in verbosity should be clarn column and row titles.

Justin


-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Gene
Warner
Sent: Sunday, July 17, 2022 2:35 PM
To: JAWS support list <main@jfw.groups.io>
Subject: removing column and/or row titles in excel

Hi everyone!

I know how to define a row or column as a column or row title,
insert+control+alt+C or insert+control+alt+R.

But I cannot find how to remove a previously defined column or row title. Anybody know?

Thanks!
Gene...











Ann Byrne
 

the most direct way is
1. Open JAWS utilities on the JAWS screen
2. Arrow all the way down to 'explore my settings"
3. Open personalized settings.
4. Navigate to the file that has the same name as your spread sheet, with the extension .jsi and delete it.

that will remove all the JAWS settings for the particular spreadsheet and you can start over.

I strongly prefer to use the Excel bookmark feature for row and column titles.

With your cursor at the beginning of the row or column header (or the intersection of both)
1. Press the application key.
2. arrow up two or three times to "define name dot-dot-dot" and press enter. JAWS will speak the contents of the cell you are on, but just ignore him.
3. If you want row titles only, type the word "rowtitle".
If you want only column titles type "columntitle".
If you want both row and column titles, type "title'.
4. Press enter.

These entries are in the bookmark manager, which you reach with alt-m, then n., so they can be easily deleted.

Good luck!


Ann Byrne
 

the most direct way is
1. Open JAWS utilities on the JAWS screen
2. Arrow all the way down to 'explore my settings"
3. Open personalized settings.
4. Navigate to the file that has the same name as your spread sheet, with the extension .jsi and delete it.

that will remove all the JAWS settings for the particular spreadsheet and you can start over.

I strongly prefer to use the Excel bookmark feature for row and column titles.

With your cursor at the beginning of the row or column header (or the intersection of both)
1. Press the application key.
2. arrow up two or three times to "define name dot-dot-dot" and press enter. JAWS will speak the contents of the cell you are on, but just ignore him.
3. If you want row titles only, type the word "rowtitle".
If you want only column titles type "columntitle".
If you want both row and column titles, type "title'.
4. Press enter.

These entries are in the bookmark manager, which you reach with alt-m, then n., so they can be easily deleted.

Good luck!

At 02:01 PM 7/17/2022, you wrote:
That's not what I'm looking for. The insert+control+alt+C or R commands tells JAWS which column or row I want it to use for the titles, on the spreadsheet I am working on, I accidentally set column titles when I wanted row titles, now I want to undo that mistake, but still have JAWS read the titles if I choose later to define it again.

What you are proposing would turn off reading column and/or row titles for spreadsheets as well as for html and PDFs.

For now I manually edited the .JSI file for the spreadsheet to accomplish my goal, but I'm thinking that there has to be a better way.

Thanks!
Gene...

Gene...


On 7/17/2022 2:48 PM, Justin Williams wrote:
I would have to look for it, but some where in verbosity should be clarn column and row titles.
Justin

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Gene Warner
Sent: Sunday, July 17, 2022 2:35 PM
To: JAWS support list <main@jfw.groups.io>
Subject: removing column and/or row titles in excel
Hi everyone!
I know how to define a row or column as a column or row title,
insert+control+alt+C or insert+control+alt+R.
But I cannot find how to remove a previously defined column or row title. Anybody know?
Thanks!
Gene...







Gene Warner
 

I will have to try that next time, thanks!

Gene...

On 7/17/2022 6:44 PM, Ann Byrne wrote:
the most direct way is
1. Open JAWS utilities on the JAWS screen
2. Arrow all the way down to 'explore my settings"
3. Open personalized settings.
4. Navigate to the file that has the same name as your spread sheet, with the extension .jsi and delete it.
that will remove all the JAWS settings for the particular spreadsheet and you can start over.
I strongly prefer to use the Excel bookmark feature for row and column titles.
With your cursor at the beginning of the row or column header (or the intersection of both)
1.  Press the application key.
2. arrow up two or three times to "define name dot-dot-dot" and press enter.  JAWS will speak the contents of the cell you are on, but just ignore him.
3. If you want row titles only, type the word "rowtitle".
If you want only column titles type "columntitle".
If you want both row and column titles, type "title'.
4. Press enter.
These entries are in the bookmark manager, which you reach with alt-m, then n., so they can be easily deleted.
Good luck!


Gene Warner
 

Well I tried it, it did something but JAWS wasn't reading any of the titles like it does when you the insert+control+alt+C or R functions.

Thanks anyway!
Gene...

On 7/17/2022 7:16 PM, Gene Warner via groups.io wrote:
I will have to try that next time, thanks!
Gene...
On 7/17/2022 6:44 PM, Ann Byrne wrote:
the most direct way is
1. Open JAWS utilities on the JAWS screen
2. Arrow all the way down to 'explore my settings"
3. Open personalized settings.
4. Navigate to the file that has the same name as your spread sheet, with the extension .jsi and delete it.

that will remove all the JAWS settings for the particular spreadsheet and you can start over.

I strongly prefer to use the Excel bookmark feature for row and column titles.

With your cursor at the beginning of the row or column header (or the intersection of both)
1.  Press the application key.
2. arrow up two or three times to "define name dot-dot-dot" and press enter.  JAWS will speak the contents of the cell you are on, but just ignore him.
3. If you want row titles only, type the word "rowtitle".
If you want only column titles type "columntitle".
If you want both row and column titles, type "title'.
4. Press enter.

These entries are in the bookmark manager, which you reach with alt-m, then n., so they can be easily deleted.

Good luck!








Joe
 

Hi,
It does work but the instructions left something out. The proper way is to add a user defined name for the worksheet that is in focus and the ending cell coordinate. For example:
TitleMoth..X100
Month in the above example is the user defined name which can be anything you would like. The two periods are placeholders.. The X is the ending column and 100 is the ending row for the data. Leave no spaces and accept the defaults as you tab to OK and press enter. This is the method suggested by Dan Clark from Freedom Scientific and has the added value that if the workbook is sent to another Jaws user They do not have to use the Jaws keystrokes . If you want an example of a workbook using this method let me know.
Joe
Picture of Owl with Mortar Board and Computer

Dr. Joe L. Todd CVRT
Phone: 616.951.2142

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Gene Warner
Sent: Sunday, July 17, 2022 7:46 PM
To: main@jfw.groups.io
Subject: Re: removing column and/or row titles in excel

Well I tried it, it did something but JAWS wasn't reading any of the titles like it does when you the insert+control+alt+C or R functions.

Thanks anyway!
Gene...


On 7/17/2022 7:16 PM, Gene Warner via groups.io wrote:
I will have to try that next time, thanks!

Gene...


On 7/17/2022 6:44 PM, Ann Byrne wrote:
the most direct way is
1. Open JAWS utilities on the JAWS screen 2. Arrow all the way down
to 'explore my settings"
3. Open personalized settings.
4. Navigate to the file that has the same name as your spread sheet,
with the extension .jsi and delete it.

that will remove all the JAWS settings for the particular spreadsheet
and you can start over.

I strongly prefer to use the Excel bookmark feature for row and
column titles.

With your cursor at the beginning of the row or column header (or the
intersection of both) 1. Press the application key.
2. arrow up two or three times to "define name dot-dot-dot" and press
enter. JAWS will speak the contents of the cell you are on, but just
ignore him.
3. If you want row titles only, type the word "rowtitle".
If you want only column titles type "columntitle".
If you want both row and column titles, type "title'.
4. Press enter.

These entries are in the bookmark manager, which you reach with
alt-m, then n., so they can be easily deleted.

Good luck!











Ann Byrne
 

The step that I missed including is to go to JAWS quick settings and be sure that
"define name column and row titles override" is off.
then the process works.

At 08:01 AM 7/18/2022, you wrote:
Hi,
It does work but the instructions left something out. The proper way is to add a user defined name for the worksheet that is in focus and the ending cell coordinate. For example:
TitleMoth..X100
Month in the above example is the user defined name which can be anything you would like. The two periods are placeholders.. The X is the ending column and 100 is the ending row for the data. Leave no spaces and accept the defaults as you tab to OK and press enter. This is the method suggested by Dan Clark from Freedom Scientific and has the added value that if the workbook is sent to another Jaws user They do not have to use the Jaws keystrokes . If you want an example of a workbook using this method let me know.
Joe
Picture of Owl with Mortar Board and Computer

Dr. Joe L. Todd CVRT
Phone: 616.951.2142


-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Gene Warner
Sent: Sunday, July 17, 2022 7:46 PM
To: main@jfw.groups.io
Subject: Re: removing column and/or row titles in excel

Well I tried it, it did something but JAWS wasn't reading any of the titles like it does when you the insert+control+alt+C or R functions.

Thanks anyway!
Gene...


On 7/17/2022 7:16 PM, Gene Warner via groups.io wrote:
I will have to try that next time, thanks!

Gene...


On 7/17/2022 6:44 PM, Ann Byrne wrote:
the most direct way is
1. Open JAWS utilities on the JAWS screen 2. Arrow all the way down
to 'explore my settings"
3. Open personalized settings.
4. Navigate to the file that has the same name as your spread sheet,
with the extension .jsi and delete it.

that will remove all the JAWS settings for the particular spreadsheet
and you can start over.

I strongly prefer to use the Excel bookmark feature for row and
column titles.

With your cursor at the beginning of the row or column header (or the
intersection of both) 1. Press the application key.
2. arrow up two or three times to "define name dot-dot-dot" and press
enter. JAWS will speak the contents of the cell you are on, but just
ignore him.
3. If you want row titles only, type the word "rowtitle".
If you want only column titles type "columntitle".
If you want both row and column titles, type "title'.
4. Press enter.

These entries are in the bookmark manager, which you reach with
alt-m, then n., so they can be easily deleted.

Good luck!


















Gene Warner
 

Thanks, I'll try it next time.

Gene...

On 7/18/2022 8:56 PM, Ann Byrne wrote:
The step that I missed including is to go to JAWS quick settings and be sure that
"define name column and row titles override" is off.
then the process works.
At 08:01 AM 7/18/2022, you wrote:
Hi,
It does work but the instructions left something out. The proper way is to add a user defined name for the worksheet that is in focus and the ending cell coordinate. For example:
TitleMoth..X100
Month in the above example is the user defined name which can be anything you would like. The two periods  are placeholders.. The  X is the ending column and 100 is the ending row for the data. Leave no spaces and accept the defaults as you tab to OK and press enter. This is the method suggested by Dan Clark from Freedom Scientific and has the added value that if the workbook is sent to another Jaws user They do not have to use the Jaws keystrokes . If you want an example of a workbook using this method let me know.
Joe
Picture of Owl with Mortar Board and Computer

Dr. Joe L. Todd CVRT
Phone: 616.951.2142


-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Gene Warner
Sent: Sunday, July 17, 2022 7:46 PM
To: main@jfw.groups.io
Subject: Re: removing column and/or row titles in excel

Well I tried it, it did something but JAWS wasn't reading any of the titles like it does when you the insert+control+alt+C or R functions.

Thanks anyway!
Gene...


On 7/17/2022 7:16 PM, Gene Warner via groups.io wrote:
I will have to try that next time, thanks!

Gene...


On 7/17/2022 6:44 PM, Ann Byrne wrote:
the most direct way is
1. Open JAWS utilities on the JAWS screen 2. Arrow all the way down
to 'explore my settings"
3. Open personalized settings.
4. Navigate to the file that has the same name as your spread sheet,
with the extension .jsi and delete it.

that will remove all the JAWS settings for the particular spreadsheet
and you can start over.

I strongly prefer to use the Excel bookmark feature for row and
column titles.

With your cursor at the beginning of the row or column header (or the
intersection of both) 1.  Press the application key.
2. arrow up two or three times to "define name dot-dot-dot" and press
enter.  JAWS will speak the contents of the cell you are on, but just
ignore him.
3. If you want row titles only, type the word "rowtitle".
If you want only column titles type "columntitle".
If you want both row and column titles, type "title'.
4. Press enter.

These entries are in the bookmark manager, which you reach with
alt-m, then n., so they can be easily deleted.

Good luck!


















Gene Warner
 

I just tried this with a new spreadsheet I'm creating and it works. It's a bit more involved that the the insert+control+alt+C or R JAWS commands, but I can see how this makes it easy to remove them if you want to.

Thanks!
Gene...

On 7/18/2022 8:56 PM, Ann Byrne wrote:
The step that I missed including is to go to JAWS quick settings and be sure that
"define name column and row titles override" is off.
then the process works.
At 08:01 AM 7/18/2022, you wrote:
Hi,
It does work but the instructions left something out. The proper way is to add a user defined name for the worksheet that is in focus and the ending cell coordinate. For example:
TitleMoth..X100
Month in the above example is the user defined name which can be anything you would like. The two periods  are placeholders.. The  X is the ending column and 100 is the ending row for the data. Leave no spaces and accept the defaults as you tab to OK and press enter. This is the method suggested by Dan Clark from Freedom Scientific and has the added value that if the workbook is sent to another Jaws user They do not have to use the Jaws keystrokes . If you want an example of a workbook using this method let me know.
Joe
Picture of Owl with Mortar Board and Computer

Dr. Joe L. Todd CVRT
Phone: 616.951.2142


-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Gene Warner
Sent: Sunday, July 17, 2022 7:46 PM
To: main@jfw.groups.io
Subject: Re: removing column and/or row titles in excel

Well I tried it, it did something but JAWS wasn't reading any of the titles like it does when you the insert+control+alt+C or R functions.

Thanks anyway!
Gene...


On 7/17/2022 7:16 PM, Gene Warner via groups.io wrote:
I will have to try that next time, thanks!

Gene...


On 7/17/2022 6:44 PM, Ann Byrne wrote:
the most direct way is
1. Open JAWS utilities on the JAWS screen 2. Arrow all the way down
to 'explore my settings"
3. Open personalized settings.
4. Navigate to the file that has the same name as your spread sheet,
with the extension .jsi and delete it.

that will remove all the JAWS settings for the particular spreadsheet
and you can start over.

I strongly prefer to use the Excel bookmark feature for row and
column titles.

With your cursor at the beginning of the row or column header (or the
intersection of both) 1.  Press the application key.
2. arrow up two or three times to "define name dot-dot-dot" and press
enter.  JAWS will speak the contents of the cell you are on, but just
ignore him.
3. If you want row titles only, type the word "rowtitle".
If you want only column titles type "columntitle".
If you want both row and column titles, type "title'.
4. Press enter.

These entries are in the bookmark manager, which you reach with
alt-m, then n., so they can be easily deleted.

Good luck!