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
-~----------~----~----~----~------~----~------~--~---
