There's no denying the fact that shortcuts make our lives easier and if you're a Microsoft Excel user, you’ll like to see some of my favorite excel shortcuts. You might be surprised to learn about the variety of Excel shortcuts that are there, and while I do not expect you to remember some of them, it is always good to have a list which is just a glance away.
In this post, you’ll learn the most useful Excel shortcuts to be able to work faster in Excel. There are many hidden features in Excel that are easily accessible with shortcut keys.
Come with me as I list some of the most important Microsoft Keyboard shortcuts for Windows to make your work easier.
Ctrl+T: Create an Excel Table
Ctrl+Shift+L: Add / remove Excel Filter
Ctrl+ Navigation Arrows: Navigate in Large Data Sets
Ctrl+Shift+Navigation Arrows: Select a Range of Cells
Ctrl+*:Select the entire table
Ctrl+1:Activates the Format Cells Dialog Box in Excel
Alt+=: Auto Sum
Alt+ESV: Paste as Values, this will activate a dialog box, just press enter.
Alt+F1:Having your dataset selected. This will insert a chart for you
Ctrl+E:Excel Flash Fill, this will help automatically paste a pattern
Ctrl + +: Insert a New Row/Column
Ctrl + -: Delete a Row/Column
These are some of the important shortcuts that can help you become a Microsoft Excel master. If you find anyone you’ve not used before, practice it a few times and you’ll become a master at it.