Shortcuts by role · Excel

Excel shortcuts for accountants

In finance, speed and accuracy go together. The accountants who look effortless at month-end aren't working longer hours; they move through ledgers, check formulas and format reports without touching the mouse. These are the shortcuts worth learning first.

16 hand-picked shortcutsUpdated October 2026

The shortcuts that matter most

  1. Ctrl+Arrow key

    Move to the edge of the current data region Excel

    Jump to the edge of a ledger or trial balance instantly, however many thousand rows it has.

  2. Ctrl+End

    Move to the last used cell Excel

    Find the last used cell to check how far a dataset really goes, including stray entries.

  3. Alt+=

    Insert AutoSum Excel

    Total a column or a whole block of figures in one move when building schedules.

  4. F4

    Repeat the last command or cycle reference types in a formula Excel

    Lock references with $ signs while writing formulas, so they copy correctly across a model.

  5. Ctrl+`

    Show or hide formulas Excel

    Show every formula on the sheet to spot hard-coded numbers and broken links during review.

  6. Ctrl+'

    Copy the formula from the cell above Excel

    Copy the formula from the cell above exactly, without the references shifting.

  7. Ctrl+D

    Fill down from the cell above Excel

    Fill a formula down an entire column of transactions in one keystroke.

  8. Ctrl+Shift+L

    Toggle filters for the current range Excel

    Toggle filters to isolate a supplier, cost centre or period in seconds.

  9. Ctrl+T

    Create a table from the selected range Excel

    Turn raw exports into a structured table that grows as new rows arrive.

  10. F9

    Calculate all worksheets in all open workbooks Excel

    Recalculate every open workbook when calculation is set to manual on heavy models.

  11. Shift+F9

    Calculate the active worksheet only Excel

    Recalculate just the active sheet, which is quicker on large files.

  12. Ctrl+Alt+V

    Open Paste Special (e.g. paste values only) Excel

    Paste Special lets you paste values only, freezing a formula's result before you send a report.

  13. Ctrl+Shift+~

    Apply the General number format Excel

    Reset a selection to the General number format to see the raw values underneath.

  14. Ctrl+1

    Open the Format Cells dialog Excel

    Open Format Cells for precise control over number formats, decimals and negatives.

  15. Ctrl+Page UporCtrl+Page Down

    Move between worksheets Excel

    Flick between the tabs of a multi-sheet workbook without the mouse.

  16. Ctrl+E

    Fill in data automatically with Flash Fill Excel

    Use Flash Fill to split or reformat account codes and references from an example.

How to learn them: pick three a week, use them every day until they're automatic, then add three more. Practice mode makes it stick faster.

Get ahead of your peers

Reading a list is a start. Practising is what builds muscle memory. Try the free trainer and track your streak.

Practise free

Full shortcut lists

XLExcelAll 50 shortcuts

Shortcuts for other roles

Outlook and Teams shortcuts for project managersOutlook, Teams and OneNote shortcuts for project managers: run meetings smoothly, stay on top of email and capture actions as they happen. Microsoft 365 shortcuts for HR and admin teamsWord, Outlook and Excel shortcuts for HR and administration: polished letters and policies, tidy trackers and a well-run inbox. Microsoft 365 shortcuts for studentsWord, PowerPoint, OneNote and Edge shortcuts for students: write essays faster, format them properly, present with confidence and research efficiently. Microsoft 365 shortcuts for executive assistantsOutlook, Teams and Word shortcuts for executive and personal assistants: manage diaries, triage inboxes and turn documents around fast.