3 Essential Time-Saving Excel Shortcuts You Should Know

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, 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!

Join live MakeUseOf Groups on Grouvi App Join live Groups on Grouvi
Become Better :thumbsup:
Become Better :thumbsup:
258 Members
Productivity Tips
Productivity Tips
215 Members
Affiliate Disclamer

This article may contain affiliate links, which pays us a small compensation if you do decide to make a purchase based on our recommendation. Our judgement is in no way biased, and our recommendations are always based on the merits of the items.

For more details, please read our disclosure.
New comment

Please login to avoid entering captcha

Log In