Hi Ed, I've done this successfully in excel 2003, but for whatever reason, can't get it to work in excel 2010.
I have an old post in which someone suggests pressing the key combination jaws key plus alt plus control plus C to enable column header reading. I don't know about you, but I don't seem to have the necessary finger dexterity to accomplish this combination, so can't say whether it works. As for the define names function in excel, I have no idea why it isn't working as advertized. I would be interested to know if you get it to work. Kimber On 4/21/14, Ed Marquette <[email protected]> wrote: > 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/20140421/9a1e7352/attachment.html> > _______________________________________________ > Jfw mailing list > [email protected] > http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com > -- Kimberly _______________________________________________ Jfw mailing list [email protected] http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com
