Add or Remove Data Filter

In Excel, to add or remove the Filter icons when the active cell is in a data list, use

Ctrl + Shift + L

Filters allow you to only see certain rows in the data list – when a filter has been applied the row numbers on the left of the screen turn blue.


The mind, once expanded to the dimensions of larger ideas, never returns to its original size.

Oliver Wendell Holmes