Pinterest Stumbleupon Whatsapp
Ads by Google

If you aren’t an Excel master, you probably dread those times when you have to load up a spreadsheet and make a whole bunch of trivial but time-consuming changes. Fortunately, there are some shortcuts that can make your life easier.

Now, to be clear, if your livelihood revolves around Excel or you intend to use a lot of it in the future, you owe it to yourself to learn Excel the right way 8 Tips for How to Learn Excel Quickly 8 Tips for How to Learn Excel Quickly Not as comfortable with Excel as you would like? Start with simple tips for adding formulas and managing data. Follow this guide, and you'll be up to speed in no time. Read More , including a bunch of the formulas that make Excel great 16 Excel Formulas that Will Help You Solve Real Life Problems 16 Excel Formulas that Will Help You Solve Real Life Problems The right tool is half the work. Excel can solve calculations and process data faster than you can find your calculator. We show you key Excel formulas and demonstrate how to use them. Read More .

But no matter who you are, you really ought to know about the following shortcuts, which should work on Excel 2010 and after. They’ll save you a lot of time going forward.

F4 to repeat the last command. Whatever you just did to that cell, you can press F4 to do it again on any other cell. For example, change text color, apply a border, format the font, etc.

Alt + H, E, A to obliterate selected cells. By obliterate, I mean erase all of the contents, formatting, hyperlinks, and comments attached to the selected cells. In essence, it’s a “full reset” of the cells.

Ads by Google

Alt + H, O, I to auto-resize all columns and rows. Select the cells that you want to autofit, then hit the keys. It will automatically resize all rows and columns to fit the cells you’ve selected.

Want to learn a few more tricks? Check out this list of everyday Excel shortcuts 35 Everyday Microsoft Excel Keyboard Shortcuts for Windows & Mac 35 Everyday Microsoft Excel Keyboard Shortcuts for Windows & Mac Keyboard shortcuts can save you a lot of time! Use these Microsoft Excel shortcuts to speed up working with spreadsheets on Windows and Mac. Read More that you’ll likely find handy. It doesn’t take much to start loving Excel, especially when you start using it to manage your life How To Use Microsoft Excel To Manage Your Life How To Use Microsoft Excel To Manage Your Life It's no secret that I'm a total Excel fanboy. Much of that comes from the fact that I enjoy writing VBA code, and Excel combined with VBA scripts open up a whole world of possibilities.... Read More .

What other Excel keyboard shortcuts would you consider essential to know? Share with us down below!

  1. dan
    March 12, 2016 at 6:30 pm

    ViRa:
    Thanks for the clarification.
    Dan

  2. dan
    March 11, 2016 at 3:36 pm

    How can ALT+H obliterate & resize?
    Also, does ALT+H,E,A mean using any of these 3 letters do the same thing?

    • ViRa
      March 12, 2016 at 9:16 am

      To obliterate - press and hold ALT & type h e a , not all 3 at once.

      @Dan I too had the same doubt. Just tried to confirm :-p

Leave a Reply

Your email address will not be published. Required fields are marked *