Pinterest Stumbleupon Whatsapp
Advertisement

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.

Advertisement

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!

Leave a Reply

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