I'm pasting it here. I hope this works. Annette
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. JAWS What's New in 7.0 Microsoft Excel Create Custom Summaries 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. Use CTRL+INSERT+TAB to assign a label to the current cell. Once you have assigned labels to all cells you want to include in the summary, you press CTRL+INSERT+SHIFT+TAB to view the summary. JAWS displays summary information for all worksheets that have custom summary labels assigned. For more information on using this feature, see Creating a Custom Summary in Excel. Tip: The DAISY training material that can be installed from the JAWS 7.0 program CD includes a lesson on creating custom summaries in Excel. To listen to this DAISY book, open the JAWS Help menu and choose Training. Then, select the book "XTraCustomLabelSummaryExcel" and press ENTER. Easy Creation of Excel Formulas that Reference Different Workbooks or Worksheets 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 now makes it easier to navigate to the cells containing the data you want to include by announcing the name of the active worksheet/workbook. In addition, you can now press CTRL+NUM PAD 5 when creating a formula to hear the coordinates of the last cell you navigated to. For more information on creating formulas in Excel, see Miscellaneous Excel Hints. Define Row and Column Titles for Worksheets with Multiple Regions The ability to use names in Excel to define row and column titles has been extended to worksheets that have multiple regions. You can now use names to define unique row and column titles for each region on your spreadsheet. For more information on using names to define row and column titles, including the special naming convention that you need to use for regions, see Excel Row and Column Title Reading. In addition, JAWS can now detect if the active worksheet contains multiple regions. If it does, then multiple region support is automatically enabled in the Excel verbosity options. Tip: The DAISY training material that can be installed from the JAWS 7.0 program CD includes a lesson on using names to define row and column titles in Excel. To listen to this DAISY book, open the JAWS Help menu and choose Training. Then, select the book "XTraNewPortableRowAndColumnTitlesInExcel" and press ENTER. New Keystroke for Setting Monitor Cells The keystroke for setting monitor cells in Excel has been changed from ALT+CTRL+SHIFT+1 through 0 to INSERT+SHIFT+1 through 0. This keystroke is easier for most users to press. New Keystroke for Selecting a Hyperlink in Excel The keystroke for selecting a hyperlink in Excel has been changed from CTRL+SHIFT+H to INSERT+F7. This change makes the keystroke for this command consistent for all Microsoft Office programs. Phonetic Cell Coordinates in Excel You can now press INSERT+C three times to hear the coordinates of the active cell announced phonetically. More Information About Input Messages Input messages can be used to create forms in Excel. When you move to a cell with an input message, JAWS now announces the following information: List of 4 items . The type of input (drop-down, date, time, and so on). . Any restrictions relating to the input that is expected (for example, time input between 9:00 AM and 5:00 PM). . Tutor help appropriate to the type of input expected. . Appropriate screen-sensitive help for the type of input expected. list end JAWS also provides this information in Braille, if you have a Braille display. Review Detailed Information About Cell Appearance 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, 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. More Information when Selecting Cells When you select cells with Excel's selection commands, JAWS now indicates the range of cells that you have selected. For example, if you are in cell A1 and then select cells B1 and C1 with SHIFT+RIGHT ARROW, JAWS says "Select C1. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Sarah Sent: Wednesday, August 09, 2006 11:46 PM To: [email protected] Subject: Re: *****SPAM***** Re: [jaws-users] excel question The atachment has ben stripped on my end. TC. ----- Original Message ----- From: Annette Carr To: [email protected] Sent: Wednesday, August 09, 2006 6:29 PM Subject: RE: *****SPAM***** Re: [jaws-users] excel question Hi Cathie and List, At this point I have only played with the 3-D reference feature slightly since this morning. I have read through the JAWS 7.0 Help info and found some helpful info. I've copied that info and pasted it into a Word document and have attached it here. If I had some more time to play, I would have written up additional information. But in the meantime, I hope this helps. Annette -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Cathie J Sent: Tuesday, August 08, 2006 5:56 PM To: [email protected] Subject: *****SPAM***** Re: [jaws-users] excel question I have excel & know how to do some formulas in a sheet, but am wanting to compile and track purchases in a workbook. I'm not sure how to link up details on one page and have totals on second page. Cathie ----- Original Message ----- From: "Christine Chaikin" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, August 07, 2006 4:18 PM Subject: Re: [jaws-users] excel question Aloha Cathy, Do you have Excel? If so, you can go to the Microsoft website template website and type the type of template you want and then download it to your computer and customize it in Excel the way you want it. Another one that you might want to try is Microsoft Access and do the same thing that I have mentioned above. Hope the above info helps. ----- Original Message ----- From: "Cathie J" <[EMAIL PROTECTED]> To: "jaws-users" <[email protected]> Sent: Monday, August 07, 2006 12:51 PM Subject: [jaws-users] excel question > Hi, I'm looking for advise to set up a detailed expense sheet with a > second > sheet that trackes totals for items like groceries, utilities, etc. > Thanks for suggestions. > Cathie > [EMAIL PROTECTED] > > > > Visit the JAWS Users list home page at: > http://www.jaws-users.com > > For a complete list of email commands pertaining to the JAWS Users List > send a blank email to: > [EMAIL PROTECTED] > > Visit the new archives page at the following address > http://www.mail-archive.com/[email protected]/ > Yahoo! Groups Links > > > > > Visit the JAWS Users list home page at: http://www.jaws-users.com For a complete list of email commands pertaining to the JAWS Users List send a blank email to: [EMAIL PROTECTED] Visit the new archives page at the following address http://www.mail-archive.com/[email protected]/ Yahoo! Groups Links Visit the JAWS Users list home page at: http://www.jaws-users.com For a complete list of email commands pertaining to the JAWS Users List send a blank email to: [EMAIL PROTECTED] Visit the new archives page at the following address http://www.mail-archive.com/[email protected]/ Yahoo! Groups Links [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] Visit the JAWS Users list home page at: http://www.jaws-users.com For a complete list of email commands pertaining to the JAWS Users List send a blank email to: [EMAIL PROTECTED] Visit the new archives page at the following address http://www.mail-archive.com/[email protected]/ Yahoo! Groups Links Visit the JAWS Users list home page at: http://www.jaws-users.com For a complete list of email commands pertaining to the JAWS Users List send a blank email to: [EMAIL PROTECTED] Visit the new archives page at the following address http://www.mail-archive.com/[email protected]/ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/jaws-users/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
