5. CTRL SHIFT L
Make analyzing large data sets a little easier with the CTRL SHIFT L shortcut. CTRL SHIFT L adds the Sort&Filter toggles to the top row of the data set, so you can quickly sort and filter data.
4. ALT F1
If you spend too much time creating charts to visualize your data, meet ALT F1. These two magical keys automatically generate a bar chart using the selected data and insert it right into the active worksheet!
3. CTRL SHIFT #
Efficiently format date values in Excel with the CTRL SHIFT # shortcut! CTRL SHIFT # automatically applies date formatting to the selected cells.
It appears I forgot number four... so here it is:
4. CTRL SHIFT $
A majority of the time, we work with profitability data in Excel. Make sure your data is formatted correctly with CTRL SHIFT $. The CTRL SHIFT $ shortcut quickly formats numbers as currency values.
7. CTRL SHIFT ~
We’ve learned a lot of number formatting shortcuts, but what if we need to convert numbers back into their raw format? The CTRL SHIFT ~ has you covered. CTRL SHIFT ~ automatically applies general number formatting to the selected cells.