Excel Row and Column Title Reading
Excel Row and Column Title Reading Defining Row and Column Titles Before JAWS can read the titles of cells within a spreadsheet, you must specify which columns and/or rows contain those titles. To define row titles, move to the column containing the row titles and press ALT+CTRL+SHIFT+R. To define column titles, move to the row containing the column titles and press ALT+CTRL+SHIFT+C. Tip: You can also press INSERT+V to use the Adjust JAWS Verbosity dialog box to define row and column titles. Alternatively, you can use Excel's naming function to specify which rows and columns contain cell titles. Using names instead of JAWS commands makes the spreadsheet accessible to any user of JAWS 6.10 or later. There is no need to provide other users with the spreadsheet's .jsi file because the row and column title information is saved in the worksheet. This feature allows any spreadsheet author to define row and column titles without installing or using JAWS. To use names to define row and column titles, do the following: List of 4 items 1. Move to the first cell in the column or row containing the titles. If the spreadsheet contains both row and column titles, move to the cell where these two intersect. 2. From the Insert menu, select Name and press RIGHT ARROW. 3. Select Define and press ENTER. 4. If the column contains row titles, type "RowTitle" and press ENTER. If the row contains column titles, type "ColumnTitle" and press ENTER. If the cell is the intersection of both row and column titles, type "Title" and press ENTER. If you are defining column/row titles for any worksheet other than worksheet 1, you must add the number of the worksheet after "RowTitle," "ColumnTitle," or "Title." For example, if you are defining a row containing column titles in worksheet 4, you would type "ColumnTitle4." To hear which worksheet you are in, press INSERT+F1. list end Tip: You can define more than one row or column as a title range. For example, if you want to define rows 1 and 2 as column titles, select both rows and then assign the name "ColumnTitle" to them. JAWS can now recognize the cell as the beginning of a range of row and/or column titles. If a particular worksheet within a workbook has title rows and/or columns defined using this feature, you cannot use the standard JAWS method for defining title rows and/or columns. However, if another worksheet in the same workbook does not have row and column titles defined using the Excel naming function, you can use the standard JAWS method. In addition, you cannot use this feature if the spreadsheet contains multiple regions. Overriding Named Titles Any JAWS user can override row and column title information provided by the spreadsheet author. To do this, press INSERT+V while you are in Excel to open the Adjust JAWS Verbosity dialog box. Select "Override Named Titles" and use the SPACEBAR to cycle through the available options. Choose "On for the current file" to override named titles only in the currently open spreadsheet. Choose "On for all files" to override named titles in all spreadsheets that you open in Excel. If you want to use the row and column title information provided by the author again, choose "Off." Defining Row and Column Titles for Worksheets with Multiple Regions 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 specifc 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: List of 5 items 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 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. list end 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. Changing Title Reading Options You can change how JAWS reads row and column titles you have defined in the Excel verbosity options. Press INSERT+V, select "Title Reading," and press the SPACEBAR to choose one of the following: List of 4 items . Off - JAWS does not announce row or column titles. . Read Row Titles - When you move to a different row, JAWS reads the row title. JAWS does not announce column titles. . Read Column Titles - When you move to a different column, JAWS reads the column title. JAWS does not announce row titles. . Read Both Titles - When you move to a different column, JAWS reads the column title. When you move to a different row, JAWS reads the row title. list end Reading Columns and Rows Containing Totals You can indicate which columns and/or rows contain the total of values in other cells. If the spreadsheet calculates column totals, move to the row containing these totals and press CTRL+INSERT+DELETE. If the spreadsheet calculates row totals, move to the column containing these totals and press CTRL+INSERT+ENTER. Tip: You can also press INSERT+V to use the Adjust JAWS Verbosity dialog box to specify which row and column contains totals. After you have defined the row that contains column totals, you can press INSERT+DELETE to hear the total for the current column. Similarly, after you have defined the column that contains row totals, you can press INSERT+ENTER to hear the total for the current row. JAWS only reads the value displayed in the totals row/column and does not automatically perform the necessary calculations. You must use Excel to insert a formula that will calculate the total of a given range of cells. For more information on using formulas, refer to Miscellaneous Excel Hints. Reading Visible Rows and Columns of a Spreadsheet JAWS provides keystrokes to read only the portion of the spreadsheet that is visible on the screen. If Title reading is enabled, pressing these keystrokes reads the appropriate title cells followed by the visible cells' contents. Table with 2 columns and 7 rows Description Keystroke Read visible row INSERT+UP ARROW Read visible row to current cell INSERT+HOME Read visible row from current cell INSERT+PAGE UP Read visible column INSERT+CTRL+UP ARROW Read visible column to current cell INSERT+CTRL+HOME Read visible column from current cell INSERT+CTRL+PAGE UP table end Using One Settings File for Similar Spreadsheets with Different File Names When you define settings like row and column titles and totals, you may want these settings to be available for other versions of the spreadsheet that have different names. For example, suppose that you define row and column totals for a spreadsheet named Sales1.xls. This spreadsheet is updated each month, and the name is changed accordingly. Therefore, next month's spreadsheet will be named Sales2.xls and so on. However, by default, JAWS only loads settings (.jsi) files for spreadsheets with the same file name. JAWS will not use settings you defined for Sales1.xls for Sales2.xls. However, JAWS provides a feature that allows you to apply an existing settings file to a spreadsheet with a different name that is similar in design. To use this feature, open the spreadsheet in Excel, press INSERT+V, select the option "Workbook Settings," and press the SPACEBAR to choose "Best Match." JAWS searches for the closest matching settings file available and applies it to the current workbook. In the previous example, the spreadsheet Sales2.xls would use the settings file you created for Sales1.xls (excel_Sales1.xls.jsi). This feature makes it easy to apply your verbosity settings to subsequent versions of a spreadsheet without creating new a file each time the name changes. Experience is a hard teacher because she gives the test first, the lesson afterward. Vernon Law 11 " Visit the JAWS Users List home page at: http://www.jaws-users.com Address for the list archives: http://www.mail-archive.com/[email protected] To post to this group, send email to [email protected] To unsubscribe from this group, send an email to [EMAIL PROTECTED] For help from Mailman with your account Put the word help in the subject or body of a blank message to: [EMAIL PROTECTED] Use the following form in order to contact the management team http://www.jaws-users.com/managers.php If you wish to join the Blind Computing list send a blank email to the following address: [EMAIL PROTECTED]
