Accounts, lists or reports — Excel is everywhere in an office. A few shortcuts can halve the time you spend.
The most useful shortcuts
- Ctrl + C / Ctrl + V — copy and paste
- Ctrl + Z — undo
- Ctrl + Arrow — jump to the end of the data
- Ctrl + Shift + L — turn on filters
- Alt + = — instant SUM
- F2 — edit a cell
- Ctrl + 1 — format cells
- Ctrl + Space — select the whole column
- Shift + Space — select the whole row
- Ctrl + S — save (often!)
Use one or two every day and they will be a habit within a week.
