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
Do not be too timid and squeamish about your actions. All life is an experiment.
Ralph Waldo Emerson
SUM keyboard shortcut
The keyboard shortcut to insert the SUM function is
Alt + =
Hold the Alt key down and press = key.
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.
Return after a hyperlink
In Excel to return to the hyperlink that you followed, first press F5, then press Enter.
Have patience with all things, but chiefly have patience with yourself.
St. Francis de Sales (1567–1622)
There are numerous keyboard and mouse shortcuts to navigate around your spreadsheet and file.
The way to get started is to stop talking and start doing.
Walt Disney (1901–1966)
To avoid criticism, do nothing, say nothing, be nothing.
Elbert Hubbard (1856–1915)
Always do right. This will gratify some people, and astonish the rest
Mark Twain (1835 – 1910)
A good example is the best sermon.
Benjamin Franklin (1706 – 1790)
If you need to use special characters in formulas in Excel you can use the CHAR function. There are 255 options, but only about 10 are useful.
Excel has two options that relate to top and bottom scores. These are usually shown as Top 10 or Bottom 10 options. In both cases they are much more flexible than that.