Eric P. Butts

THE Career Site for Accountants and Consultants.

  • Home
  • About
  • Useful Resources
  • Articles
  • Work With Me
    • Breakthrough Resume Writing
    • How to Get Smart in Excel…Fast!
    • Corporate Ladder University (Book)
  • Privacy Policy
  • Terms of Use
  • Disclaimer
  • Login
You are here: Home / Excel / 10 Excel Shortcuts That Will Make You Look Like a Wizard

May 6, 2016 by Eric Butts 12 Comments

10 Excel Shortcuts That Will Make You Look Like a Wizard

top 10 excel shortcuts

When I published the post about the top 10 Excel formulas, I had no idea how much people respond to that. TONS of people have asked for videos, so being the man of the people that I am, I’m going to deliver on that….but not today.

Today is about Excel shortcuts.

Click to Instantly Download My Free Excel Wizard Cheatsheet

When I went to my first internship many years ago, I remember one of the finance managers telling me there’s no reason to ever touch the mouse when using Excel. I work with someone today who I’ve heard say the same almost verbatim. I guess some things never change.

Never might be a bit strong, but here are 10 ways to bypass the mouse to get results faster in Excel.

1. ALT, D, F, F

Highlight the header row of the table in question, enter ALT, D, F, F and voila – you can quickly toggle data filters on/off.

2. ALT, D, F, S

You ever find yourself in a massive spreadsheet with filtered rows but you can’t figure out where the filter is? This Excel shortcut clears data filter criteria but keeps the filters on the dataset.

3. CTRL + (-)

Enter this command when your cursor is anywhere in the spreadsheet and you get the delete menu, offering four options : 1) Shift cells left 2) shift cells up 3) entire row 4) entire column.

4. CTRL + R

Instead of copying and pasting or dragging for all eternity when you want a formula to fill to the right, highlight the range where you want the formula repeated (beginning with the cell with the formula in it) and key CTRL + R.

5. CTRL + D

You can also key in CTRL + D if you want a formula to fill down. It works exactly like CTRL + R, just going vertically instead of horizontally.

6. ALT, N, V

One of the most powerful tools in Excel is the pivot table (used for summarizing and analyzing data). This shortcut quickly takes you to the screen for your pivot table inputs.

7. CTRL + Page Up/Down

Flipping through workbook tabs is much easier using this Excel shortcut than it is pointing and clicking your mouse to view each tab.

8. CTRL + Arrows

Moving around in a spreadsheet can become cumbersome with you’re just scrolling with the mouse or using the arrows alone. CTRL + Arrow takes your cursor to the next open cell in the direction of the arrow you pressed. A bonus trick is to also press CTRL + SHFT+ Arrows, which will then highlight all of the cells or rows up to the next blank cell.

9. CTRL + Home/End

CTRL+Home/End takes your cursor to the beginning/end of the spreadsheet, respectively, regardless of whether there are blank cells in the spreadsheet.

10. CTRL + 1

This shortcut is simple yet indispensable because every time you use a workbook you’re going to need to format cells. Currency, date, and number are probably the formats I change most frequently, but this is also where you can play around with borders.

Start working these Excel keyboard shortcuts into your arsenal and watch how the time savings from not having to take your hands off the keyboard adds up. Every second counts.

To more efficient spreadsheeting!

Click to Instantly Download My Free Excel Wizard Cheatsheet

I want to hear from you!

Have some favorite Excel shortcuts you think got snubbed from this list? Leave a comment with your favorite.

Filed Under: Excel, Management Consulting Tagged With: excel, keyboard shortcuts

About Eric Butts

I’m a management consultant, MBA and CPA who has a passion for helping others in their career pursuits. Grab my FREE cheatsheet on 12 simple habits of highly successful consultants.

Comments

  1. Pooja says

    May 10, 2016 at 6:15 am

    Alt + = for auto sum

    Log in to Reply
    • Eric Butts says

      May 10, 2016 at 6:23 am

      I’ve never used that one. Will have to give it a go today.

      Log in to Reply
      • Pooja says

        May 10, 2016 at 8:04 am

        Yeah that makes it so much easier sometimes

        Also the Ctrl + Shift + Arrows to select to the end of the data – But if it is all blank it will just select every single cell in that direction till the end of the sheet

        Ctrl + Shift + End to select all the data till the end of the sheet including columns and rows. The above one is restricted to either columns or rows.

        Alt + down arrow on the header to open the filter list. For this you can have the filter on already or you don’t need to toggle the filter on but still be able to do it

        Ctrl + Alt + V to paste special – helps a lot especially when you want to transpose

        This isn’t exactly a keyboard shortcut but I love this as a quick formatting shortcut that some people miss: Format Painter.

        Log in to Reply
        • Eric Butts says

          May 10, 2016 at 11:18 pm

          Thanks, Pooja. These are great ones. Oddly enough, I never really use the paste special value shortcuts. I think ALT,E,S,V is the specific one for pasting values that I see people use a lot.

          You can never have too many shortcuts!

          Log in to Reply
  2. Alisha says

    August 10, 2016 at 6:51 pm

    This was amazing … I love shortcuts and these gems have been missing in my life. Thank you for sharing!!!

    Log in to Reply
    • Eric Butts says

      August 11, 2016 at 1:10 pm

      Alisha – that’s great to hear! Make sure you join the content library to see the other videos if you haven’t already. Happy almost Friday!

      Log in to Reply
  3. Thalia Williams says

    August 18, 2018 at 2:02 am

    Thank you Mr. Butts, this article has been immensely useful.

    Log in to Reply
    • Eric Butts says

      August 24, 2018 at 7:54 pm

      I hope you find the rest of the site helpful too!

      Log in to Reply
  4. katharine says

    September 8, 2018 at 8:06 am

    Hi How do you use ALT D F S on a Mac? struggling to find an alternative

    Log in to Reply
    • Eric Butts says

      October 3, 2018 at 11:16 pm

      I don’t think this exists. Mac has some known shortcomings in Excel 🙁

      Log in to Reply
    • Kashish says

      June 5, 2019 at 8:55 am

      Use Alt + A + T

      Log in to Reply
  5. simon says

    May 21, 2019 at 4:25 am

    Thanks for such a beautiful post, very informative and useful article

    Log in to Reply

Leave a Reply Cancel reply

You must be logged in to post a comment.

Featured Posts

How to Get Into Business School – Part 1 (GMAT)

Stop Dressing Like a Clown and People Will Stop Treating You Like One

How Bad Can It Hurt To Say Thank You?

What You Need to Know About Getting Promoted

3 Words That Will Kill Your Career

Popular Posts

  • 5 Reasons You Should Be Proud to Ask Dumb Questions at Work
  • What Does It Mean to Have a Sense of Urgency
  • Always Stay Close to the Gatekeepers
  • Why Are There Still So Few Black CPAs?
  • What's the Difference Between FP&A and Accounting?
  • 3 Reasons Average Students Become Good Accountants
  • One Thing You Should Never Do on Linkedin
  • How to Handle Double Standards in the Workplace
  • How to Pass the CPA Exam Without Breaking the Bank
  • Masters in Accounting Isn't The Sweet Treat Some Students Think

Recent Posts

  • How To Customize A LinkedIn Invite From Your Phone
  • Weird non-flex but ok
  • The little video game that could is putting on a masterclass in marketing yourself by picking a fight with two juggernauts
  • Today’s message is brought to you by middle of the night confusion
  • This. Is. Sparta!
  • Privacy Policy
  • Terms of Use
  • Disclaimer

© 2012–2021 Eric P. Butts