3 Excel Shortcuts You Don’t Know That Will Save You a Lot of Time

Surely everyone uses Excel, and if not at home, it has likely become essential in the workplace. Previously, we reviewed how to use Excel professionally, followed by reviewing the operations and equations you need to know in Excel. Today, I want to share with you some very useful shortcuts in Excel that you may not know and you should know now because they will save you a lot of time and effort. Since they have made things easier for many after knowing them, I believe they will make things better for you too.

Before I review the shortcuts, I want to remind you all of the video below where we reviewed Excel in full in 20 minutes. I believe it is worth mentioning and worth watching.

Topics that will definitely benefit you

• Using Word like a Pro in 20 Minutes
• A Tour of Microsoft Office 2016 Programs and Key Features
• 5 Ways to Get Microsoft Office for Free
• Extracting Images from Word Files without Software and in Original Quality

First of all, let me tell you that many shortcuts will be meaningless because you won’t remember all these shortcuts, which may exceed a thousand or more in Excel. But I will only present the shortcuts that deserve to be used because they save time by reducing several steps in one step.

One important shortcut that I use is F4 to repeat the previous edit. This means that if you make any edits to a cell in Excel and want to repeat it on another cell and so on, all you have to do is press F4 and it will apply the same edit to any selected cell. For example, applying the same color, font, or adding a border to the cell and so on from edits.

One very important shortcut that I use is Alt + H, O, I which resizes all selected rows and columns automatically. It automatically resizes these rows and columns to fit the selected cells. What I used to do before discovering this shortcut was manually double-clicking on each row and column to resize it automatically. If you work in Excel for your job, I believe this special shortcut will help make the Excel sheet look much better.

Another useful Excel shortcut is CTRL+ALT+V which allows you to copy and paste in a more specific way. After copying a cell, you can press this shortcut and choose what you want to paste specifically from values, formulas, formats, comments, validation. To elaborate further, when you copy a cell that contains a formula and you want to copy the value inside the cell and not the formula, you will definitely need to copy and paste the cell content as Value, and this shortcut will help you with that.

Now it’s your turn, what Excel shortcut do you think nobody else knows except you and everyone should know about? I hope you add it in the comments below so everyone can benefit. Thank you.