Re: Advanced Excel Tutorial with JAWS
- From: "Andrew Diaz Russell" <a.diazrussell@xxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Thu, 26 Jan 2006 22:10:43 -0000
MessageYou are a star. Thank you for that. Andrew. ----- Original Message ----- From: Wade Hemmelrick To: jfw@xxxxxxxxxxxxx Sent: Thursday, January 26, 2006 4:09 PM Subject: RE: Advanced Excel Tutorial with JAWS I do have the keystrokes and hints from JAWS 7 posted below. However, most of these commands should work pretty well with earlier JAWS versions. Also, you will find specific keystrokes and hints by opening your JAWS 5.1 Help system. Furthermore, you might also find some relevant JAWS TSN's for Excel by visiting the JAWS Headquarters link within FreedomScientific.com.--HTH--WH Microsoft Excel Virtual Viewer Demos With JAWSKey+F1 activated, the following sample blank workbook information is displayed in the Virtual Viewer: This is the spreadsheet area. The worksheet name is Sheet1 and its number is 1. The region spans a 1 through a 1 visible range is A1 through K31 0 of the 341 visible cells contain data. There are 3 worksheets in the Book1 workbook. To move to a particular worksheet use CTRL+SHIFT+S. Gridlines are on Surrounding Border of active cell: Thin Grid Line The current settings file name is C:\Documents and Settings\Wade Hemmelrick\Application Data\Freedom Scientific\JAWS\7.0\Settings\enu\PersonalizedSettings\excel_Book1.JSI. Say a list of some common Excel shortcuts JAWSKey+W Say the coordinates of the current cell JAWSKey+C Say a cell's formula CTRL+F2 Present the cell's formula in a message box CTRL+F2 twice quickly Review selected cells JAWSKey+SHIFT+DOWN ARROW Set or clear title, total or monitor cell definitions use the Verbosity Dialog JAWSKey+V Say the row title ALT+SHIFT+R Say the column title ALT+SHIFT+C Say the row total JAWSKey+DELETE Say the column total JAWSKey+ENTER Set up to 10 monitor cells for the current worksheet JAWSKey+SHIFT+1 through 0 on the number row Say any of the ten monitor cells for this sheet ALT+SHIFT+1 through 0 on the number row Move to a monitor cell CTRL+SHIFT+M Return to the last cell which had focus before moving to a monitor Cell CTRL+SHIFT+` Say the contents of the first 4 cells in the column ALT Key with 1 through 4 on the number row, Say the contents of the first 4 cells in the row ALT+CTRL Key with 1 through 4 on the number row Move to the prior or next worksheet CTRL+PAGE UP or CTRL+PAGE DOWN Move to a particular worksheet CTRL+SHIFT+S List cells with comments visible in the active window CTRL+SHIFT+' Say a cell's comment if visible ALT+SHIFT+' List cells with data visible in the active window CTRL+SHIFT+D List cells with data in the current row CTRL+SHIFT+R List cells with data in the current column CTRL+SHIFT+C List cells at horizontal and vertical PageBreaks CTRL+SHIFT+B Select an object on the worksheet CTRL+SHIFT+O Select a hyperlink on the worksheet JAWSKey+F7 Say the hyperlink address for a cell containing a hyperlink ALT+SHIFT+H Describe the border of the active cell ALT+SHIFT+B Focus on the AutoFilter Menu CTRL+SHIFT+A Announce the coordinates of the range of cells visible in the active window ALT+SHIFT+V Say the status of gridlines in the active window ALT+SHIFT+G Say a list of some common JAWS keystrokes for Excel JAWSKey+H Here are some Excel Keyboard shortcuts Auto sum, use ALT+EQUALS Go to cell, use F5 to start a formula, use equals Select the entire column, use CTRL+SPACEBAR Select the entire row, use SHIFT+SPACEBAR use standard window selecting keystrokes to select specific cells move to edge of data regions, use CTRL+ARROW Keys Switch sheets, use CTRL+PAGE UP or CTRL+PAGE DOWN Move left or right one screen, use ALT+PAGE UP or ALT+PAGE DOWN to move to the end of any row or column Use the END Key, then the ARROW Key in the desired direction Selecting text, use combinations of CTRL and SHIFT with ARROWS, HOME, and END Insert the date, use control plus semicolon Insert the time, use CTRL+SHIFT+SEMICOLON Microsoft Excel for Windows is a powerful spreadsheet application. You can use spreadsheets to collect and analyze information, including records, lesson plans, notes, activity budgets, professional organization information, and other data. You may want to use Excel for compiling scientific data, weather journals, financial reports, nutritional diaries, and legislative voting records. Please visit http://www.microsoft.com for more information on Excel. Note: The information in this section has been verified for Excel 2000 through 2003. The level of support JAWS provides for other versions of this product may vary. JAWS Commands for Excel Informational Keystrokes for Columns Informational Keystrokes for Rows Miscellaneous Informational Keystrokes Navigation Keystrokes Selection Keystrokes Configuration Keystrokes Note: Many Excel features are also available in the Adjust JAWS Verbosity dialog box. To access these verbosity options, press INSERT+V while you are in Excel. Use the arrow keys to select an option, and then press the SPACEBAR to cycle through the available settings. Summary: JAWS Excel Commands Description Command Informational Keystrokes for Columns List cells in current column CTRL+SHIFT+C Read column total INSERT+NUM PAD ENTER Say column title ALT+SHIFT+C Set column titles to row ALT+CTRL+SHIFT+C Set current column to the column containing row totals CTRL+INSERT+ENTER Informational Keystrokes for Rows List cells in current row CTRL+SHIFT+R Read row total INSERT+DELETE Say row title ALT+SHIFT+R Set row titles to column ALT+CTRL+SHIFT+R Set current row to the row containing column totals CTRL+INSERT+DELETE Miscellaneous Informational Keystrokes Describe cell border ALT+SHIFT+B Lists cells at page break CTRL+SHIFT+B List cells with comments CTRL+SHIFT+APOSTROPHE Read cell comment ALT+SHIFT+APOSTROPHE List Visible cells with data CTRL+SHIFT+D List defined monitor cells CTRL+SHIFT+M List worksheets CTRL+SHIFT+S Say range of cells visible in active window ALT+SHIFT+V Read hyperlink ALT+SHIFT+H Report gridline status ALT+SHIFT+G Say active cell coordinates INSERT+C Say last cell navigated to when creating a formula CTRL+NUM PAD 5 Say Excel version CTRL+INSERT+V Say contents of focus rectangle INSERT+N Say cell font and attributes INSERT+F Say formula CTRL+F2 Read spelling error and suggestion INSERT+F7 Display detailed cell appearance information INSERT+TAB twice quickly Navigation Keystrokes Move to prior screen in spreadsheet ALT+PAGE UP Move to next screen in spreadsheet ALT+PAGE DOWN Next Sheet CTRL+PAGE DOWN Prior Sheet CTRL+PAGE UP Move down to the edge of current data region CTRL+DOWN ARROW Move up to the edge of current data region CTRL+UP ARROW Move left to the edge of current data region CTRL+LEFT ARROW Move right to the edge of current data region CTRL+RIGHT ARROW Selection Keystrokes Select column CTRL+SPACEBAR Select hyperlink INSERT+F7 Select region CTRL+SHIFT+8 Select row SHIFT+SPACEBAR Select worksheet objects CTRL+SHIFT+O Collapse selection to current cell SHIFT+BACKSPACE Configuration Keystrokes Set monitor cell INSERT+SHIFT+1 through 0 Read monitor cell ALT+SHIFT+1 through 0 Formula input mode = (EQUALS) AutoFilter CTRL+SHIFT+A AutoSum ALT+EQUALS Date stamp CTRL+; (SEMICOLON) Time stamp CTRL+SHIFT+; (SEMICOLON) Close Office Assistant CTRL+INSERT+F4 Command Descriptions for Excel Auto Filter Use CTRL+SHIFT+A. Activates the auto filter for selected cells. The cursor is placed in a list box from which All, Top 10, or Custom options can be selected. Auto Sum Use ALT+EQUALS. Automatically adds a group of user-defined cells. It puts you in an edit mode in a particular cell where you can define the cells to be summed. Close Office Assistant Use CTRL+INSERT+F4. Closes the Office Assistant. Collapse Selection to Active Cell Use SHIFT+BACKSPACE. Minimizes the highlighted area of the current selection down to the active cell. Column First Cell From Top Use ALT+1. Reads the first cell in the current column. Note: In Excel 95 this command and the next three listed here seems to occasionally count the column header as a cell, so it is always one cell off. This does not occur in Excel 97 or later. Column Second Cell From Top Use ALT+2. Reads the second cell in the current column. Column Third Cell From Top Use ALT+3. Reads the third cell in the current column. Column Fourth Cell From Top Use ALT+4. Reads the fourth cell in the current column. Data Region Down Use CTRL+DOWN ARROW. Moves down to the edge of the current data region. This keystroke moves the cursor to the last cell in the current data region. If you are already on the last cell, it moves the cursor to the first cell of the next data region. Blocks of empty cells can define a data region. Data Region Left Use CTRL+LEFT ARROW. Moves left to the edge of the current data region. This keystroke moves the cursor to the first cell in the current data region. If you are already on the first cell, it moves the cursor to the last cell of the previous data region. Blocks of empty cells can define a data region. Data Region Right Use CTRL+RIGHT ARROW. Move right to the edge of the current data region. This keystroke moves the cursor to the last cell in the current data region. If you are already on the last cell, it moves the cursor to the first cell of the next data region. Blocks of empty cells can define a data region. Data Region Up Use CTRL+UP ARROW. Moves up to the edge of the current data region. This keystroke moves the cursor to the first cell in the current data region. If you are already on the first cell, it moves the cursor to the last cell of the previous data region. Blocks of empty cells can define a data region. Date Stamp Use CTRL+SEMICOLON. Puts the date in the current cell. Describe Cell Border Use ALT+SHIFT+B. Reads and describes the border around the active cell. The description includes the line style and weight of the top, right, bottom and left borders. If all borders are the same, JAWS announces "surrounding border" rather than the individual border names. Display Detailed Cell Appearance Information Use INSERT+TAB twice quickly. Displays detailed information regarding the visual appearance of the current cell in the Virtual Viewer. Formula Mode Use EQUALS. Activates the formula input mode. You can use this keystroke to type a formula in the current cell location. List Cells At Page Break Use CTRL+SHIFT+B. Locates cells that mark vertical or horizontal page break boundaries. List Cells With Comments Use CTRL+SHIFT+APOSTROPHE. Lists all of the cells in the visible window that have an attached comment. This allows you to quickly locate any visible cells that may provide important information about the spreadsheet. List Column Use CTRL+SHIFT+C. Lists the cells in the current column that contain data. This allows you to set focus on the selected cell. List Row Use CTRL+SHIFT+R. Lists the cells in the current row that contain data. This allows you to set focus on the selected cell. List Visible Cells With Data Use CTRL+SHIFT+D. Lists only the cells with data, which are visible on the screen. This enables you to quickly access relevant cells that are visible on the current screen, skipping blank cells. Move To Monitor Cell Use CTRL+SHIFT+M. Lists the defined monitor cells for the current sheet and moves directly to the selected cell. Move To Worksheet Use CTRL+SHIFT+S. Lists the worksheets in the current workbook and allows you to quickly set focus on the first cell in the selected worksheet. Next Sheet Use CTRL+PAGE DOWN. Moves the focus to the next spreadsheet. Prior Sheet Use CTRL+PAGE UP. Moves the focus to the prior spreadsheet. Read Cell Comment Use ALT+SHIFT+APOSTROPHE. Reads a cell comment if there is one. Read Cell Hyperlink Use ALT+SHIFT+H. Reads a hyperlink associated with the selected cell. Read Column Total Use INSERT+NUM PAD ENTER. To define the column containing totals, press CTRL+INSERT+NUM PAD ENTER. Read Row Total Use INSERT+DELETE. Automatically reads the current row total. To define the row containing totals, press CTRL+INSERT+NUM PAD DELETE. Read Monitor Cell Use ALT+SHIFT+1 through 0. Reads the monitor cell. Use ALT+SHIFT+1 to read the first monitor cell. Report Gridline Status Use ALT+SHIFT+G. Announces whether or not gridlines are enabled on the active spreadsheet. Row First Cell From Left Use ALT+CTRL+1. Reads the first cell in the current row. Row Second Cell From Left Use ALT+CTRL+2. Reads the second cell in the current row. Row Third Cell From Left Use ALT+CTRL+3. Reads the third cell in the current row. Row Fourth Cell From Left Use ALT+CTRL+4. Reads the fourth cell in the current row. Say Active Cell Coordinates Use INSERT+C. Announces the coordinates of the active cell. Press INSERT+C twice quickly to spell out the coordinates. Press INSERT+C three times quickly to hear the coordinates of the active cell announced phonetically. Say last cell navigated to when creating a formula Use CTRL+NUM PAD 5. Announces the coordinates of the last cell you navigated to when you are creating a formula. Say Column Title Use ALT+SHIFT+C. Announces the column title of the active column. Say Excel Version Use CTRL+INSERT+V. Announces the Excel version. Say Focus Rectangle Use INSERT+N. Announces the contents of the focus rectangle. Say Font Use INSERT+F. Announces cell's font among other attributes, including horizontal and vertical alignment, as well as its width and height. Say Formula Use CTRL+F2. Reads the formula that is in the current cell. If the keystroke is pressed twice quickly, the formula is displayed in a message box so that you can easily review it with the JAWS cursor. Say Row Title Use ALT+SHIFT+R. Announces the title of the row. Say Visible Range Coordinates Use ALT+SHIFT+V. Announces the range of cells visible in the active window. For example, A1 to J17, and so on. Screen Left Use ALT+PAGE UP. Moves focus to the prior screen in this spreadsheet. Screen Right Use ALT+PAGE DOWN. Moves focus to the next screen in this spreadsheet. Select Column Use CTRL+SPACEBAR. Selects the entire column of an active cell. Select Hyperlink Use INSERT+F7. Assembles hyperlinks on an active spreadsheet into a list. This allows you to select the desired link to a target document. Select Region Use CTRL+SHIFT+8. Selects the current region. Select Row Use SHIFT+SPACEBAR. Selects the entire row of the active cell. Select Worksheet Objects Use CTRL+SHIFT+O. Selects and activates objects in the drawing layer of the spreadsheet. These objects can be auto shapes, form controls, OLE objects, and so on. This keystroke displays a list of the shapes on the active worksheet and allows a shape to be selected (given focus and activated). Currently only shapes whose OnAction property contains the name of a valid macro can be activated. Set Column Titles To Row Use ALT+CTRL+SHIFT+C. Defines the current row as the row containing column titles. Set Row Titles To Column Use ALT+CTRL+SHIFT+R. Defines the current column as the column containing row titles. Set Total Column To Current Use CTRL+INSERT+ENTER. Sets the current column as the column containing row totals. Set Total Row To Current Use CTRL+INSERT+DELETE. Sets the current row as the row containing column totals. Set Monitor Cell Use INSERT+SHIFT+1 through 0. Sets the monitoring on different cells. Use INSERT+SHIFT+1 for the first cell that you are monitoring. Spell Check Use INSERT+F7. Reads the spelling error and suggested replacement word using Spell Checker. Time Stamp Use CTRL+SHIFT+SEMICOLON. Announces the time and inserts it into the active current field. Excel Getting Started There are no special installation or setup requirements to run this product with JAWS. Simply start the program using normal procedures. Refer to the product's online help system as required, using ALT+H to select the software's built in help topics. If you need assistance with JAWS commands or want to know what new features have been added that JAWS supports, use INSERT+F1+F1. Excel Helpful Hints Excel Row and Column Title Reading Monitor Cells in Excel Region Specific Excel Settings Creating a Custom Summary in Excel Saving JAWS Excel Settings Excel Braille Modes Reading Excel Charts Miscellaneous Excel Hints 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: 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. 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: 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. 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: . 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. 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. 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 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. Monitor Cells in Excel Ten monitor cells can be set per worksheet. These monitor cells are remembered as you move in and out of the worksheet. You can actually monitor a range of cells as well. Select the range of cells before assigning the monitor keystroke, and then when the monitor keystroke for that cell is pressed, JAWS reads the range of cells. Use INSERT+SHIFT+1 through 0 to set the monitor cells. You can also use the Adjust JAWS Verbosity dialog to set the next available monitor cell to the current cell. To read the monitor cells use ALT+SHIFT+1 through 0. When reading monitor cells, JAWS also reads the cell's coordinates. In addition, JAWS announces the title of the cell if you have selected the corresponding Title Reading option in the Excel verbosity options. Tip: If you do not want JAWS to announce the titles of monitor cells, press INSERT+V, select "Announce Monitor Cell Titles," and press the SPACEBAR to choose "Off." List the monitored cells by pressing CTRL+SHIFT+M. The coordinates and contents of each defined monitor cell are listed in the dialog. If the monitor cell is a range, then the coordinates of the range are displayed. You can choose to move to the monitor cell from this dialog. Another Verbosity item is now available to delete all monitor cells for the current worksheet. When you select this option using the arrow keys, JAWS announces the number of monitor cells currently assigned to the active worksheet. Return to Previous Cell from Monitor Cell After you use CTRL+SHIFT+M to move to a monitor cell, you can now easily move back to your position immediately before you moved to the monitor cell with CTRL+SHIFT+GRAVE. Region Specific Excel Settings Title and total reading can be set on a region-by-region basis, and JAWS automatically uses the settings as you move into the relevant region. JAWS also tells you when you move into a new region. Now you can have adjacent tables on the same worksheet. By default, single region support is enabled. To enable multiple region support, press INSERT+V to open the Adjust JAWS Verbosity dialog, move to Region, and press SPACEBAR to toggle the setting. Note: When using single region support, the entire worksheet is treated as one region for title and total reading. There are two ways to define a region: . Define a range of cells as a region . Use Excel's default definition of a region Defining a Region To define a region within Excel: 1. Select the entire scope of the cells you want included in the region. 2. Select Insert, Name, Define. 3. Type in a name for the region and press ENTER. The advantage to naming your own region is to include blank rows and columns. JAWS stores the region names in a *.jsi file. Excel's Default Definition of a Region By default, Excel defines a region as a group of contiguous cells containing data. The edges of the region are determined by a surrounding row and column of empty cells. This means a default Excel region cannot contain a row or column of blank cells. JAWS looks only in the current region to calculate row or column totals. If you request a row or column total and there is an adjacent table, JAWS finds the accurate total. Limitations of Multiple Region Support Multiple region support is designed to enhance the functionality of row and column title reading as well as row and column total reading. It is not designed to support all JAWS Excel commands. Many JAWS Excel commands do not recognize multiple regions. Some of these commands are: . List Cells in Current Column (CTRL+SHIFT+C) . List Cells in Current Row (CTRL+SHIFT+R) . Lists cells at page break (CTRL+SHIFT+B) . List cells with comments (CTRL+SHIFT+APOSTROPHE) . List Visible cells with data (CTRL+SHIFT+D) There are also a few other commands that do not apply to multiple region support as they do not list information from spreadsheet cells, such as the List Worksheets command (CTRL+SHIFT+S). Creating a Custom Summary in Excel The Custom Summary feature allows you to create a snapshot of important data from a worksheet, such as monthly totals, grand totals, and so on. You define which cells appear in the custom summary by assigning labels to them. The summary then displays the contents of all the specified cells. The summary contains links, allowing you to move quickly to any of the cells. If the worksheet's data changes after the custom summary is created, the same summary can be used to obtain the new information. Tip: When the focus moves to a worksheet with a custom summary, JAWS indicates that a summary is available. To create a custom summary, you must assign custom summary labels to each cell or range of cells that you want to include. Do the following to assign labels to cells in the current worksheet: 1. Select the cell or range of cells that you want to include in the summary. 2. Press INSERT+F2, select "Custom Summary Labels," and press ENTER. Alternatively, you can press CTRL+INSERT+TAB. The dialog box that appears allows you to add, change, delete, and reorder custom summary labels. 3. Choose the Add button. 4. Type the text you want to use for the label and press ENTER. 5. If you want to change or delete any label you have created, select it in the list and choose either the Change or Remove button. If you want to delete all the labels you have created, choose the Remove All button. When you are satisfied with the name and position of the label, choose the OK button. Tip: The order of the labels in the list determines the order in which they appear when you view the custom summary. To change the position of a label, select it from the list and then use the Move Up and Move Down buttons. 6. Repeat steps 1 through 5 until you have labeled all cells that you want to include in the summary. When you are finished assigning labels, you can view your custom summary. Changing or Deleting a Custom Summary Label To change or delete a custom summary label, select the cell or range of cells the label is assigned to and press CTRL+INSERT+TAB. To change the name of the label, choose the Change button. Then, type some new text for the custom label and press ENTER. To delete the label, choose the Remove button. To remove all custom summary labels in the current worksheet, press INSERT+F2 while in any cell that does not have a custom summary label. Then, select "Custom Summary Labels" and choose Remove All. Viewing the Custom Summary Once you have assigned labels to all the cells you want to include in the summary, you are ready to view the custom summary. Press INSERT+F2, select "View Custom Summary," and press ENTER. The name of each cell that you labeled appears, along with its contents. Alternatively, you can press CTRL+INSERT+SHIFT+TAB to view the summary at any time. JAWS displays summary information for all worksheets that have custom summary labels assigned. Each item in the summary has a link that you can activate by pressing ENTER. Activating the link moves you to the location of that cell in the worksheet. If the label is assigned to a range of cells, JAWS moves you to the first cell in the range. Tip: You can press INSERT+F7 while the custom summary is displayed to view a list of all links in the summary. Saving JAWS Excel Settings JAWS remembers your Verbosity settings for all Microsoft Excel specific Verbosity settings across sessions. Excel specific verbosity settings include: cell reading, selection reading, detect cell number format change, and detect cell border change. Workbook Settings Workbook Settings in the Adjust JAWS Verbosity dialog contains three settings: Exact Match, Best Match, and New JSI File. Workbook Settings determine what settings to use to read a particular workbook. If you often receive workbooks that contain similar setups, for instance, if you receive a workbook every month for which you can use the same title, total, and monitor settings, you would not want to have to set these features for every new workbook. Now with JAWS Workbook Settings, if you choose Best Match, JAWS determines which of your settings files best matches the current workbook, and automatically loads these settings. Note: If you change Verbosity settings while Best Match is selected, the changes are saved to the JSI file specified under Workbook Settings, Best Match. If you only want settings to load if they are designed for a particular workbook, choose Exact Match. If you need to modify Verbosity settings for a workbook that uses Best Match settings, but need to keep the specified JSI file unchanged for use with other files, select New JSI File, press ENTER to exit the Verbosity dialog, and then reopen the Verbosity dialog and make your changes. Workbook Settings will be set to Exact Match, with a JSI file specified for the current workbook. Excel Braille Modes Use the Braille Mode Verbosity option when you use Structured Mode for your Braille display. With the Braille Mode Verbosity option, you may choose between three different Structured Modes while navigating an Excel spreadsheet. Cell View is the classical view, which shows the active cells' coordinates, column and row titles where appropriate, cell content, cell formula, cell comment, cell hyperlink address, row total, monitor cells, etc. Row Mode shows up to 9 cells surrounding the active cell in the current row. Blank cells are shown with a minus (dots 3-6). The active cell is always the middle piece of data unless you are at the beginning or end of the row, where it is then the first or last piece of data shown. The coordinates of the active cell are always shown immediately before the active cell contents so it is easy to locate the focus on the display. Column View shows up to 9 cells surrounding the active cell in the current column. The active cell is the middle piece of data, unless you are at the beginning or end of a column, and then the active cell is the first or last piece of data shown. Blank cells are indicated with a minus sign (dots 3-6). The coordinates of the active cell always precede the active cell so it is easy to locate the focus on the display. Note: When you press F2 to edit a cell's contents, Line Mode is activated, so the caret is tracked while you edit. Reading Excel Charts Once a chart in Excel gains focus, JAWS reads it using the Virtual Cursor. You may navigate the same as you would on a web page in Internet Explorer. Once you finish using the Virtual Cursor, press ESC to return to the worksheet. If you try to use the Select Worksheet Objects function when a chart is already active, a bug in Excel prevents another object from being selected. You must first press ESC to deactivate the chart before trying to select another chart. JAWS now recognizes and speaks the types and titles of all 14 chart types and 73 subtypes, though detailed descriptions are only available for line, bar, column, cylinder, pyramid, cone, pie, doughnut and xy-scatter charts and for their subtypes. Note: Trend lines are not yet described. Chart descriptions are spoken when a chart has focus and you press INSERT+F1. An Example Of a Chart Description: . Chart type. . Chart title. . Axes titles. . Number of series. Each series is described, beginning with its legend, followed by the number of points in the series. The point number, data label (if it has one), category name, and value describe each point. When charts are described for which percentage contributions are not spoken, and if there are several contiguous categories with the same value, rather than announcing each identical point or bar, JAWS collects the items and speaks the range. Miscellaneous Excel Hints . The JAWS keystroke INSERT+F identifies four kinds of underline styles instead of just stating if underlining is on or off. . INSERT+5 and INSERT+F (when the color has been changed from the default) correctly identify the cell's text color. . JAWS automatically selects a file listed in the Open or Save As list views when JAWS is set at Beginner Verbosity. . Screen Sensitive Help in the worksheet states the number of worksheets in the current workbook. CTRL+PAGE UP or CTRL+PAGE DOWN and CTRL+SHIFT+S can be used to move between other sheets. Cell Appearance Information You can now press INSERT+TAB twice while in a cell to display detailed information regarding the visual appearance of that cell in the virtual viewer. JAWS displays the width of the column, whether the text is entirely visible, the height of the cell if greater than one line, whether the text has been shrunk or rotated, the cell's vertical and horizontal alignment, font information, the presence of any inverted negative numbers and their color, the indentation level, and the number format. Creating Formulas When you create a formula in Excel, you can navigate to and select a cell or range of cells in another workbook or worksheet in order to use that data as part of the formula. When you create a formula this way, JAWS makes it easier to navigate to the cells containing the data you want to include by announcing the name of the active worksheet/workbook. To begin creating a formula, type an equal sign (=) in a cell. Then, switch to the worksheet/workbook containing the data you want to use in your formula. Select the cell or range of cells you want to reference and press ENTER. If necessary, you can press CTRL+NUM PAD 5 to hear the coordinates of the last cell you navigated to. Excel creates the formula and the focus returns to the cell (and workbook/worksheet) containing the new formula. At any time, you can press INSERT+TAB or INSERT+C to hear the name and worksheet of the cell where the formula is being created. Similarly, you can use the Say Line command (INSERT+UP ARROW) at any time to read the formula. If you want to cancel the formula and return to that cell in the workbook/worksheet, press ESC. Beginner Verbosity When you navigate a spreadsheet at the Beginner verbosity level, JAWS announces "has comment" if a cell has an attached comment, "has formula" if a cell contains a formula, and "has hyperlink" if the cell has an associated hyperlink. Maximum Number of Rows The maximum number of rows in a column is 65536, but JAWS only looks at the first 256 when listing cells with data in the current column (CTRL+SHIFT+C) If you would like JAWS to search more rows for data, change the maximum allowable rows to search by reassigning the constant called MaxRowsToSearch in the excel.jsh file. Please note that this constant cannot be more than the maximum allowable integer value permitted by JAWS script language. Position Information Position Information is a Verbosity Option set in the JAWS Configuration Manager. At the Advanced level it is typically turned off. For Excel this setting is turned on. Position Information is useful when working in tables. When your cursor moves to a new row or column you are informed. To turn this feature off, activate the JAWS Configuration Manager while working in Excel. Select Verbosity Options from the Set Options menu. Press the TAB key to move to the Advanced Preferences button. Press ENTER on that button, and you can check or uncheck any of these checkboxes, including the one for Position Information. Merged Cells In Excel, you can merge two or more cells into a single cell. When you select a merged cell, JAWS announces the range of the cells included in the merger. For example, if you merge cells A1, B1, and C1, JAWS says, "A1 through C1" when you select the cell.
- RE: Advanced Excel Tutorial with JAWS
- From: Wade Hemmelrick
- RE: Advanced Excel Tutorial with JAWS