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