My Excel classes love learning new keyboard shortcuts. They are amazed at how much time they save when they use them.
Here are 10 of the most popular Excel shortcuts you’ll want to add to your repertoire.
Quickly select an entire worksheet
- Press CTRL + A to highlight the entire worksheet
Insert today’s date and current time without formulas
- Today’s date – CTRL + ;
- Current time – CTRL + :
Apply Currency format to values instantly
- Highlight the cells and press CTRL + SHIFT + $
Quick access to Excel’s formatting options
- Press CTRL+1 to display Format Cells
Sum a range of cells without writing a formula
- Press ALT + = to sum a range of cells above or to the left
Change cell references from Relative to Absolute in a flash
- Press F4 to fix a cell address so it doesn’t adjust when you copy the formula (Absolute), D2 changes to $D$2
Note: Press F4 again to freeze only the row with D$2. Press F4 again to freeze the column with $D2. Press again to toggle back to D2.
Move to Next and Previous worksheet tabs
- CTRL + PG DN – move to the worksheet tab on the right
- CTRL + PG UP – move to the worksheet tab on the left
Create a chart instantly
- Press ALT + F1 to chart your data on the current worksheet
Bonus – Create a chart on a new worksheet
Press F11 to chart your data on a new sheet