Ctrl+Shift+L: Filter Columns . Filters are an invaluable tool in Excel to display only the rows that meet certain criteria you set, making data scouring and analysis much more straightforward.

7 Useful Keyboard Shortcuts For Excel . Anupama Jha May 04, 2024 ... This shortcut enables or disables filters. Press Ctrl + Shift + L to add filters to your column headers ... or columns. Ctrl + '-' ...

Click the Filter button under the Data tab. Note the small boxes with down arrows that appear beside each column/field name. 9. Click the arrow on the State field, and a Sort & Filter dialog menu ...