The keyboard shortcut for applying filters in MS Excel is simple. If you’re used to playing with heavy Excel worksheets that have lots of data, you’ll find auto filter a real lifesaver.Īpplying filters to a cell allows you to extract the information you’re looking for, organize the data in different ways, and identify trends within data sets. Shortcut #2: Toggle Auto Filter In Columns The cells with a comment box have a small red mark for identification. The great thing about the comment box is that you can also add bullets and formatting to it like a normal cell. This opens a comment box where you can leave additional notes, reminders, or any other information that provides context to the cell’s value. To use it, click on the desired cell and press SHIFT+F2 on your keyboard. It allows you to add comments to a cell that users can view by hovering over it. If you’re working on an Excel sheet that you have to share with your team members or just want to add reminders to a cell for your reference, you’ll love this keyboard shortcut. Shortcut #1: Insert A Note/Comment On A Cell In this article, I’ll share some of the most useful Excel keyboard shortcuts and how you can use them to get things done faster. There’s so much you can do with Microsoft Excel and using the right keyboard shortcuts at the right time makes it more enjoyable (plus helps you make an impression on your bosses) If you’re a frequent user of Microsoft Excel, you can add several months to your life by using Excel shortcuts.Īccording to a study, you can save 64 hours every year by using keyboard shortcuts as a frequent Excel user.