Hi Ed; I have the same setup you have and have spent numerous hours trying to get this feature to work as described. Even Eric D. at FS doesn't use it. Eric recently posted the following regarding a check book feature.
Get the file from: http://www.jaws-users.com/text/Office/Sample-checkbook-register.html 1. Save the file and give it a name you wish to use. 2. Now open the newly named file in Excel and move to Column A, Row 4, (this is the intersection of the row and column headings and the next step is to inform JAWS of that). 3. Press Insert + V to get into Quick Settings of JAWS for Excel. 4. Press the letter T, and then down arrow to the item that says "Define Name Column and Row Titles Override Off". 5. Press Space Bar a couple of times so the item above is set to "On for the Current File". 6. Now down arrow a few times to the item called: "Column Titles to Row Range". Press Space and you should hear it reflect 4, since you were on row 4. 7. Now down arrow once to the item called: "Row Titles to Column Range". Press Space and you should hear it reflect A, since you were in column A. 8. Tab 3 times now to the OK button and press enter to dismiss the Dialog and you are done. In the future, anytime you open a spread sheet with the name you gave this one, it will assume that Row 4 has the column headings and Column A has the row headings. If you are moving around in the area below and to the right of that intersecting point, it should read the headings as you navigate to make it easier to understand where you are. Hope this Helps, Eric Try it. It works. David Maynard Franklin NC [email protected] -----Original Message----- From: Jfw [mailto:[email protected]] On Behalf Of Ed Marquette Sent: Monday, April 21, 2014 3:41 AM To: The Jaws for Windows support list. Subject: Excel Title Reading Listers: I would like to have JAWS read column and row titles automatically as I arrow through a template spreadsheet. I went through Dan Clark's explanation from the Freedom Scientific training materials twice, and I still cannot make this work. First, let me make it clear that this spreadsheet gets bounced around a bit. So, using the "quick settings" approach doesn't work for my situation reliably. So, I'm trying to use Excel and JAWS to enter labels that will stick with the template spreadsheet wherever it resides on my computer/network. Second, I actually think Dan Clark may be skipping a step, but I have such limited familiarity with Excel that I'm not sure. In his training session, he opens up a training spreadsheet, goes to the row/column intersecting cell (top left) and then, in Excel 2010, hits alt plus m followed by m. When he does so, the region title edit field contains a number of words joined together by underline characters. Dan points out that you cannot use spaces in this thing, which I'll call a region title. Interestingly, Dan never mentions how Excel generates this title for the region. I just get the contents of the top left cell. He then proceeds to type in a new title. In that case, he enters TitleRegion1..F8. Now, I know he is able to skip the top left coordinate because his cursor was sitting in the top left coordinate when he undertook the naming process. Of course, after he hits ENTER, the row and column headings read just fine. Nothing like that happens for me. By the way, I'm using JAWS 15, Excel 2010, and Windows 7. Here is where I think the problem is. In my little spreadsheet, A3 is "ClientName"; B3 is "ClientNumber"; C3 is "MatterName"; D3 is "MatterNumber"; E3 is "Time"; and F3 is "Description". There is nothing in Column A below A3. That gets filled in with the client names. When I hit Alt plus m and then m, instead of getting some name separated with a bunch of underline characters, all I get is "ClientName," which is the column title for column A. I think the region may need to be named before I assign the "TitleRegion1" followed by the region's coordinates. I think Dan must have skipped a step, something that had already been done to his training spreadsheet. I guess the other problem might be that, unlike his sample spreadsheet, I do not have all the row titles filled in when I enter the name. I don't use Excel all that often, but this little spreadsheet could be helpful - if it worked. Any assistance would be appreciated. Sent from my Yoga IdeaPad I. Edward Marquette Universal Phone: 408.692.5640 Mobile: 816.812.0088 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/201404 21/9a1e7352/attachment.html> _______________________________________________ Jfw mailing list [email protected] http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list [email protected] http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com
