Exceljet

Quick, clean, and to the point

Undo last action

Windows shortcut 
CtrlZ
Mac shortcut 
Z

This shortcut will allow multiple levels of undo; each time you use it Excel will step back one level.

Related videos

The videos below demonstrate this shortcut.
In this video, we'll look at how to rank values in ascending or descending order using the RANK function. When values change, the rank will automatically update.
In this video, we’ll look at a basic example of sorting with the SORTBY function. With the SORTBY function, you supply sort order in pairs of inputs. Each pair has an argument for range, and an argument for sort order.
In this video we show you how to use merge to align text across cells. Merge is easy and works well, but be sure to check out Center Across Selection for an option that doesn't interfere with Excel's grid.
In this video we'll look how to use the FILTER function with Boolean logic to apply multiple criteria. The result is a filtered list where the color is Blue and the month is June
In this video, we'll look at several options for creating a pivot chart. A pivot chart is an extension of a pivot table, so in order to have a pivot chart you must also have a pivot table.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.