Excel Keyboard Shortcuts Every Data Analyst Must Know

Deepanshu Bhalla 18 Comments

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
Basic Excel Keyboard Shortcuts

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
Useful Excel Keyboard Shortcuts

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
Productivity Boosting Excel Keyboard Shortcuts

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
Lesser-Known Excel Keyboard Shortcuts
Related Posts
Spread the Word!
Share
About Author:
Deepanshu Bhalla

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.

Post Comment 18 Responses to "Excel Keyboard Shortcuts Every Data Analyst Must Know"
  1. seems to be useful but has to remember a lot

    ReplyDelete
  2. Start with "Basic" shortcuts , then jump into a long list of "Productivity Boosting keyboard" shortcuts.

    ReplyDelete
  3. Hi Deepanshu, great work done till now...but waiting for your ANOVA and Regression which are awaiting

    ReplyDelete
  4. Hi All....can anyone tell How to unhide Status bar in Excel?

    ReplyDelete
  5. Hi 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.........

    Once again Thanking you....Deepanshu....Good luck

    ReplyDelete
  6. think there's more about the shortcut unmentioned

    ReplyDelete
  7. cntrl+Shift+L for turn off and on filters

    ReplyDelete
  8. Clear filer is not Alt D F S -> it is Alt D F F

    ReplyDelete
  9. Ctrl + Down = Fill down is wrong
    It is
    Ctrl + D = Fill Down

    ReplyDelete
  10. Correction:
    Alt D F F = toggle filtering on/off
    Alt D F S = shows all filtered rows, without actually turning filtering off

    ReplyDelete
  11. its very helpful. Thank you so much deepanshu bhalla
    god bless you sir

    ReplyDelete
  12. I think.. this.. is .. the..one .. of.. the.. amazing ..sites..now-a-days and it will stand in top..in ..couple..of.. months..
    Thank u..Deepanshu..Bhalla.....
    All the best..!......!...

    ReplyDelete
  13. 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

    ReplyDelete
Next → ← Prev