Microsoft Excel keyboard shortcuts
General
Description | Shortcut Key |
---|---|
New file | Ctrl + N |
Open file | Ctrl + O |
Save file | Ctrl + S |
Move between open workbooks | Ctrl + F6 |
Close file | Ctrl + F4 |
Save as | F12 |
Display the print menu | Ctrl + P |
Select whole spreadsheet | Ctrl + A |
Select column | Ctrl + Space |
Select row | Shift + Space |
Undo last action | Ctrl + Z |
Redo last action | Ctrl + Y |
Start a formula | Equals Sign (eg. SUM(A1+A2) |
Exit Excel 97 | Alt + F4 |
Navigating
Description | Shortcut Key |
---|---|
Move to next cell in row | Tab |
Move to previous cell in row | Shift + Tab |
Up one screen | Page Up |
Down one screen | Page Down |
Move to next worksheet | Ctrl + Page Down |
Move to previous worksheet | Ctrl + Page Up |
Go to first cell in data region | Ctrl + Home |
Go to last cell in data region | Ctrl + End |
Formatting Text In Worksheet
Description | Shortcut Key |
---|---|
Bold toggle for selection | Ctrl + B |
Italic toggle for selection | Ctrl + I |
Underline toggle for selection | Ctrl + U |
Strikethrough for selection | Ctrl + 5 |
Change the font | Ctrl + Shift + F |
Change the font size | Ctrl + Shift + P |
Apply outline borders | Ctrl + Shift + 7 |
Remove all borders | Ctrl + Shift + Underline |
Wrap text in same cell | Alt + Enter |
Formatting Cells
Description | Shortcut Key |
---|---|
Format cells | Ctrl + 1 |
Select font | Ctrl + Shift + F |
Select point size | Ctrl + Shift + P |
Format as currency | Ctrl + Shift + 4 |
Format as general | Ctrl + Shift + # (hash sign) |
Format as percentage | Ctrl + Shift + 5 |
Format as number | Ctrl + Shift + 1 |
Editing/Deleting Text
Description | Shortcut Key |
---|---|
Delete one character to right | Delete |
Delete one character to left | Backspace |
Edit active cell | F2 |
Cancel cell entry | Escape Key |
Highlighting Cells
Description | Shortcut Key |
---|---|
Select entire worksheet | Ctrl + A |
Select entire row | Shift + Spacebar |
Select entire column | Ctrl + Spacebar |
Manual select | Hold Shift + with Left, Right, Up, Down Arrow Key |
Copying and Moving Text
Description | Shortcut Key |
---|---|
Cut | Ctrl + X |
Copy | Ctrl + C |
Paste | Ctrl + V |
Inserting Text Automatically
Description | Shortcut Key |
---|---|
Autosum a range of cells | Alt + Equals Sign |
Insert the date | Ctrl + ; (semi-colon) |
Insert the time | Ctrl + Shift + ; (semi-colon) |
Insert columns/rows | Ctrl + Shift + + (plus sign) |
Insert a new worksheet | Shift + F11 |
Misc
Description | Shortcut Key |
---|---|
Find text | Ctrl + F |
Replace text dialog | Ctrl + H |
Create a chart automatically on new sheet | F11 |
Edit a cell comment | Shift + F2 |
Main Jaws Keystrokes In Excel
Description | Shortcut Key |
---|---|
Say Version of Excel | Ctrl + Shift + V |
Move to Next Sheet | Ctrl + Page Down |
Move to Prior Sheet | Ctrl + Page Up |
Go to a cell command | Ctrl + G |
Collapse Selection To Active Cell | Shift + Backspace |
Say Active Cell Coordinates | Insert + C |
AutoSum | Alt + Equals |
Formula Mode | Equals Sign |
Insert Date In Current Cell | Ctrl + ; (semicolon) |
Insert Time In Current Cell | Ctrl + Shift + ; (semicolon) |
Current Column First Cell From Top | Alt + 1 |
Current Column Second Cell From Top | Alt + 2 |
Current Column Third Cell From Top | Alt + 3 |
Current Column Fourth Cell From Top | Alt + 4 |
Data Region Left | Ctrl + Left Arrow |
Data Region Right | Ctrl + Right Arrow |
Data Region Down | Ctrl + Down Arrow |
Data Region Up | Ctrl + Up Arrow |
Select Whole Data Region | Ctrl + Shift + 8 |
Say Formula | Ctrl + F2 |
Spell Check | F7 |
Report Gridline Status | Alt + Shift + g |
Read Row Total | Insert + Delete |
Read Column Total | Insert + Enter |
Say Column Title | Alt + Shift + C |
Say Row Title | Alt + Shift + R |
Say Visible Range Coordinates | Alt + Shift + V |
Cycle Through Controls in Dialog Box | Tab |
Tab Backwards | Shift + Tab |
List Cells With Comments | Ctrl + Shift + ' (apostrophe) |
Row Second Cell From Left | Alt + Ctrl + 2 |
Row First Cell From Left | Alt + Ctrl + 1 |
Row Third Cell From Left | Alt + Ctrl + 3 |
Row Fourth Cell From Left | Alt + Ctrl + 4 |
Describe Cell Border | Alt + Shift + B |
Read Cell Comment | Alt + Shift + ' (apostrophe) |
Auto Filter | Ctrl + Shift + A |
Read Cell Hyperlink | Alt + Shift + H |
Close Office Assistant | Ctrl + Insert + F4 |
Set Monitor Cell One | Alt + Ctrl + Shift + 1 |
Set Monitor Cell Two | Alt + Ctrl + Shift + 2 |
Set Monitor Cell Three | Alt + Ctrl + Shift + 3 |
Set Monitor Cell Four | Alt + Ctrl + Shift + 4 |
Set Monitor Cell Five | Alt + Ctrl + Shift + 5 |
Set Monitor Cell Six | Alt + Ctrl + Shift + 6 |
Set Monitor Cell Seven | Alt + Ctrl + Shift + 7 |
Set Monitor Cell Eight | Alt + Ctrl + Shift + 8 |
Set Monitor Cell Nine | Alt + Ctrl + Shift + 9 |
Set Monitor Cell 10 | Alt + Ctrl + Shift + 0 |
Read Monitor Cell One | Alt + Shift + 1 |
Read Monitor Cell Two | Alt + Shift + 2 |
Read Monitor Cell Three | Alt + Shift + 3 |
Read Monitor Cell Four | Alt + Shift + 4 |
Read Monitor Cell Five | Alt + Shift + 5 |
Read Monitor Cell Six | Alt + Shift + 6 |
Read Monitor Cell Seven | Alt + Shift + 7 |
Read Monitor Cell Eight | Alt + Shift + 8 |
Read Monitor Cell Nine | Alt + Shift + 9 |
Read Monitor Cell Ten | Alt + Shift + 0 |
List Visible Cells With Data | Ctrl + Shift + D |
Lists Data In Current Column | Ctrl + Shift + C |
List Data In Current Row | Ctrl + Shift + R |
Select Hyperlink | Ctrl + Shift + H |
Move To Worksheet Listbox | Ctrl + Shift + S |
Move To Monitor Cell | Ctrl + Shift + M |
Select Worksheet Objects | Ctrl + Shift + O |
List Cells At Page Breaks | Ctrl + Shift + B |
Options Listbox | Insert + V |
No comments:
Post a Comment