Saturday 8 October 2016

Complete List of MS Excel Shortcut Keys

Microsoft Excel Shortcut Keys

Ctrl+A
Select All
Ctrl+B
Bold
Ctrl+C
Copy
Ctrl+D
Fill Down
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


No comments:

Post a Comment