Date
1 - 10 of 10
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.
toggle quoted message
Show quoted text
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. |
|
|
|
NFB Lab 4
If you have defined the title reading for row and or columns, and do not
toggle quoted message
Show quoted text
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 |
|
|
|
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.
toggle quoted message
Show quoted text
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@...] 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.
toggle quoted message
Show quoted text
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@...] 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. |
|
|
|
Mario
tom, I only see title reading detection that can be cycled.
toggle quoted message
Show quoted text
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@...] 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@...] 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
Find a link for the instructions for setting row and column titles on the JAWS training downloads page:
<https://www.freedomscientific.com/training/jaws/additional-jaws-training-downloads/>https://www.freedomscientific.com/training/jaws/additional-jaws-training-downloads/ |
|
|
|
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.
toggle quoted message
Show quoted text
On Apr 19, 2020, at 8:29 PM, Mario <mrb620@...> wrote: |
|
|