Most Important MS Excel Keyboard Shortcuts You Should Know

 

How important are excel shortcuts for you?

Do you Know using keyboard shortcut can increase your productivity and save your time? Just imagine the Ctrl + C shortcut important in your everyday work. Everyone knows few basic shortcuts but knowing more than 50+ shortcuts and using it effectively in your day-by-day work make you an expert in your work.

Even if you’re familiar with Microsoft Excel, you might be surprised by the number and variety of keyboard shortcuts you can use to speed up your work and generally make things more convenient.

 

Now, does anyone expect you to memorize all these keyboard combos? Of course not! Everyone’s needs are different, so some will be more useful to you than others. And even if you pick up a few new tricks, it’s worth it. We’ve also tried to keep the list clean and simple, so go ahead and print it that helps!

Here I have listed all important excel shortcut used by professional in latest MS OFFICE 2019 & MS OFFICE 365. Have a look.

Alt Shortcuts

AUCTION	SHORTCUT KEY
Move to Developer tab ribbon	Alt + L, use letters to navigate
Display the style dialog box	Alt + ‘
Enter the euro symbol	Alt + 0128
Enter the cent character	Alt + 0162
Enter the pound sterling character	Alt + 0163
Enter the yen symbol	Alt + 0165
Move to Data tab ribbon	Alt + A, use letters to navigate
Enter a line break within a cell	Alt + Enter
Move to File tab ribbon	Alt + F, use letters to navigate
Open the Visual Basic editor	Alt + F11
Add Border	Alt + H,B
Move to Home tab ribbon	Alt + H, use letters to navigate
Move to Formulas tab ribbon	Alt + M, use letters to navigate
Move to Insert tab ribbon	Alt + N, use letters to navigate
Move to Page Layout tab ribbon	Alt + P, use letters to navigate
Move to Review tab ribbon	Alt + R, use letters to navigate
Move to View tab ribbon	Alt + W, use letters to navigate
Move to Home tab fill colour	Alt+ H, H
Move to Home tab format	Alt+ H, O
Move to Home tab Align Left	Alt+ H, AL
Move to Home tab Align Right	Alt+ H, AR
Move to Home tab Align Centre	Alt+ H, AC
Move to Home tab percentage format	Alt+ H, P
Move to Insert tab Slicer	Alt+ N, SF

Ctrl Shortcuts

AUCTION	SHORTCUT KEY
rotates the active cell through the corners of a selection	Ctrl +.
Insert the current date	Ctrl +;
Copy the formula from the cell above	Ctrl + ‘
Format cells dialog	Ctrl + 1
Open a new workbook	Ctrl + O
Open Print in backstage view	Ctrl + P
Move to previous sheet	Ctrl + PgUp
Fill a range to the right	Ctrl + R
To move between groups on a ribbon	Ctrl + Right Arrow or Ctrl + Left Arrow
Select the entire column	Ctrl + Spacebar
Redo	Ctrl + Y
Delete the selected cells	Ctrl + –
Insert the current date	Ctrl +;
Select direct precedent cells	Ctrl + [
Select directly dependent cells	Ctrl +]
Toggle between viewing values and formulas in cells	Ctrl + ~
Hide the selected columns	Ctrl + 0
Hide the selected rows	Ctrl + 9
Fill a range down	Ctrl + D
Open the Find and Replace dialog box	Ctrl + F
Expand or collapse the ribbon	Ctrl + F1
Open Print Preview	Ctrl + F2
Define a range name	Ctrl + F3
Open the GoTo dialog box	Ctrl + G or F5
Insert a hyperlink	Ctrl + K
Open the Create Table dialog box	Ctrl + L
Create a new, blank workbook	Ctrl + N
Move to next sheet	Ctrl + PgDn
Display Quick Analysis options	Ctrl + Q
Move between open workbooks	Ctrl + Tab
Undo	Ctrl + Z
Select entire worksheet cells	Ctrl + A
Copy the cell	Ctrl + C
Cut the Cell	Ctrl + X
Paste The Cell	Ctrl + V

Control + Shift Shortcuts

AUCTION	SHORTCUT KEY
Apply the number format with two decimals	Ctrl + Shift +!
Unhide any hidden rows in the selection	Ctrl + Shift + (
Insert the current time	Ctrl + Shift +;
Apply the currency format	Ctrl + Shift + $
Apply the percentage format	Ctrl + Shift + %
Apply an outline border to the selected cells	Ctrl + Shift + &
Unhide any hidden columns in the selection	Ctrl + Shift +)
Select a range of cells	Ctrl + Shift + *
Insert the current time	Ctrl + Shift +;
Apply the exponential number format	Ctrl + Shift + ^
Remove the outline border	Ctrl + Shift + _
Apply the general number format	Ctrl + Shift + ~
Copy the value from the cell above	Ctrl + Shift + “
Insert blank cells	Ctrl + Shift + +

Shift Shortcuts

AUCTION	SHORTCUT KEY
Select the current sheet and the next sheet	Shift + Ctrl + PgDn
Select the entire row	Shift + Spacebar
Select all precedent cells	Shift + Ctrl + [
Select all dependent cells	Shift + Ctrl +]
Select the current sheet and the previous sheet	Shift + Ctrl + PgUp
Insert a new worksheet	Shift + F11
Display the insert function dialog box	Shift + F3

Single Key Shortcuts

AUCTION	SHORTCUT KEY
Help	F1
Toggle between absolute and relative cell references	F4
Activate a selected command on the ribbon	Spacebar or Enter key
Finish with a control on the ribbon and move back to the document	Enter key
Cancel	Esc
Create a chart	F11
Edit cells	F2
Paste named range in formula	F3
Repeat the last action	F4
On the ribbon, to move between commands	Tab or Shift-tab
Open a gallery on the ribbon	Spacebar or Enter key
Select entire worksheet cells	(if data in worksheet, then once selects region and Ctrl + A twice selects entire worksheet) Ctrl+ A

 The more you use keyboard shortcuts, the easier they are to remember. And no one expects you to memorize all of them. Hopefully, you’ve found a few new ones you can use to make your life in Excel a little better.

 

Need more help with keyboard shortcuts? You can access Help anytime by pressing F1. This opens a Help pane and allows you to search for help on any topic. Search for “keyboard shortcuts” to learn more.

         

Thank You