Date
1 - 9 of 9
excel row's and column reading title issue
|
Faraz
hello list, i am facing issue of reading row's and column title in excel 2013 with jaws 2019. i even apply the required setting in jaws verbosity but it is still not reading column titles for row's. i believe it is because of new jaws 2019 as i have been using the same excel file . if any of you facing the same issue please do let me know the fix.
thanks in advance. -- With best regards, Faraz q.
|
|
|
|
Ann Byrne
In the JAWS training materials, there are instructions for making a bookmark to describe row and column titles. If you use those, you need to be sure that in quick settings
toggle quoted messageShow quoted text
Title Reading\Workbook, Worksheet and Region Settings\Excel Settings\Define Name Column and Row Titles Override is turned off. The JAWS hot key for turning on column settings is insert+alt+shift+c and for rows is insert+alt+shift+r It's a real finger stretch. Remember that insert+h while in an application lists the hot keys for the application. Good luck.
At 03:21 AM 7/3/2019, you wrote:
hello list, i am facing issue of reading row's and column title in excel 2013 with jaws 2019. i even apply the required setting in jaws verbosity but it is still not reading column titles for row's. i believe it is because of new jaws 2019 as i have been using the same excel file . if any of you facing the same issue please do let me know the fix.
|
|
|
|
Justin Williams
Try insert control alt r on your row title and insert control alt c for your column title.
toggle quoted messageShow quoted text
-----Original Message-----
From: jaws-users-list@groups.io [mailto:jaws-users-list@groups.io] On Behalf Of Faraz Sent: Wednesday, July 3, 2019 4:21 AM To: jaws-users-list@groups.io Subject: [jaws-users] excel row's and column reading title issue hello list, i am facing issue of reading row's and column title in excel 2013 with jaws 2019. i even apply the required setting in jaws verbosity but it is still not reading column titles for row's. i believe it is because of new jaws 2019 as i have been using the same excel file . if any of you facing the same issue please do let me know the fix. thanks in advance. -- With best regards, Faraz q.
|
|
|
|
Jim Pursley
Since JAWS 2018, I've found the ins/Alt/control R or c to be only temporary. It won't hold for me at least when I exit or when I save the spreadsheet. But it is handy for quick column and row title naming. More permanent is the way Microsoft set it up in Excel, using that applications key to scroll up (faster than down) to define name. Click on define name and write titleregion1..(end of the spreadsheet) then either hit enter or tab out to the end and hit OK. Using this method is permanent once you save the file. It will hold even if you need to temporarily exite the spreadsheet without closing. You can also use the ribbon menus under the formula tab to define a name, but the application key is a lot faster.
toggle quoted messageShow quoted text
Additionally, the process works great if you want to have JAWS read columns and titles of multiple regions (titleregion2.. etc. Alas, my simple R and C method has givenway to more typing, but at least I don't fret any longer when opening a spreadsheet. Note: The method I mentioned above should work in Excel 2013, too, though I've not tried it.
On 7/3/2019 9:30 AM, Justin Williams wrote:
Try insert control alt r on your row title and insert control alt c for your column title.
|
|
|
|
Faraz
Thanks for the help. i tried the solution and its work now. a bit more help. i am actually using multiple data region in my work book and wanting to know if i can setup individual row's and column reading settings for each of them ? and how ?
toggle quoted messageShow quoted text
On 7/4/2019 1:00 AM, Jim Pursley wrote:
Since JAWS 2018, I've found the ins/Alt/control R or c to be only temporary. It won't hold for me at least when I exit or when I save the spreadsheet. But it is handy for quick column and row title naming. More permanent is the way Microsoft set it up in Excel, using that applications key to scroll up (faster than down) to define name. Click on define name and write titleregion1..(end of the spreadsheet) then either hit enter or tab out to the end and hit OK. Using this method is permanent once you save the file. It will hold even if you need to temporarily exite the spreadsheet without closing. You can also use the ribbon menus under the formula tab to define a name, but the application key is a lot faster. --
With best regards, Faraz q.
|
|
|
|
Ann Byrne
If you use the Excel bookmark function described in the JAWS training materials, yes. I don't know whether you can have more than one region with the JAWS keys.
toggle quoted messageShow quoted text
At 03:11 AM 7/4/2019, you wrote:
Thanks for the help. i tried the solution and its work now. a bit more help. i am actually using multiple data region in my work book and wanting to know if i can setup individual row's and column reading settings for each of them ? and how ?
|
|
|
|
Jim Pursley
Yes, you can use the titleregionx to delineate rows and columns in specific regions. You absolutely must have the title reading override OFF, as the first responder said. If the titles don't read for you once you've set them up, first suspect the override position in the Excel quick settings.
toggle quoted messageShow quoted text
You dont even have to use title in the name. But, there's one important step you MUST do to get your columns and rows line up as you want them. You will need to position your cursor on the top left cell before you look for define name and start the naming process. Insert end will take you to the lower right end of the spreadsheet to give you a view of the size of the whole thing, but if you organize by regions you'll need of course to set up ranges for each region. Like the golf ball, you'll be a titleist when you mark Excel titles using define name.On 7/4/2019 5:11 AM, Faraz wrote:
Thanks for the help. i tried the solution and its work now. a bit more help. i am actually using multiple data region in my work book and wanting to know if i can setup individual row's and column reading settings for each of them ? and how ?
|
|
|
|
Faraz
thanks Jim, I am not Excel savvy person but sometimes i need to do work on excel with multiple regions. I understand and will apply the solution however, i have never messed up advance settings in excel with jaws thats why feeling a bit hard. i will get back to you if i find hard to manage data regions in respect to jaws row's and column reading title settings.
toggle quoted messageShow quoted text
On 7/5/2019 2:22 AM, Jim Pursley wrote:
Yes, you can use the titleregionx to delineate rows and columns in specific regions. You absolutely must have the title reading override OFF, as the first responder said. If the titles don't read for you once you've set them up, first suspect the override position in the Excel quick settings. --
With best regards, Faraz q.
|
|
|
|
Faraz
once someone shared me Excel 2010 tutorials recorded by assistive technology and I took allot of help from them. Now, I am using MS 2016 office pack and appreciate if you have tutorials for office or excel 2016 recorded by same institute.
toggle quoted messageShow quoted text
Thank you.
On 7/5/2019 2:22 AM, Jim Pursley wrote:
Yes, you can use the titleregionx to delineate rows and columns in specific regions. You absolutely must have the title reading override OFF, as the first responder said. If the titles don't read for you once you've set them up, first suspect the override position in the Excel quick settings. --
With best regards, Faraz q.
|
|
|