moderated undoing effect in Excel


Mario
 

I've used Alt+Control+JAWSKey+R which defines the selected columns as those containing row titles for the current region.
I've also used Alt+Control+JAWSKey+C which defines the selected rows as those containing column titles for the current region.

what do I have to do if I do not need or want the effect anymore?


 

Mario,

           I have never been clear whether this does something within JAWS itself (in which case what follows will probably not apply) or if it works with the Define Names command of Excel itself.

           If it is working with the Define Name command, I believe you can get rid of them by selecting the row/column you originally selected, hitting CTRL+SHIFT+F3, and when the dialog comes up for Create Names from Selection then uncheck the checkbox(es) checked, and hit OK.  I think that will undefine them.  It's worth a try, anyway, as the CTRL+SHIFT+F3 is how you initially define them via Excel itself based on what's the selected range.
--

Brian - Windows 10 Pro, 64-Bit, Version 1909, Build 18363  

Tolerance is the positive and cordial effort to understand another's beliefs, practices, and habits without necessarily sharing or accepting them.

        ~ Joshua Liebman


Ann Byrne
 

Using these keystrokes creates a .jsi file, which you will need to delete in order to remove the command.

Go to the JAWS screen.
Utilities
explore utilities folder.
Explore my settings.
Personalized settings.
the excel.jsi file will be there.
Wipe it out.

If that doesn't work, holler and I will look harder.At 06:09 PM 4/17/2020, you wrote:

I've used Alt+Control+JAWSKey+R which defines the selected columns as those containing row titles for the current region.
I've also used Alt+Control+JAWSKey+C which defines the selected rows as those containing column titles for the current region.

what do I have to do if I do not need or want the effect anymore?


NFB Lab 4
 

If you have defined the title reading for row and or columns, and do not
want them to read anymore. All you have to do is open the file. Hit insert V
for the quick settings. Type in title, and arrow down until you hear title
reading, and space until it says none.

I hope this helps,
Thom

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne
Sent: Friday, April 17, 2020 9:53 PM
To: main@jfw.groups.io
Subject: Re: undoing effect in Excel

Using these keystrokes creates a .jsi file, which you will need to delete in
order to remove the command.

Go to the JAWS screen.
Utilities
explore utilities folder.
Explore my settings.
Personalized settings.
the excel.jsi file will be there.
Wipe it out.

If that doesn't work, holler and I will look harder.At 06:09 PM 4/17/2020,
you wrote:
I've used Alt+Control+JAWSKey+R which defines the selected columns as
those containing row titles for the current region.
I've also used Alt+Control+JAWSKey+C which defines the selected rows as
those containing column titles for the current region.

what do I have to do if I do not need or want the effect anymore?


Mario
 

this works, and BTW the exact verbage is title reading detection, but there might be a situation where I apply the command for rows when I should have used the command for columns.
is there a keystroke that neutralizes the one I mistakenly applied, leaving the other one active? or do I just have to delete the JSI file that Ann mentioned and start again?

-------- Original Message --------
From: NFB Lab 4 [mailto:nfbsc.lab.4@gmail.com]
To: <main@jfw.groups.io>
Date: Sunday, April 19, 2020, 2:37 PM
Subject: undoing effect in Excel
If you have defined the title reading for row and or columns, and do not
want them to read anymore. All you have to do is open the file. Hit insert V
for the quick settings. Type in title, and arrow down until you hear title
reading, and space until it says none.

I hope this helps,
Thom

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne
Sent: Friday, April 17, 2020 9:53 PM
To: main@jfw.groups.io
Subject: Re: undoing effect in Excel

Using these keystrokes creates a .jsi file, which you will need to delete in
order to remove the command.

Go to the JAWS screen.
Utilities
explore utilities folder.
Explore my settings.
Personalized settings.
the excel.jsi file will be there.
Wipe it out.

If that doesn't work, holler and I will look harder.At 06:09 PM 4/17/2020,
you wrote:
I've used Alt+Control+JAWSKey+R which defines the selected columns as
those containing row titles for the current region.
I've also used Alt+Control+JAWSKey+C which defines the selected rows as
those containing column titles for the current region.

what do I have to do if I do not need or want the effect anymore?










.


NFB Lab 4
 

No, when you go to quick settings, under that title reading. You can choose between column title, row title, both, or none. The space bar will cycle between them.

Thom

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Mario
Sent: Sunday, April 19, 2020 4:49 PM
To: main@jfw.groups.io
Subject: Re: undoing effect in Excel

this works, and BTW the exact verbage is title reading detection, but there might be a situation where I apply the command for rows when I should have used the command for columns.
is there a keystroke that neutralizes the one I mistakenly applied, leaving the other one active? or do I just have to delete the JSI file that Ann mentioned and start again?

-------- Original Message --------
From: NFB Lab 4 [mailto:nfbsc.lab.4@gmail.com]
To: <main@jfw.groups.io>
Date: Sunday, April 19, 2020, 2:37 PM
Subject: undoing effect in Excel
If you have defined the title reading for row and or columns, and do not want them to read anymore. All you have to do is open the file. Hit insert V for the quick settings. Type in title, and arrow down until you hear title reading, and space until it says none.

I hope this helps,
Thom

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne
Sent: Friday, April 17, 2020 9:53 PM
To: main@jfw.groups.io
Subject: Re: undoing effect in Excel

Using these keystrokes creates a .jsi file, which you will need to delete in order to remove the command.

Go to the JAWS screen.
Utilities
explore utilities folder.
Explore my settings.
Personalized settings.
the excel.jsi file will be there.
Wipe it out.

If that doesn't work, holler and I will look harder.At 06:09 PM 4/17/2020, you wrote:
I've used Alt+Control+JAWSKey+R which defines the selected columns as those containing row titles for the current region.
I've also used Alt+Control+JAWSKey+C which defines the selected rows as those containing column titles for the current region.

what do I have to do if I do not need or want the effect anymore?










.


 

There's a reason I suggest NOT using a screen-reader dependent method to assign a column of row titles, or a row of column titles, when the ability exists in Excel itself, and every screen reader I have worked with allows you to toggle on/of the reading of a column title when switching columns or row title when changing rows if such are defined in the spreadsheet.

And if you've filled your cells across a respective row with what you want as your column titles, or down your column with what you want as your row titles, it's simple to set up in Excel.

--

Brian - Windows 10 Pro, 64-Bit, Version 1909, Build 18363  

The purpose of education is not to validate ignorance but to overcome it.
       ~ Lawrence Krauss


Mario
 

tom, I only see title reading detection that can be cycled.
Here's what I get when I search for title after pressing insert+v:

9 Search Results List box
Monitor Cell Titles Read checked Monitoring CellsExcel Settings
Title Cell Font and Formatting Indication not checked FormattingWorkbook, Worksheet and Region SettingsExcel Settings
Title Reading Workbook, Worksheet and Region SettingsExcel Settings
Define Name Column and Row Titles Override On for the Current File Title ReadingWorkbook, Worksheet and Region SettingsExcel Settings
Title Reading Detection Off Title ReadingWorkbook, Worksheet and Region SettingsExcel Settings
Titles Read For Cells Right and Below Title ReadingWorkbook, Worksheet and Region SettingsExcel Settings
Column Titles to Row Range Set Undefined Title ReadingWorkbook, Worksheet and Region SettingsExcel Settings
Row Titles to Column Range Set Undefined Title ReadingWorkbook, Worksheet and Region SettingsExcel Settings
Clear Title And Total Definitions checked Title ReadingWorkbook, Worksheet and Region SettingsExcel Settings

-------- Original Message --------
From: NFB Lab 4 [mailto:nfbsc.lab.4@gmail.com]
To: <main@jfw.groups.io>
Date: Sunday, April 19, 2020, 5:09 PM
Subject: undoing effect in Excel
No, when you go to quick settings, under that title reading. You can choose between column title, row title, both, or none. The space bar will cycle between them.

Thom

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Mario
Sent: Sunday, April 19, 2020 4:49 PM
To: main@jfw.groups.io
Subject: Re: undoing effect in Excel

this works, and BTW the exact verbage is title reading detection, but there might be a situation where I apply the command for rows when I should have used the command for columns.
is there a keystroke that neutralizes the one I mistakenly applied, leaving the other one active? or do I just have to delete the JSI file that Ann mentioned and start again?

-------- Original Message --------
From: NFB Lab 4 [mailto:nfbsc.lab.4@gmail.com]
To: <main@jfw.groups.io>
Date: Sunday, April 19, 2020, 2:37 PM
Subject: undoing effect in Excel
If you have defined the title reading for row and or columns, and do not want them to read anymore. All you have to do is open the file. Hit insert V for the quick settings. Type in title, and arrow down until you hear title reading, and space until it says none.

I hope this helps,
Thom

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne
Sent: Friday, April 17, 2020 9:53 PM
To: main@jfw.groups.io
Subject: Re: undoing effect in Excel

Using these keystrokes creates a .jsi file, which you will need to delete in order to remove the command.

Go to the JAWS screen.
Utilities
explore utilities folder.
Explore my settings.
Personalized settings.
the excel.jsi file will be there.
Wipe it out.

If that doesn't work, holler and I will look harder.At 06:09 PM 4/17/2020, you wrote:
I've used Alt+Control+JAWSKey+R which defines the selected columns as those containing row titles for the current region.
I've also used Alt+Control+JAWSKey+C which defines the selected rows as those containing column titles for the current region.

what do I have to do if I do not need or want the effect anymore?










.









.


Ann Byrne
 


NFB Lab 4
 

Title Reading Detection Off Title ReadingWorkbook, Worksheet and Region SettingsExcel Settings This is what you were looking for. It is set off, if you hit the it will go to either red columns or red rose or red both columns and rows.

On Apr 19, 2020, at 8:29 PM, Mario <mrb620@hotmail.com> wrote:

tom, I only see title reading detection that can be cycled.
Here's what I get when I search for title after pressing insert+v:

9 Search Results List box
Monitor Cell Titles Read checked Monitoring CellsExcel Settings
Title Cell Font and Formatting Indication not checked FormattingWorkbook, Worksheet and Region SettingsExcel Settings
Title Reading Workbook, Worksheet and Region SettingsExcel Settings
Define Name Column and Row Titles Override On for the Current File Title ReadingWorkbook, Worksheet and Region SettingsExcel Settings
Title Reading Detection Off Title ReadingWorkbook, Worksheet and Region SettingsExcel Settings
Titles Read For Cells Right and Below Title ReadingWorkbook, Worksheet and Region SettingsExcel Settings
Column Titles to Row Range Set Undefined Title ReadingWorkbook, Worksheet and Region SettingsExcel Settings
Row Titles to Column Range Set Undefined Title ReadingWorkbook, Worksheet and Region SettingsExcel Settings
Clear Title And Total Definitions checked Title ReadingWorkbook, Worksheet and Region SettingsExcel Settings

-------- Original Message --------
From: NFB Lab 4 [mailto:nfbsc.lab.4@gmail.com]
To: <main@jfw.groups.io>
Date: Sunday, April 19, 2020, 5:09 PM
Subject: undoing effect in Excel
No, when you go to quick settings, under that title reading. You can choose between column title, row title, both, or none. The space bar will cycle between them.

Thom

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Mario
Sent: Sunday, April 19, 2020 4:49 PM
To: main@jfw.groups.io
Subject: Re: undoing effect in Excel

this works, and BTW the exact verbage is title reading detection, but there might be a situation where I apply the command for rows when I should have used the command for columns.
is there a keystroke that neutralizes the one I mistakenly applied, leaving the other one active? or do I just have to delete the JSI file that Ann mentioned and start again?

-------- Original Message --------
From: NFB Lab 4 [mailto:nfbsc.lab.4@gmail.com]
To: <main@jfw.groups.io>
Date: Sunday, April 19, 2020, 2:37 PM
Subject: undoing effect in Excel
If you have defined the title reading for row and or columns, and do not want them to read anymore. All you have to do is open the file. Hit insert V for the quick settings. Type in title, and arrow down until you hear title reading, and space until it says none.

I hope this helps,
Thom

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne
Sent: Friday, April 17, 2020 9:53 PM
To: main@jfw.groups.io
Subject: Re: undoing effect in Excel

Using these keystrokes creates a .jsi file, which you will need to delete in order to remove the command.

Go to the JAWS screen.
Utilities
explore utilities folder.
Explore my settings.
Personalized settings.
the excel.jsi file will be there.
Wipe it out.

If that doesn't work, holler and I will look harder.At 06:09 PM 4/17/2020, you wrote:
I've used Alt+Control+JAWSKey+R which defines the selected columns as those containing row titles for the current region.
I've also used Alt+Control+JAWSKey+C which defines the selected rows as those containing column titles for the current region.

what do I have to do if I do not need or want the effect anymore?










.









.