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.


Related Posts

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

Oliver Wendell Holmes

Ctrl + Scroll Wheel

To quickly zoom in and out on a sheet in Excel, hold the Ctrl key down and move the mouse scroll wheel.

This also works in MS Word and internet browsers.