Nice find!!! Annette
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Patricia Sent: Tuesday, February 27, 2007 4:11 PM To: jaws help Subject: [JAWS-Users] Excel Help I found this at JFWlite under hints/tricks.. Creating Charts with Excel and JFW Here is an example. say you're in excel and in column A, you have the names of sales reps going from A1 down to A10. then in column B, you have the amount each has sold that month. So, you have two lots of data, sales rep name and their sales. go to the bottom cell,B10 and highlight up to the top using control shift and up after you have located yourself in B10. Now go to the insert menu and arrow down until you hear chart. Enter here and the chart wizard will start up. This is a four step wizard. let's say your boss wants a pie chart. In step one you are given a whole load of chart types you can choose from. go to Pie and enter. the second step of the wizard will then start and give you the co- ordinates,cells, you have selected. you keep pressing next button. on the third step, you will be asked if you wish to assign label and following the steps within this step this is tricky but becomes easier with practice. The fourth step asks if you want to put the chart in the sheet or to a separate document, this is up to you but I normally go for a separate document as you can then copy and paste into a word document and place text above or below the chart. You then click finish, and hey presto, a pie chart. Or indeed, any other type of chart you want. If you are using a colour printer, the charts appear in colour, if not they will be printed in various shades of grey. Also, while still in excel you can go to the view menu and into Zoom, to make the chart appear much larger on the printed sheet. Some Windows Shortcuts for Excel File Management New Ctrl-N Open Ctrl-O Print Ctrl-P Save Ctrl-S Save As F12 Editing Undo Ctrl-Z Repeat last command F4 Copy Ctrl-C Cut Ctrl-X Paste Ctrl-V Find Ctrl-F Replace Ctrl-H Goto F5 Insert blank cell Ctrl-Shift-+ Delete cell selection Ctrl-Minus sign Edit cell note Shift-F2 moving Move down to next page of data Page Down Move up to previous page of data Page Up Move across to next page of data Alt-Page Down Move across to previous page of data Alt-Page Up Go to next worksheet Ctrl-Page Down Go to previous worksheet Ctrl-Page Up Move up through a selection Shift-Enter Move right through a selection Tab Move left through a selection Shift-Tab Formatting Annotate a cell Shift-F2 Format selected element Ctrl-1 Check spelling F7 Create chart F11 (or Alt-F1) Enter date Ctrl-; Enter time Ctrl-: Scroll between relative, absolute, and mixed references - F4 Selecting Ranges All cells with notes Ctrl-Shift-? Rectangular range of cells around active cell Ctrl-* Cells with formulas that refer directly to active cell Ctrl-] All cells within formulas that refer to active cell Ctrl-Shift-{ Only visible cells in current selection Alt-; Data Formatting Apply general number format Ctrl-Shift-~ Format as currency Ctrl-Shift-$ Apply percentage format Ctrl-Shift-% Apply exponential number format Ctrl-Shift-^ Format number as date Ctrl-Shift-# Format number as time Ctrl-Shift-@ Apply two-decimal place format Ctrl-Shift-! Apply outline border Ctrl-Shift-& Remove all borders Ctrl-Shift-_ Hide rows Ctrl-9 Unhide rows Ctrl-Shift-( Hide columns Ctrl-0 Unhide columns Ctrl-Shift-) Jaws Keystrokes Excel DESCRIPTION KEYSTROKE Informational Keystrokes for Columns Read first cell in column ALT+1 Read second cell in column ALT+2 Read third cell in column ALT+3 Read fourth cell in column ALT+4 List cells in current column CTRL+SHIFT+C Read column total INSERT+NUM PAD ENTER Say column title ALT+SHIFT+C Informational Keystrokes for Rows Read first cell in row ALT+CTRL+1 Read second cell in row ALT+CTRL+2 Read third cell in row ALT+CTRL+3 Read fourth cell in row ALT+CTRL+4 List cells in current row CTRL+SHIFT+R Read row total INSERT+DELETE Say row title ALT+SHIFT+R 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 cells with data visible on screen 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+A Report gridline status ALT+SHIFT+G Say active cell coordinates INSERT+C Say excel version (Excel 95 only) CTRL+SHIFT+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 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 CTRL+SHIFT+H Select region CTRL+SHIFT+8 Select row SHIFT+SPACEBAR Select worksheet objects CTRL+SHIFT+O Collapse selection to current cell SHIFT+BACKSPACE Configuration Keystrokes Read monitor cell ALT+SHIFT+1 THROUGH 0 Set monitor cell ALT+CTRL+SHIFT+1 THROUGH 0 Clear definitions of monitor cells CTRL+SHIFT+DELETE 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 link Detailed Descriptions of Keystrokes --~--~---------~--~----~------------~-------~--~----~ Visit the JAWS Users List home page at: http://www.jaws-users.com Address for the list archives: http://www.mail-archive.com/jaws-users-list%40googlegroups.com/ In order to contact the management team simply fill out the following form found at: http://www.jaws-users.com/contact.php You received this message because you are subscribed to the Google Groups "JAWS Users List" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/jaws-users-list?hl=en -~----------~----~----~----~------~----~------~--~---
