Re: EXCELL HOT KEY
- From: "Mike & Barbara In Arcadia" <mb69mach1@xxxxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Thu, 7 Oct 2010 18:04:30 -0700
Hi Cy;
Here you go.
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
----- Original Message -----
From: "Cy Selfridge" <cyselfridge@xxxxxxxxxxx>
To: <jfw@xxxxxxxxxxxxx>
Sent: Thursday, October 07, 2010 5:07 PM
Subject: EXCELL HOT KEY
Hi,
Someone posted the Microsoft hot keys for Excell.
I seemed to have lost the post so could someone email it to me?
Cyselfridge@xxxxxxxxxxx
Thanks,
Cy
--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw
Alternative archives located at:
http://n2.nabble.com/JAWS-for-Windows-f2145279.html
If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at jfw-admins@xxxxxxxxxxxxxx
Other related posts:
