15 Excel Keyboard Shortcuts That Will Save You Hours This Tax Season

TL;DR: Every mouse click costs you ~2 seconds. Tax preparers working 40+ hours a week in Excel make thousands of clicks per day. These 15 keyboard shortcuts replace the most common clicks — tracing formulas, navigating sheets, selecting special cells, and formatting — with single keystrokes. Learn five today, five next week, five the week after. By the end of the month, you’ll wonder why you ever used the ribbon.

The Problem

You’re reviewing the Henderson 1120S workpapers. The trial balance doesn’t foot, and you can’t figure out why. You click on a suspect cell in the M-1 schedule, then click the Formulas tab, then click Trace Precedents, then click Remove Arrows when the arrows point to the wrong thing. Then you click the next cell and do it again. Three mouse clicks per cell, 40 minutes of review time, and your wrists hurt.

Meanwhile, the senior in the next cube hasn’t touched his mouse in 20 minutes. His left hand is on the keyboard. His right hand is on the keyboard. His screen is flashing through formula arrows faster than you can follow. He’s not a developer — he’s a tax preparer who learned the shortcuts. And he’s going home at 6:00 PM.

#How This Post Works

Each shortcut below has:

The keystroke — what you press
What it does — in plain English
A tax workpaper scenario — a real situation where this saves you time
When to use it — the specific moment in your workflow

Don’t try to learn all 15 at once. Pick the three that would have saved you time today and use them tomorrow. Come back next week for three more.

#1. Ctrl+` — Toggle Formula View

What it does: Shows every formula in every cell instead of the result. Press it again to switch back.

Tax scenario: You inherit the Henderson depreciation schedule. Cell D47 says $142,850 but you need to know why. Is it a SUM? A VLOOKUP? A hard-coded number? Ctrl+shows you the formula=SUM(D8:D46)or=VLOOKUP(A47,Rates,3,FALSE)or — the one you're hoping not to find —142850`. Three seconds instead of clicking into each cell or the formula bar.

When to use it: First thing you do when opening an inherited workpaper. Toggle formulas on, scan for hard-coded numbers (they stand out — no equals sign), toggle formulas off. This alone catches more errors than a 30-minute manual review.

#2. Ctrl+[ — Trace Precedents (Jump to Source)

What it does: If you’re on a cell with a formula, Ctrl+[ selects every cell that feeds into that formula — on the same sheet. If the precedent is on a different sheet, it opens that sheet and selects the precedent cell.

Tax scenario: The M-1 schedule cell E23 says $47,300. You trace precedents with Ctrl+[. Excel jumps to cell C17 on the same sheet — a hard-coded $47,300. No formula. No source. That’s the number the preparer typed manually, and now you have to figure out where it came from. Ctrl+[ didn’t find the source, but it did find the absence of a source — which is just as valuable.

When to use it: Reviewing any schedule where numbers feed into other schedules. M-1 to taxable income, state apportionment to return, depreciation schedule to fixed asset summary. If the trail goes cold at a hard-coded number, you have your answer — and your review note.

#3. F5 → Special → Formulas → Errors — Select Every Error Cell

What it does: Opens the Go To dialog. Click Special, choose Formulas, check only Errors, hit OK. Excel selects every cell in the current sheet that contains a formula error — #REF!, #N/A, #VALUE!, #DIV/0!, #NUM!, #NULL!.

Tax scenario: A partner sent back the Henderson return with a note: “M-3 doesn’t foot.” You open the M-3 schedule. Somewhere in 200 rows of adjustments is a #REF! from a deleted sheet. F5 → Special → Formulas → Errors selects all error cells at once. You see three cells highlighted — two #N/As from missing lookups (expected, fixable) and one #REF! from a deleted prior-year reference (the problem). Three seconds to find what would have taken 10 minutes of scrolling.

When to use it: Before every review cycle. Open the workpaper. F5 → Special → Formulas → Errors on every sheet with formulas. Clear the errors you expect, investigate the ones you don’t.

Keyboard-only version: F5 → Alt+S → F → E → Enter. Six keystrokes without touching the mouse.

#4. Ctrl+PageDown / Ctrl+PageUp — Switch Between Sheets

What it does: Ctrl+PageDown moves to the next sheet tab. Ctrl+PageUp moves to the previous sheet tab.

Tax scenario: You’re comparing the current-year depreciation schedule (tab 14) to the prior-year schedule (tab 15). Ctrl+PageDown flips to PY. Ctrl+PageUp flips back to CY. No reaching for the mouse to click tiny tabs. Your eyes stay on the screen. Your brain stays in comparison mode.

When to use it: Any time you’re comparing two adjacent sheets. Trial balance to adjusting journal entries. State apportionment to federal return. Current year to prior year. This shortcut alone saves 10–15 minutes per day for tax preparers who work across multi-tab workbooks.

#5. Ctrl+Shift+L — Toggle AutoFilter

What it does: Applies or removes AutoFilter dropdown arrows on the current data range. If filters are already applied, it clears them and removes the arrows. If no filter is applied, it adds the dropdown arrows to every column.

Tax scenario: You filtered the trial balance to show only expense accounts (account codes 50000–59999) for your review. Now you need to see all accounts again. Instead of clicking the filter dropdown, scrolling to “Select All,” and hitting OK — Ctrl+Shift+L clears every filter on every column in one keystroke. Your data is fully visible again.

When to use it: After every filtered review session. Clear filters before passing the workbook to the reviewer so they don’t think half the data is missing. (If the workbook has leftover filters and you don’t know where, run the Filter Remover macro.)

#6. F4 — Repeat Last Action

What it does: Repeats whatever you just did. Inserted a row? F4 inserts another row. Deleted a column? F4 deletes the next column. Applied yellow fill to a cell? F4 applies yellow fill to the next cell. Changed font to bold? F4 bolds the next selection.

Tax scenario: You’re formatting a fixed asset schedule. You insert a row between two asset groups to create visual separation. F4. Another row. F4. Another row. Instead of right-click → Insert six times, it’s Insert once then F4, F4, F4, F4, F4. Five keystrokes instead of thirty clicks.

When to use it: Batch formatting, batch row insertion, batch deletion. Any repetitive action you catch yourself doing more than twice — stop after the second one and try F4 for the third.

#7. Alt+; — Select Visible Cells Only

What it does: Selects only the visible cells within a selection, excluding hidden rows and columns. Critical when copying filtered data.

Tax scenario: You filtered the journal entry log to show only entries posted in March. You need to copy the JE numbers and amounts to an email for the partner. If you select the range and press Ctrl+C, Excel copies everything — including the hidden rows for January, February, and April through December. You paste into the email and get 2,000 rows instead of 300. Alt+; selects only the visible March rows. Then Ctrl+C copies just those. Then you paste exactly what the partner needs.

When to use it: Every time you copy from a filtered range. Never copy filtered data without Alt+; first. The hidden rows will haunt you.

#8. Ctrl+Enter — Fill Selected Range

What it does: Enters the same value or formula into every cell in the current selection. Type once, Ctrl+Enter, and every selected cell gets the same thing.

Tax scenario: You need to mark 50 rows in the trial balance as “Reviewed” with a column of checkmarks. Select the range D2:D51, type ”✓”, Ctrl+Enter. Every cell in the range now contains ”✓”. No dragging the fill handle. No copy-pasting.

When to use it: Filling status columns (“Reviewed,” “N/A,” “Per TB”), applying the same formula to a column of blank cells, or clearing a range with a single value.

Advanced use — filling blanks in a mixed range: F5 → Special → Blanks (selects all blank cells). Type 0 → Ctrl+Enter. Every blank cell in the selected range now contains zero. Two keystrokes to fill hundreds of scattered blanks.

#9. Alt+E+S+V — Paste Special → Values

What it does: Pastes only the values from the clipboard, stripping out formulas, formatting, and links.

Tax scenario: You built a summary schedule with formulas referencing three different sheets. The partner wants a clean version to send to the client — no formulas, no links, just numbers. Select the summary range, Ctrl+C to copy, Alt+E+S+V to paste values over the top, Enter. All formulas become hard-coded numbers. No cutting, no pasting to a new sheet, no Save As → CSV. Three keystrokes.

When to use it: Before sending any workpaper to a client. Before archiving a completed engagement. Before handing a file to someone outside your firm. Paste values strips every formula, every link, every external reference. The recipient sees numbers, not your internal workpaper architecture.

Alternative: Right-click → Paste Special → Values. Same result, but the keyboard sequence is faster once you learn it. Alt+E+S opens the Paste Special dialog. V selects Values. Enter confirms.

#10. Ctrl+Space / Shift+Space — Select Entire Column / Row

What it does: Ctrl+Space selects the entire column of the active cell. Shift+Space selects the entire row.

Tax scenario: You need to format the entire Account Code column on the trial balance as text (so leading zeros don’t disappear). Click anywhere in column A → Ctrl+Space selects the entire column → Ctrl+1 opens Format Cells → Text → OK. Two keystrokes to select a column that could be 10,000 rows deep.

When to use it: Column-wide formatting (number format, text format, date format), row-wide formatting (bold totals row, border on subtotal rows), or inserting/deleting columns and rows.

#11. Alt+H+O+I — Auto-Fit Column Width

What it does: Adjusts the selected column’s width to fit the widest cell content.

Tax scenario: You just exported a trial balance from the ERP. Every column is 8.43 characters wide. Account descriptions (“Accumulated Depreciation — Buildings — Henderson Project Phase III”) are truncated to “Ac…”. Instead of manually dragging every column border: select all columns (Ctrl+A twice if the data is a contiguous range, or click the corner between row 1 and column A to select the entire sheet) → Alt+H+O+I auto-fits every column to its content.

When to use it: Every time you import data from an external source. CSV exports, ERP dumps, bank statement downloads. All of them produce narrow columns. Alt+H+O+I fixes the entire sheet in one sequence.

Related: Alt+H+O+A auto-fits row height. Useful when you’ve wrapped text in a cell and the row height didn’t adjust.

#12. Ctrl+1 — Format Cells Dialog

What it does: Opens the Format Cells dialog for whatever is currently selected. Every formatting option in Excel — number format, alignment, font, border, fill, protection — is in this one dialog.

Tax scenario: The trial balance amounts need to display as currency with parentheses for negatives, two decimal places, and a comma separator. Select the amount column → Ctrl+1 → Number tab → Currency → Decimal places: 2 → Symbol: $ → Negative numbers: ($1,234.10) → OK. Every number formatting option in one dialog. No hunting through the ribbon’s Number section for the tiny dropdown arrow.

When to use it: Any time you need to change how numbers, dates, or text appear. Ctrl+1 is the universal “format this” command. Learn it once, use it everywhere.

#13. Ctrl+Home / Ctrl+End — Jump to Start / End

What it does: Ctrl+Home jumps to cell A1. Ctrl+End jumps to the last cell Excel considers “used” on the current sheet.

Tax scenario: You’re reviewing a depreciation schedule. The preparer tells you the total cost basis is in the last row. Instead of scrolling — and scrolling — and scrolling — Ctrl+End jumps you to row 847 (or wherever the data ends). You’re at the totals row in one keystroke. Then Ctrl+Home to return to the top.

When to use it: Getting your bearings on a large sheet. Check the totals (Ctrl+End), check the column headers (Ctrl+Home), then navigate to the section you need. Works on any sheet with contiguous data.

Pro tip: If Ctrl+End jumps to row 65,536 (or 1,048,576 in newer Excel) but your data ends at row 200, the sheet’s “last cell” metadata is stale. Run the Last Cell Resetter macro to fix it.

#14. Shift+F11 — Insert New Worksheet

What it does: Inserts a new blank worksheet before the currently active sheet.

Tax scenario: You’re building a workpaper and need a scratch sheet for interim calculations. Shift+F11 inserts a new tab. Double-click the tab name, type “Scratch,” Enter. You’re working in under two seconds. No right-clicking the tab bar, no navigating the Insert dialog, no choosing “Worksheet” from a list of options.

When to use it: Any time you need a temporary workspace. Scratch calculations, pivot tables, filtered extracts. The tab is disposable — delete it when you’re done. But Shift+F11 means you never hesitate to create one.

#15. F2 — Edit Cell (Toggle Between Edit and Enter Mode)

What it does: Puts the active cell into edit mode with the cursor at the end of the formula. Press F2 again to toggle to Enter mode (where arrow keys move between cells instead of within the formula). Press Escape to cancel editing.

Tax scenario: You need to modify a VLOOKUP formula to reference a different column index. Instead of clicking into the formula bar, squinting at the tiny font, and trying to place your cursor precisely between two parentheses — F2 drops you into the cell at the end of the formula. Arrow keys move through the formula. Make your edit. Enter.

When to use it: Any time you need to edit a formula. F2 gets you into the cell faster than clicking the formula bar, and it keeps your hands on the keyboard.

Bonus — F2 to check which cells a formula references: When you press F2 on a cell with a formula, Excel highlights every cell referenced in the formula with colored borders. Blue border = first reference, green = second, purple = third, etc. This lets you see exactly which cells feed into the formula without running Trace Precedents. Press Escape to exit without changing anything.

#Pro Tips: Combine These for More Speed

#The Review Sequence

When you inherit a workpaper and need to understand it in under 5 minutes:

Ctrl+` — toggle formulas on. Scan for hard-coded numbers (no equals sign). Toggle off.
F5 → Special → Formulas → Errors — find every #REF!, #N/A, #VALUE! in the sheet. Investigate.
Ctrl+End — jump to the bottom. Check if the totals row is actually a formula or hard-coded. If Ctrl+End goes past the real data, the sheet has stale metadata — run the Last Cell Resetter.
Ctrl+PageDown through every sheet. Does each one have data? Hidden rows? Use Ctrl+Shift+L to add filters and check.

This sequence takes under 5 minutes and catches the three most common workpaper issues: hard-coded numbers where formulas should be, formula errors hiding in plain sight, and stale sheet metadata.

#The Clean-Before-Sending Sequence

Before you send a workpaper to a client or partner:

**Ctrl+** — toggle formulas on. If any internal notes are in formulas (=“See Henderson M-1 adjustment”`), flag them.
Alt+E+S+V on every summary sheet — paste values to strip formulas and links. If you want to keep formulas, at least check for external links with the External Link Reporter macro.
Ctrl+Shift+L on every filtered sheet — clear all filters so the recipient sees the full data.
Ctrl+End on every sheet — verify the last cell is where you think it is. If not, it means there’s data or formatting in cells the recipient will scroll to and wonder about.

#The Cross-Check Sequence

When two schedules are supposed to agree and they don’t:

Ctrl+[ on the suspect number to find its source.
F2 on the source cell to see exactly which cells it references (colored borders show the references visually).
Ctrl+` to see if the reference is a formula or hard-coded.
Ctrl+PageDown / Ctrl+PageUp to flip between the two schedules and spot the discrepancy.

Put your five most-used commands on the Quick Access Toolbar (QAT) — the tiny toolbar above or below the ribbon. Each position becomes Alt+1, Alt+2, Alt+3, etc.

Recommended QAT setup for tax work:

Save (Alt+1) — most-used command. One key.
Save As (Alt+2) — for timestamped copies before destructive changes.
Quick Print (Alt+3) — print active sheet without dialog.
Print Preview (Alt+4) — check before printing.
Spell Check (Alt+5) — last line of defense before partner review.

To set this up: click the dropdown arrow at the end of the QAT → More Commands → add the commands from the list. Right-click any ribbon command and choose “Add to Quick Access Toolbar” for commands not in the default list.

#Use the Macro Dialog as a Shortcut Hub

If you’ve been adding macros from this blog to your Personal Macro Workbook, Alt+F8 opens the Macro dialog. But you can go further:

Select any macro in the list → Options → assign a shortcut key (e.g., Ctrl+Shift+U for Unhide All Sheets).
Now your most-used macros are keyboard shortcuts too.

Macros + keyboard shortcuts + QAT = you stop reaching for the mouse entirely during review cycles.

#Learn in Batches of Five

Don’t try to memorize all 15 shortcuts at once. Your muscle memory won’t retain them. Instead:

Week 1: Ctrl+` , Ctrl+[ , F5→Special→Errors, Ctrl+PageDown, Ctrl+Shift+L
Week 2: F4, Alt+;, Ctrl+Enter, Alt+E+S+V, Ctrl+Space
Week 3: Alt+H+O+I, Ctrl+1, Ctrl+Home/End, Shift+F11, F2

Each week, tape a sticky note with the five shortcuts to your monitor. When you catch yourself reaching for the mouse to do one of these operations, stop. Use the shortcut instead. After a week, it’ll be automatic.

#When a Shortcut Doesn’t Exist — That’s What Macros Are For

Some things in Excel genuinely have no keyboard shortcut. There is no “Unhide All Sheets” keystroke. No “Find All #REF! Errors Across Every Sheet” keystroke. No “Compare Two Trial Balances” keystroke. These are operations that require multiple clicks through multiple dialogs — or a macro.

Every macro on this blog is a keyboard shortcut waiting to happen. Paste the macro into your Personal Macro Workbook. Assign it a shortcut key via Alt+F8 → Options. Now you have a keystroke for something Excel can’t do natively.

Start here: Unhide All Sheets — 10 lines of VBA that replaces three clicks per hidden sheet. Assign Ctrl+Shift+U and you’ll use it every time you open an inherited workbook. From there, try Find and Replace Across All Sheets (Ctrl+Shift+F), Strip External Links (Ctrl+Shift+X), and Auto Table of Contents (Ctrl+Shift+T).