How do I...
Learn the most useful shortcuts
What to do
- Ctrl+C, Ctrl+V and Ctrl+Z copy, paste and undo.
- Ctrl+Arrow jumps to the edge of your data.
- Ctrl+Shift+Arrow selects to the edge of your data.
- Ctrl+T makes a table.
- Alt+= adds a SUM.
- F4 adds $ signs to a reference.
- Ctrl+1 opens Format Cells.
Good to know
- Ctrl+; enters today's date.
- Ctrl+Space selects a column, and Shift+Space selects a row.
- On a Mac, many of these use Command instead of Ctrl.
The idea in general
A few shortcuts save a lot of clicking over time.
What I assumed
- You are using Excel on a computer. Menus can look a little different on a Mac or in a browser.