If you're not an Excel master, you probably get scared when you have to load a spreadsheet and make a 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 if you want to use it a lot in the future, you need to learn Excel the right way 8 Tips on How to Learn Excel Fast 8 Tips on How to Learn Excel Fast Not as comfortable with Excel as you'd like? Get started with simple tips for adding formulas and managing data. Follow this guide and you'll be up to speed in no time. Read More 16 Excel Formulas to Help You Solve Real-Life Problems. 16 Excel Formulas to Help You Solve Real-Life Problems. The right tool is half the job. Excel can solve calculations and process data faster than your calculator can. We show you the key Excel formulas and show you how to use them. Read more.
But no matter who you are, you really You should be aware of the following shortcuts, which should work in Excel 2010 and later. They will save you a lot of time in the future.
F4 to repeat the last command.. Regardless of what you just did in that cell, you can press F4 to do it again in any other cell. For example, change the color of the text, apply a border, format the font, etc.
Alt + H, E, A to delete the selected cells. By clearing, I mean clearing all the contents, formatting, hyperlinks, and comments attached to the selected cells. In essence, it is a "hard reset" of the cells.
Alt + H, O, I to automatically resize all columns and rows. Select the cells you want to automatically enable, then press the keys. It will automatically resize all rows and columns to fit the cells you have selected.
Do you want to learn some more tricks? Check out this list of everyday Excel shortcuts 35 Everyday Microsoft Excel Keyboard Shortcuts for Windows and Mac 35 Everyday Microsoft Excel Keyboard Shortcuts for Windows and Mac keyboard shortcuts can save you a lot of time. Use these Microsoft Excel shortcuts to speed up work with spreadsheets on Windows and Mac. Read More 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 fan of Excel. . A lot of that comes from the fact that I enjoy writing VBA code, and Excel combined with VBA scripts opens up a whole world of possibilities... Read More .
What other Excel keyboard shortcuts would you consider essential to know? Share with us below!
