So I rely on CTRL+arrow key combinations all the time. When it comes to dealing with data, navigate, you must. CTRL+Arrow keys – Navigate around the workbook So I just turn-off and turn-on the filters, by pressing CTRL+SHIFT+L twice. So, Once I set a couple of filters, If I want to revert back to full data, I find clearing each filter a pain. Most of the time, I use filters to do ad-hoc analysis of my data. I use this all the time, to format cells, charts, text boxes – you name it. Oh CTRL+1, if I get an ear, every-time I press you, I would be a millionear by now. In this post, I am sharing 10 such shortcuts that I can’t live without, especially, when I am analyzing data, making charts and formatting my workbooks. So, it all boils down to memorizing the few shortcuts that you use all the time. While it may be a good idea to know a 97 different shortcuts for everything in Excel, the fact is, you don’t use them all the time. Everyone and their colleague knows the importance of Excel keyboard shortcuts.
