Excel for accountants
Excel shortcuts
60 Windows shortcuts, each with a real accounting use case. One new Short every day.
| Keys | What it does | Use it for | Level |
|---|---|---|---|
| Ctrl + Arrow key | Jump to the edge of the current data region | Jump to the last row of a 10000-line ledger instantly | beginner |
| Ctrl + Shift + Arrow key | Select to the edge of the data region | Select a whole column of amounts to sum or format | beginner |
| Ctrl + Home / Ctrl + End | Go to cell A1 / the last used cell | Find where a messy trial balance really ends | beginner |
| Ctrl + Page Up / Page Down | Move to previous / next worksheet | Switch between monthly sheets fast | beginner |
| Ctrl + Space | Select the entire column | Format a whole amount column as currency | beginner |
| Shift + Space | Select the entire row | Select a journal line to delete or highlight | beginner |
| Ctrl + A | Select the current region (press again for whole sheet) | Select the whole data table before sorting | beginner |
| Ctrl + T | Convert range to an Excel Table | Turn a bank statement into a filterable table | beginner |
| Ctrl + Shift + L | Turn filters on / off | Filter a ledger by account or date | beginner |
| Alt + Down Arrow | Open the filter drop-down of the active header | Filter without touching the mouse | intermediate |
| Alt + = | Insert AutoSum | Total a column of debits in one keystroke | beginner |
| F4 (while editing a formula) | Toggle absolute / relative references ($A$1) | Lock a VAT rate cell when copying formulas | beginner |
| F2 | Edit the active cell | Check which cells a formula uses | beginner |
| Ctrl + ` | Show / hide all formulas | Audit a worksheet before submitting | intermediate |
| Ctrl + [ | Select cells the formula refers to (precedents) | Trace where a balance-sheet figure comes from | intermediate |
| F9 (in formula bar) | Evaluate the selected part of a formula | Debug a long nested IF | advanced |
| Shift + F3 | Open the Insert Function dialog | Find the right function with argument help | beginner |
| Ctrl + F3 | Open the Name Manager | Manage named ranges like TaxRate | intermediate |
| Ctrl + Shift + F3 | Create names from row/column labels | Name every account row in one go | advanced |
| Ctrl + ; | Insert today's date | Date-stamp a voucher entry | beginner |
| Ctrl + Shift + ; | Insert the current time | Time-stamp a cash count | beginner |
| Ctrl + D | Fill down from the cell above | Copy a formula down a whole schedule | beginner |
| Ctrl + R | Fill right from the cell on the left | Copy a monthly formula across 12 months | beginner |
| Ctrl + Enter | Enter the same value in all selected cells | Put 0 in every blank selected cell | intermediate |
| Alt + Enter | Start a new line inside a cell | Write multi-line narration in a journal | beginner |
| Ctrl + E | Flash Fill | Split invoice numbers or names automatically | intermediate |
| Ctrl + 1 | Open Format Cells | Set custom number formats like 1000 separators | beginner |
| Ctrl + Shift + 1 | Number format with 2 decimals and thousand separator | Show amounts with thousand separators and 2 decimals | beginner |
| Ctrl + Shift + 4 | Currency format | Show amounts with a currency symbol | beginner |
| Ctrl + Shift + 5 | Percentage format | Show tax rates and margins as % | beginner |
| Ctrl + Shift + 3 | Date format | Fix dates that show as numbers | beginner |
| Ctrl + Shift + 7 | Apply an outline border | Box the total of a statement | beginner |
| Ctrl + B / Ctrl + I / Ctrl + U | Bold / italic / underline | Bold totals and headings | beginner |
| Ctrl + 9 / Ctrl + 0 | Hide selected rows / columns | Hide working columns before printing | intermediate |
| Ctrl + Shift + 9 | Unhide rows | Reveal hidden rows in a received file | intermediate |
| Alt + H O I | AutoFit column width | Fix ##### in amount columns | beginner |
| Alt + W F F | Freeze panes | Keep headers visible in a long ledger | beginner |
| Alt + Shift + Right Arrow | Group rows / columns | Collapse monthly detail into quarters | intermediate |
| Alt + Shift + Left Arrow | Ungroup rows / columns | Expand grouped schedules | intermediate |
| Ctrl + Shift + + (plus) | Insert cells / rows / columns | Add a missing journal line | beginner |
| Ctrl + - (minus) | Delete cells / rows / columns | Remove a duplicate entry | beginner |
| Ctrl + Alt + V | Open Paste Special | Paste values only to break formula links | beginner |
| Alt + ; | Select visible cells only | Copy only filtered rows to a new sheet | intermediate |
| F5 then Alt + S | Go To Special (blanks / constants / formulas) | Find hard-coded numbers in a model | advanced |
| Ctrl + F / Ctrl + H | Find / Find and Replace | Replace an old account code everywhere | beginner |
| F4 (not editing) | Repeat the last action | Apply the same formatting to many cells | intermediate |
| Shift + F2 | Insert / edit a note | Explain an adjustment for the reviewer | beginner |
| Ctrl + K | Insert a hyperlink | Link a summary sheet to supporting schedules | intermediate |
| Alt + F1 | Insert a chart of the selected data | Quick chart of monthly sales | beginner |
| F11 | Create a chart on a new sheet | Full-page chart for a report | beginner |
| Shift + F11 | Insert a new worksheet | Add next month's sheet | beginner |
| Ctrl + Shift + U | Expand / collapse the formula bar | Read long formulas comfortably | intermediate |
| F9 | Recalculate all open workbooks | Refresh when calculation is set to manual | intermediate |
| F12 | Save As | Save a copy before big changes | beginner |
| Ctrl + F1 | Show / hide the ribbon | More screen space for big sheets | beginner |
| Ctrl + Z / Ctrl + Y | Undo / redo | Recover from an accidental delete | beginner |
| Ctrl + Shift + $ / % / # | Same as Ctrl+Shift+4/5/3 (symbol keys) | Alternative way to remember formats | beginner |
| Alt + N V | Insert a PivotTable (ribbon key sequence; may vary by version) | Summarise expenses by category | intermediate |
| Ctrl + Shift + Enter | Enter a legacy array formula | Needed for old array formulas (not for dynamic arrays) | advanced |
| Ctrl + Shift + _ (underscore) | Remove all borders | Clean up a downloaded report | beginner |
No shortcuts match your search.
Shortcuts are for Excel on Windows. Some ribbon key sequences vary by Excel version.