your welcome and good luck ----- Original Message ----- From: "Charlene Y" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, February 27, 2007 3:21 PM Subject: [JAWS-Users] Re: Excel Help
> > Thank you very much for your help. i will give it a try. > ----- Original Message ----- > From: "Patricia" <[EMAIL PROTECTED]> > To: "jaws help" <[email protected]> > Sent: Tuesday, February 27, 2007 3:10 PM > 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 -~----------~----~----~----~------~----~------~--~---
