Excel Shortcuts for Accountants: The Ones Worth Learning

The Excel shortcuts for accountants that pay off fastest are the ones you use dozens of times a day: totalling, formatting numbers, moving through long ledgers, pasting values and checking formulas. You don't need hundreds. This guide picks the ones that matter for reconciliations, month-end close and reporting, with both Windows and Mac keys, plus a quick balance check you can try.

Excel shortcuts for accountants: totals and formulas#

These keys build and copy formulas without the mouse, which is most of the work in a schedule or reconciliation.

AutoSum has a trick that saves a lot of time. Select a block of numbers plus one empty row below and one empty column to the right, then press Alt+=. Excel adds row totals, column totals and a grand total in one go. If you press it under a filtered list, Excel writes =SUBTOTAL(9,...) instead of SUM, so hidden rows are left out.

The AutoSum shortcut guide covers more of these tricks, and the SUM function guide explains what SUM does with text and blanks.

Number format shortcuts for financial reports#

Format shortcuts keep reports consistent without opening menus. The most useful for accounts are:

The percent example is a warning: percent format multiplies the display by 100, so use it only on values that are already fractions, like 0.125. The Currency symbol follows your computer's regional settings.

There is no single-key shortcut for the Accounting format, which lines up currency symbols and shows zeros as dashes. Use Ctrl+1 (Mac: ⌘1) and pick Accounting, or the Accounting Number Format button on the Home tab. The formatting shortcuts lesson lets you practise all of these.

Shortcuts for moving through long ledgers#

Navigation shortcuts let you reach the end of a 10,000-row ledger in one keystroke.

Go To Special is a favourite for reviewing workpapers. Press Ctrl+G, click Special, and choose Constants with only Numbers ticked. Excel selects every typed-in number, so a hard-coded figure in a row of formulas stands out. Choose Blanks to find gaps in a list.

Paste Special, filters and visible cells#

These shortcuts handle the copy-and-clean work in reconciliations.

To paste values on Windows, copy, then press Ctrl+Alt+V, V and Enter. This turns formulas into fixed numbers, which is useful before you send a schedule or close a period. The Paste Special values guide shows the other options, such as Transpose and Multiply.

Select visible cells only matters when you hide rows or collapse a grouped outline. Copying a filtered range copies only the rows you see, but copying a range with manually hidden rows also copies the hidden ones. Select the range, press Alt+; (Mac: ⌘⇧Z), then copy.

Shortcuts for checking formulas#

Reviewing someone else's workbook is easier when you can see the formulas.

Ctrl+` is the grave accent key, usually above Tab. Press it once to show formulas in every cell, and again to go back. A column of formulas with one plain number in it is often a quick override someone forgot.

Also use the status bar. Select any cells and the bottom of the window shows their Sum, Average and Count, so you can tie a number to a source without writing a formula. Right-click the status bar to add Min and Max.

More formula keys are in the formula shortcuts guide, and the full Excel keyboard shortcuts cheat sheet has the complete list.

A quick balance check: the divide-by-9 rule#

When debits and credits don't match, a simple formula finds the difference, and the size of the difference gives a clue. Here is a small trial balance:

=SUM(B2:B7)-SUM(C2:C7)

Debits total 18,340 and credits 18,250, so the difference is 90. A difference that divides exactly by 9 often means two digits were swapped. Here, a supplies balance of 1,450 was typed as 1,540. You can test the rule with =MOD(SUM(B2:B7)-SUM(C2:C7),9), which returns 0 when the difference divides by 9. It is a clue, not proof, so check the source documents.

Checks like this come up in accounting job tests. The guide to the Excel test for accountants and the finance Excel mock test show what to expect.

Practise it#

Shortcuts only stick when your fingers learn them. Practise the formatting shortcuts in a live spreadsheet, then build totals in the SUM lesson and move through data with the jump shortcuts lesson. Each lesson checks your work instantly. Then try the trial balance exercise on this page.