Microsoft Excel Shortcut Keys
| Shortcut | Action | Menu | |
|---|---|---|---|
| Ctrl+A | Select All |
None
| |
| Ctrl+B | Bold | Format Cells Font Font Style Bold | |
| Ctrl+C | Copy | Edit Copy | |
| Ctrl+D | Fill Down | Edit Fill Down | |
| Ctrl+F |
Find
| Edit Find | |
| Ctrl+G |
Goto
| Edit Goto | |
| Ctrl+H |
Replace
| Edit Replace | |
| Ctrl+I |
Italic
| Format Cells Font Font Style Italic | |
| Ctrl+K |
Insert Hyperlink
| Insert Hyperlink | |
| Ctrl+N |
New Workbook
| File New | |
| Ctrl+O |
Open
| File Open | |
| Ctrl+P |
Print
| File Print | |
| Ctrl+R |
Fill Right
| Edit Fill Right | |
| Ctrl+S |
Save
| File Save | |
| Ctrl+U |
Underline
| Format Cells Font Underline Single | |
| Ctrl+V |
Paste
| Edit Paste | |
| Ctrl W |
Close
| File Close | |
| Ctrl+X |
Cut
| Edit Cut | |
| Ctrl+Y |
Repeat
| Edit Repeat | |
| Ctrl+Z |
Undo
| Edit Undo | |
| F1 |
Help
| Help Contents and Index | |
| F2 |
Edit
| None | |
| F3 |
Paste Name
| Insert Name Paste | |
| F4 |
Repeat last action
| Edit Repeat. Works while not in Edit mode. | |
| F4 |
While typing a formula switch between absolute/relative refs
| None | |
| F5 |
Goto
| Edit Goto | |
| F6 |
Next Pane
| None | |
| F7 |
Spell check
| Tools Spelling | |
| F8 |
Extend mode
| None | |
| F9 |
Recalculate all workbooks
| Tools Options Calculation Calc,Now | |
| F10 |
Activate Menubar
| N/A | |
| F11 |
New Chart
| Insert Chart | |
| F12 |
Save As
| File Save As | |
| Ctrl+: |
Insert Current Time
| None | |
| Ctrl+; |
Insert Current Date
| None | |
| Ctrl+" |
Copy Value from Cell Above
| Edit Paste Special Value | |
| Ctrl+' |
Copy Fromula from Cell Above
| Edit Copy | |
| Shift |
Hold down shift for additional functions in Excel's menu
| none | |
| Shift+F1 |
What's This?
| Help What's This? | |
| Shift+F2 |
Edit cell comment
| Insert Edit Comments | |
| Shift+F3 |
Paste function into formula
| Insert Function | |
| Shift+F4 |
Find Next
| Edit Find Find Next | |
| Shift+F5 |
Find
| Edit Find Find Next | |
| Shift+F6 |
Previous Pane
| None | |
| Shift+F8 |
Add to selection
| None | |
| Shift+F9 |
Calculate active worksheet
| Calc Sheet | |
| Shift+F10 |
Display shortcut menu
| None | |
| Shift+F11 |
New worksheet
| Insert Worksheet | |
| Shift+F12 |
Save
| File Save | |
| Ctrl+F3 |
Define name
| Insert Names Define | |
| Ctrl+F4 |
Close
| File Close | |
| Ctrl+F5 |
XL Restore window size
| Restore | |
| Ctrl+F6 |
Next workbook window
| Window ... | |
| Shift+Ctrl+F6 |
Previous workbook window
| Window ... | |
| Ctrl+F7 |
Move window
| XL Move | |
| Ctrl+F8 |
Resize window
| XL Size | |
| Ctrl+F9 |
Minimize workbook
| XL Minimize | |
| Ctrl+F10 |
Maximize or restore window
| XL Maximize | |
| Ctrl+F11 |
Inset 4.0 Macro sheet
| None in Excel 97. In versions prior to 97 - Insert Macro 4.0 Macro | |
| Ctrl+F12 |
File Open
| File Open | |
| Alt+F1 |
Insert Chart
| Insert Chart... | |
| Alt+F2 |
Save As
| File Save As | |
| Alt+F4 |
Exit
| File Exit | |
| Alt+F8 |
Macro dialog box
| Tools Macro Macros in Excel 97 Tools Macros - in earlier versions | |
| Alt+F11 |
Visual Basic Editor
| Tools Macro Visual Basic Editor | |
| Ctrl+Shift+F3 |
Create name by using names of row and column labels
| Insert Name Create | |
| Ctrl+Shift+F6 |
Previous Window
| Window ... | |
| Ctrl+Shift+F12 |
Print
| File Print | |
| Alt+Shift+F1 |
New worksheet
| Insert Worksheet | |
| Alt+Shift+F2 |
Save
| File Save | |
| Alt+= |
AutoSum
| No direct equivalent | |
| Ctrl+` |
Toggle Value/Formula display
| Tools Options View Formulas | |
| Ctrl+Shift+A |
Insert argument names into formula
| No direct equivalent | |
| Alt+Down arrow |
Display AutoComplete list
| None | |
| Alt+' |
Format Style dialog box
| Format Style | |
| Ctrl+Shift+~ |
General format
| Format Cells Number Category General | |
| Ctrl+Shift+! |
Comma format
| Format Cells Number Category Number | |
| Ctrl+Shift+@ |
Time format
| Format Cells Number Category Time | |
| Ctrl+Shift+# |
Date format
| Format Cells Number Category Date | |
| Ctrl+Shift+$ |
Currency format
| Format Cells Number Category Currency | |
| Ctrl+Shift+% |
Percent format
| Format Cells Number Category Percentage | |
| Ctrl+Shift+^ |
Exponential format
| Format Cells Number Category, | |
| Ctrl+Shift+& |
Place outline border around selected cells
| Format Cells Border | |
| Ctrl+Shift+_ |
Remove outline border
| Format Cells Border | |
| Ctrl+Shift+* |
Select current region
| Edit Goto Special Current Region | |
| Ctrl++ |
Insert
| Insert (Rows, Columns, or Cells) Depends on selection | |
| Ctrl+- |
Delete
| Delete (Rows, Columns, or Cells) Depends on selection | |
| Ctrl+1 |
Format cells dialog box
| Format Cells | |
| Ctrl+2 |
Bold
| Format Cells Font Font Style Bold | |
| Ctrl+3 |
Italic
| Format Cells Font Font Style Italic | |
| Ctrl+4 |
Underline
| Format Cells Font Font Style Underline | |
| Ctrl+5 |
Strikethrough
| Format Cells Font Effects Strikethrough | |
| Ctrl+6 |
Show/Hide objects
| Tools Options View Objects Show All/Hide | |
| Ctrl+7 |
Show/Hide Standard toolbar
| View Toolbars Stardard | |
| Ctrl+8 |
Toggle Outline symbols
| None | |
| Ctrl+9 |
Hide rows
|
Format Row Hide
| |
| Ctrl+0 |
Hide columns
| Format Column Hide | |
| Ctrl+Shift+( |
Unhide rows
| Format Row Unhide | |
| Ctrl+Shift+) |
Unhide columns
| Format Column Unhide | |
| Alt or F10 |
Activate the menu
| None | |
| Ctrl+Tab |
In toolbar: next toolbar
| None | |
| Ctrl+Tab |
In a workbook: activate next workbook
| None | |
| Shift+Ctrl+Tab |
In toolbar: previous toolbar
| None | |
| Shift+Ctrl+Tab |
In a workbook: activate previous workbook
| None | |
| Tab |
Next tool
| None | |
| Shift+Tab |
Previous tool
| None | |
| Enter |
Do the command
| None | |
| Shift+Ctrl+F |
Font Drop Down List
| Format Cells Font | |
| Shift+Ctrl+F+F |
Font tab of Format Cell Dialog box
| Format Cells Font | |
| Shift+Ctrl+P |
Point size Drop Down List
| Format Cells Font | |
No comments:
Post a Comment