In this article, you will learn how to add/remove filters in Google Sheets with the shortcut: Ctrl + Shift + L, exactly how you would in Excel. This is a shortcut that is unavailable in native Sheets today, but you can use with the SheetWhiz Chrome extension
Steps:
1. Install the SheetWhiz Chrome Extension for free
2. Load a Sheet and the SheetWhiz logo will appear
3. Select the columns you'd like to filter and then use the shortcut Ctrl + Shift + L to add a filter to the columns. Press it again to remove the filter. Make sure you press and hold each key before pressing the next key, just like you would in Excel
That’s it! Note: you can also change the shortcut to a shortcut that works for you by clicking the button in the SheetWhiz menu and changing the key
As an alternative, you can leverage built in Google Sheets shortcuts by reading this article here
Comments