Excel for accountants

Excel shortcuts

60 Windows shortcuts, each with a real accounting use case. One new Short every day.

KeysWhat it doesUse it forLevel
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

Shortcuts are for Excel on Windows. Some ribbon key sequences vary by Excel version.