Microsoft Excel: 100+ Shortcut Keys: It’s a fact that shortcuts help us make our lives more efficient. If you’re a Microsoft Excel user, you could refer to this article to discover some of the most popular shortcuts. You may be amazed to discover the myriad of Excel shortcuts available as well, and although we don’t expect you to memorize every single one, however, it’s always beneficial to keep a list of them that is only a few clicks away. Check out the following article, as we present a list of the most essential Microsoft Excel shortcuts for Windows to help you work more efficiently.
Microsoft Excel Shortcut Keys
Ms Excel Shortcut Keys
Before you begin, be aware this list of shortcuts is lengthy, but it’s not a complete list of all Excel shortcuts. We have chosen a few of the most effective shortcuts and we hope that this will be worthwhile to you.
Ctrl+ Shortcut Keys Of Ms Excel
Ms Excel Shortcut keys
Action
Ctrl+A
Select All
Ctrl+B
Bold
Ctrl+c
Copy
Ctrl+D
Fill Down
Ctrl+F
Find
Ctrl+G
Goto
Ctrl+H
Replace
Ctrl+K
Insert Hyperlink
Ctrl+N
New Workbook (create a new workbook.)
Ctrl+O
Open (open a saved workbook.)
Ctrl+P
Print
Ctrl+I
Italic
Ctrl+R
Fill Right
Ctrl+S
Save
Ctrl+U
underline highlighted cells
Ctrl+V
Paste (paste anything that was copied)
Ctrl+W
Close
Ctrl+X
Cut
Ctrl+Y
Redo/ Repeat
Ctrl+Z
Undo
Ctrl+:
Insert Current Time
Ctrl+;
Insert Current Date
Ctrl+”
Copy Value from Cell Above
Ctrl+’
Copy Fromula from Cell Above
Tab
Next tool
Enter
Do the command
Ms Excel Function Shortcut Keys
Ms Excel Shortcut keys
Action
F1
Help (open Microsoft Excel help)
F2
Edit
F3
Paste Name
F4
While typing formulas OR witch between absolute/relative refs
F4
Repeat last action (Works while not in Edit mode)
F5
Goto
F6
Next Pane
F7
Spell check
F8
Extend mode
F9
Recalculate all workbooks
F10
Activate Menubar
F11
New Chart
F12
Save As
Shift+ Function Shortcut Keys
Shift+ Function Key
Action
Shift+F1
What’s This? (Help)
Shift+F2
Edit cell comment
Shift+F3
Paste function into formula / open the Insert function dialog box
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
Shift+Ctrl+F6
Previous workbook window
Shift+Ctrl+Tab
In toolbar: previous toolbar
Shift+Ctrl+Tab
In a workbook: activate the previous workbook
Shift+Tab
Previous tool
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
Ctrl+ Function Shortcut Keys
Ctrl+F3
Define name
Ctrl + F1
Expand or Collapse the Ribbon.
Ctrl + F2
Open the print preview window
Ctrl+F4
Close
Ctrl+F5
Restore window size
Ctrl+F6
Next 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
Ctrl+Shift+F3
Create name by using names of row and column labels