If you consider yourself a skilled Excel user, you know how important it is to use keyboard shortcuts. Not only does it make your work faster and more efficient, but it also allows you to impress others by working without a mouse. Improve your Excel skills by mastering these shortcuts, and you'll be amazed at how much more you can achieve while wowing your friends and colleagues.
If there's a shortcut for it, just use the keyboard instead of the mouse.
Basic Excel Keyboard Shortcuts
Keyboard shortcuts can help you save time and be more efficient when working in Excel. Here are some of the most basic Excel shortcuts to get you started:
Shortcut Keys |
Actions |
Ctrl + X |
Cut |
Ctrl + C |
Copy |
Ctrl + V |
Paste |
Ctrl + Z |
Undo |
Ctrl + Y |
Redo |
Ctrl + B |
Bold |
Ctrl + I |
Italics |
Ctrl + S |
Save |
F12 |
Save As |
Useful Excel Keyboard Shortcuts: Master Them and Save Time
Here are some of the most useful Excel shortcuts that can save you time:
Shortcut Keys |
Actions |
F2 |
Edit a cell |
F5 |
Displays GO TO box |
Alt = |
Autosum |
Ctrl + F |
Find |
Ctrl + H |
Replace |
Ctrl + D |
Fill down |
Ctrl + R |
Fill right |
F2 + Ctrl + Enter |
Fill the selected cells |
Ctrl + (Plus) |
Insert a new row / column |
Ctrl - (Minus) |
Delete a row / column |
Shift + F11 |
Insert a new worksheet |
Alt + E + L |
Delete a worksheet |
Alt + O + H + R |
Rename a worksheet |
Ctrl + N |
Insert a new workbook |
Ctrl + O |
Open a workbook |
Boost Your Excel Productivity with These Essential Keyboard Shortcuts
Shortcut Keys |
Actions |
Alt + D + F + F |
Turn on / off filters |
Alt + D + F + S |
Clear filter |
Alt + Enter |
Insert a new line within a cell |
Ctrl + F2 |
Open print preview |
Alt + E + S + V |
Paste the results of a formula (not the formula itself) |
Alt + E + S + T |
Paste formats (not the content) |
Ctrl + Pg Up/Down |
Move to previous / next sheet |
Ctrl + Tab |
Switch between workbooks |
Alt + F11 |
Open VBA Editor Window |
Ctrl + ~ |
Show / Hide Formulas in Cells |
Ctrl + Spacebar |
Select entire column |
Shift + Spacebar |
Select entire row |
Ctrl + * |
Select current range |
Ctrl + Shift + Down/Right |
Select till the last non-blank cell in column/row |
Ctrl + A |
Select all data in an entire worksheet |
Ctrl + 0 |
Hide a column |
Ctrl + Shift + 9 |
Unhide a column |
Alt + N + V + T |
Insert pivot table |
Alt + O + C + W |
Change column width |
Alt + O + R + E |
Change row width |
Ctrl + 1 |
Format cells |
Ctrl + % |
Apply percentage format |
Ctrl + ; |
Today's date |
Ctrl + Shift + ; |
Today's time |
Lesser-Known Excel Keyboard Shortcuts
Shortcut Keys |
Actions |
Press F5 and type A2:M9 in Reference: box and press ENTER |
Select a range (A2:M9) |
F7 |
Spell Check |
CTRL+F9 |
Minimize the workbook window to an icon |
CTRL+F10 |
Maximize or restore the workbook window |
Window logo key + M |
Minimize all excel workbook windows |
Ctrl + ' |
Copy formula above |
Ctrl + . (period) |
In selection, jump the active cell around from corner to corner |
About Author:Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has over 10 years of experience in data science. During his tenure, he worked with global clients in various domains like Banking, Insurance, Private Equity, Telecom and HR.
seems to be useful but has to remember a lot
ReplyDeleteYou can use an Enterpad!
DeleteStart with "Basic" shortcuts , then jump into a long list of "Productivity Boosting keyboard" shortcuts.
ReplyDeleteHi Deepanshu, great work done till now...but waiting for your ANOVA and Regression which are awaiting
ReplyDeleteHi All....can anyone tell How to unhide Status bar in Excel?
ReplyDeleteHi Deepanshu Bhalla, i would like to thank you for providing this site to Analysts.And we are waiting for new posts from you.so please keep updating info about Analytics.........
ReplyDeleteOnce again Thanking you....Deepanshu....Good luck
Thanks a lot for this lecture
ReplyDeleteSuper site
ReplyDeletethink there's more about the shortcut unmentioned
ReplyDeletecntrl+Shift+L for turn off and on filters
ReplyDeleteClear filer is not Alt D F S -> it is Alt D F F
ReplyDeleteCtrl + Down = Fill down is wrong
ReplyDeleteIt is
Ctrl + D = Fill Down
Correction:
ReplyDeleteAlt D F F = toggle filtering on/off
Alt D F S = shows all filtered rows, without actually turning filtering off
its very helpful. Thank you so much deepanshu bhalla
ReplyDeletegod bless you sir
I think.. this.. is .. the..one .. of.. the.. amazing ..sites..now-a-days and it will stand in top..in ..couple..of.. months..
ReplyDeleteThank u..Deepanshu..Bhalla.....
All the best..!......!...
hi Deepanshu congrats its a wonder ful site for beginners. i have updated my base in SAS predictive analytics and R program from your site.Thanks alot
ReplyDeleteThis is very useful.
ReplyDeletegreat
ReplyDelete