3 Essential Time-Saving Excel Shortcuts You Should Know
Pinterest Stumbleupon Whatsapp

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, including a bunch of the formulas that make Excel great.

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.

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

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

Leave a Reply

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

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

    Thanks for the clarification.

  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