I've been working on this one and the simplest answer to your question is that you need to set excel rather than JAWS to be able to carry any of these settings forward in excel or to enable another jaws user to be able to access the same settings you have set to the document when exporting the document to them.
Anyway, here is what I know to anser your question: 1. First, select the range of cells you want to set as your defined region: Put the focus on the cell in the top left of the data region then Cntrl+shift+8 selects the region automatically. Or, you can simply use the go to feature or select the cells manually. 2. Press ALT+M M D to move to define names from the Formulas tab 3. Do not use spaces when defining the name of your data region. 4. Tab to "Scope" and enter the combo box to select the scope of your region..Choose workbook or sheet. Tap OK and there you have it Also, incidentally, if you want to manage these settings type alt +M+M and arrow to manage titles button. Furthermore the following is a more lengthy means to setting it up but looks to be more exacting. I'm attempting to set up multiple regions and have jaws read them independently....not sure that is possible...FS is looking into it. This is what I know about it: You can define individual row and/or column titles for different regions in the same workbook. To define a row and/or column title for region, you use the same procedure described in Defining Row and Column Titles to assign a specific name to a cell in the heading row and/or column. However, you must use the following procedure when defining names for row and column titles that are specific to one region: 1. Type "TitleRegion," "RowTitleRegion," or "ColumnTitleRegion" depending on whether this cell is in the heading row, heading column, or both. 2. Type the region number. For example, you would type a "1" if the cells were in the first region. There should be no space between the previous text and this number. 3. Type a period followed by the coordinates of the top, left cell in the 0t08 region (for example, "A1"). 4. Type a period followed by the coordinates of the bottom, right cell in the region (for example, "N9"). 5. Type a period followed by the worksheet number. For example, you would type a "1" if the cell was in worksheet 1. For example, assume you have a spreadsheet with a region whose boundaries are row 1 at column A and row 9 at column N. It also has a second region with boundaries of row 10 at column C and row 14 at column D. Both regions are on worksheet 1. To define row 1 as the row containing column headers for the cells in the first region, you would assign the following name to cell A1: ColumnTitleRegion1.A1.N9.1. To define row 9 as the row containing column headers for the cells in the second region, you would assign the following name to cell C10: ColumnTitleRegion2.C10.D14.1. Hope this is useful... Greg From: Jfw [mailto:[email protected]] On Behalf Of Ann Byrne via Jfw Sent: Saturday, December 27, 2014 5:11 PM To: [email protected] Subject: Reading column/row titles in Excel JAWS 16, windows 8.1, Excel 2013. I believe I have followed the instructions for naming column titles with JAWS, *not using control-alt-insert-c. I want to be able to save-as my document and have the column title announcement carry to the new document. if someone has made this work, please send me step-by-step instructions. I think I am step-by-stepping according to the JAWS training materials, but my column titles are not being announced. Thanks, Ann _______________________________________________ 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
