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.
Apparently pressing F4 in excel lets you repeat the previous command..Like highlighting a cell or inserting a formula
ALL THE WASTED YEARS
— Edrich Ty (@SwaggyT94) November 27, 2015
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!