Go To Special: The Most Powerful Excel Feature Nobody Taught You

TL;DR: Go To Special (F5 → Special, or Ctrl+G → Special) can instantly select every formula error, every hard-coded number, every blank cell, every data validation dropdown, every conditional formatting rule, and more — across any range or sheet. Tax preparers who learn Go To Special stop manually hunting for things Excel can find in one click. This post covers all 8 options you’ll actually use, with real tax workpaper scenarios for each.

#What Is Go To Special?

Go To Special is a dialog inside Excel’s Go To feature. It selects every cell in the current range (or sheet) that matches a specific condition — all formulas, all errors, all blanks, all visible cells, all conditional formats, and more. It’s been in Excel since at least Excel 97. Most people have never opened it.

How to open it:

Method	Steps
Keyboard (fastest)	F5 → Alt+S
Keyboard alternative	Ctrl+G → Alt+S
Ribbon	Home → Find & Select (far right) → Go To Special

The dialog shows 15+ options. This post covers the 8 options you’ll actually use in tax workpaper prep and review. The others (Objects, Comments, Precedents, Dependents, etc.) have niche uses that don’t justify the mental load.

#Before You Start: The Two Ways to Use Go To Special

Method 1: Select a range first, then Go To Special. If you highlight A1:F200 before opening the dialog, Go To Special only searches within that range. Use this when you know exactly where the problem is.

Method 2: Select one cell, then Go To Special. If you have only A1 selected, Go To Special searches the entire current sheet. Use this when you’re investigating an inherited workbook and don’t know where the problems are.

Pro tip: Ctrl+A (press once) selects the current data region. Ctrl+A (press twice) selects the entire sheet. Use the two-press version to search everything.

---

#The 8 Options You Need — With Tax Workpaper Scenarios

#1. Formulas → Errors: Find Every #REF!, #N/A, #VALUE! Instantly

What it does: Selects every cell in the range/sheet that contains a formula resulting in an error — #REF!, #N/A, #VALUE!, #DIV/0!, #NUM!, #NULL!.

Keyboard-only: F5 → Alt+S → F (Formulas) → E (Errors checkbox only — uncheck Numbers, Text, Logicals if needed) → Enter.

Tax scenario: The partner returned the Henderson M-3 schedule with a sticky note: “Doesn’t foot — check for ref errors.” The M-3 has 200 rows of book-tax adjustments. Somewhere in those 200 rows is a #REF! from a deleted prior-year sheet. You open the M-3 tab. F5 → Alt+S → F → uncheck all except Errors → Enter. Excel highlights 4 cells: two #N/A values from VLOOKUPs with missing lookup entries (expected, fixable), one #DIV/0! from a ratio column with a zero divisor (add an IFERROR wrapper), and one #REF! in cell E147 — the cell that breaks the M-3 footing. Three clicks to find the needle in the haystack.

When to use vs. the macro version: Use Go To Special when you need to find errors on one sheet right now. Use the macro approach when you need to scan every sheet in a 40-tab workbook — running Go To Special on 40 tabs manually is tedious. That’s what the Error Cell Navigator macro is for: it scans every sheet and hyperlinks every error into one report.

What “selects every error cell” actually means: You can now:

• Press Tab to cycle through the selected cells one at a time
• Type a replacement value and Ctrl+Enter to fill all selected cells at once
• Apply a fill color (e.g., bright yellow) to mark all error cells for later review
• Press Delete to clear all error cells (dangerous — use with caution)

#2. Constants: Find Every Hard-Coded Number

What it does: Selects every cell in the range/sheet that contains a constant value (not a formula). You can filter by type: Numbers, Text, Logicals (TRUE/FALSE), Errors.

Keyboard-only: F5 → Alt+S → C (Constants) → uncheck Text and Logicals → Enter.

Tax scenario: You’re reviewing the Henderson state apportionment schedule. The preparer insists the numbers tie to the federal return. But tax preparers are human, and humans type numbers. Go To Special → Constants (Numbers only) selects every hard-coded number on the sheet. In a well-built workpaper, 90% of the numbers should be formulas referencing other sheets. The 10% that are hard-coded are either intentional inputs (tax rates, state-specific amounts, partner-entered adjustments) or errors (a preparer typed 142850 instead of linking to the federal schedule).

Scan the selection. If you see a hard-coded $142,850 in the state taxable income column, trace where it came from. If it’s supposed to link to the federal M-1 line 28, it’s an error. If it’s a state-specific adjustment the partner entered manually, it’s intentional. Go To Special doesn’t tell you which — it just shows you where to look.

When to use vs. the macro version: Use Go To Special for a quick visual scan on one sheet. Use the Hard-Coded Number Detector macro when you want a report of every hard-coded number across every sheet, with cell addresses you can sort and filter. The macro is Go To Special on steroids for multi-sheet workbooks.

#3. Blanks: Select Every Empty Cell in a Range

What it does: Selects every blank cell within the selected range. Does not select cells outside the data region — it works within the bounding box of your selection.

Keyboard-only: F5 → Alt+S → K (Blanks) → Enter.

Tax scenario: You exported a trial balance from the ERP and three columns came through with scattered blanks — account descriptions, department codes, and review status. The blanks aren’t empty; they should say “N/A” or “See PY” or “0”. Select the range. F5 → Alt+S → K → Enter. Every blank cell is selected. Type "N/A" → Ctrl+Enter. Every blank now contains "N/A". The ERP export gap is closed in under five seconds.

The Ctrl+Enter power combo: After Go To Special selects all blanks, type anything once and press Ctrl+Enter (not Enter — Ctrl+Enter fills your entry into every selected cell simultaneously). You can fill with:

• 0 — zero out all blank numeric cells
• "N/A" — mark blank text cells as not applicable
• =A1 — fill blanks with the value from the cell above (use with care)
• "Per TB" — annotate blank source references

Advanced: To fill blanks with the value from the cell above (common for imported data where a category header appears once and then blank rows follow):

1. Select the column.
2. F5 → Alt+S → K → Enter. All blanks selected.
3. Type = and press the Up Arrow (creates a formula like =A2).
4. Ctrl+Enter. Every blank now references the cell above it.

#4. Visible Cells Only: Copy Filtered Data Without Hidden Rows

What it does: After applying a filter, selects only the visible (unfiltered) cells within a selection, excluding hidden rows and columns.

Keyboard-only: Alt+; (this is the only Go To Special option with its own dedicated shortcut). Or F5 → Alt+S → Y (Visible cells only) → Enter.

Tax scenario: The partner wants a list of all journal entries posted in March for the Henderson engagement. You open the JE log (2,000 rows, January through December). Apply a filter for March dates. The log now shows 168 March entries. You select the visible data and press Ctrl+C. Paste into an email. The email shows 2,000 rows — every entry from January through December.

Why? Because Ctrl+C copies everything in the selection, including hidden rows. Excel doesn’t distinguish between visible and hidden cells when you copy unless you tell it to. Alt+; selects only the visible cells within your current selection. Then Ctrl+C copies only those. Then you paste exactly 168 March rows.

The sequence: Apply filter → select range → Alt+; → Ctrl+C → Ctrl+V. Never copy filtered data without Alt+; first. The hidden rows will haunt you — and the partner will wonder why the March JE list includes entries from January.

When you’ll use this: Copying filtered data to an email, a new sheet, a client deliverable. Any time you’ve filtered and you’re about to copy, press Alt+; before Ctrl+C. It becomes automatic after the first time hidden rows embarrass you.

#5. Conditional Formats: Find Every Cell with Formatting Rules Applied

What it does: Selects every cell in the range/sheet that has one or more conditional formatting rules applied.

Keyboard-only: F5 → Alt+S → O (Conditional formats) → Enter.

Tax scenario: You open an inherited workpaper and the trial balance is a rainbow — red cells, green cells, yellow cells, cells with data bars, cells with icon sets showing arrows pointing in three directions. You don’t know which formatting is intentional and which is leftover from three preparers ago. Go To Special → Conditional Formats selects every cell that has a rule applied.

Now you can see the scope of the problem. Maybe the color scale on the amount column is from the prior preparer and you want to remove it. Maybe the icon set on the variance column is from the partner and you need to keep it. Go To Special shows you where the rules are. What you do with them is your call.

When to use vs. the macro version: Use Go To Special to inspect conditional formatting on one sheet. Use the Conditional Formatting Stripper macro to remove all conditional formatting across every sheet in one operation. The macro also gives you a per-sheet count before deleting so you know what you’re losing.

#6. Data Validation: Find Every Cell with Dropdowns or Input Restrictions

What it does: Selects every cell in the range/sheet that has a data validation rule applied — dropdown lists, number ranges, date restrictions, text length limits, custom formulas.

Keyboard-only: F5 → Alt+S → V (Data validation) → Enter.

Tax scenario: You inherit a workpaper and certain cells refuse to accept your input. Cell C12 on the depreciation schedule only allows numbers between 0 and 100 — the prior preparer set it up for a percentage input, but now you need to type “Per IRS table” in that cell and you can’t. Cell B8 on the trial balance has a dropdown listing account types that haven’t been used since 2019. You didn’t create these restrictions, but you’re stuck with them.

Go To Special → Data Validation selects every cell with a restriction. You can now see the scope: three cells on Sched-A, eight on Fixed Assets, two on the state apportionment schedule. Identify them. Decide which to keep, which to remove. (To remove: Data tab → Data Validation → Clear All.)

When to use vs. the macro version: Use Go To Special to find validation cells for inspection. Use the Data Validation Stripper macro to remove all validation across every sheet in one confirmed operation, with a per-sheet report before deletion.

#7. Last Cell: Jump to the End of the Used Range

What it does: Selects the last cell Excel considers “used” on the current sheet — the intersection of the last row and last column with data or formatting.

Keyboard-only: F5 → Alt+S → S (Last cell) → Enter. Or just Ctrl+End.

Tax scenario: You open the Henderson depreciation schedule and press Ctrl+End. Excel jumps to row 48,276. But the schedule ends at row 347. What’s in rows 348 through 48,276? Nothing — but Excel thinks there is, because someone once had data there and deleted it. The sheet’s “last cell” metadata drifted.

This matters because:

• The scroll bar thinks the sheet has 48,276 rows — dragging the scroll thumb sends you flying past your actual data
• Printing the sheet with “Print Active Sheets” might produce 1,200 blank pages
• File size is inflated by formatting in the phantom rows

Go To Special → Last Cell jumps you to row 48,276. You can now see that the cell is blank but has formatting (bold, borders, a number format) or that a value in a far-right column is extending the used range. Delete the excess rows and columns, save, close, and reopen the workbook. The last cell resets.

When to use vs. the macro version: Use Go To Special → Last Cell to find the problem on one sheet. Use the Last Cell Resetter macro to reset every sheet in the workbook automatically. The macro shows before/after addresses so you know what changed.

#8. Row Differences / Column Differences: Find the Cell That Doesn’t Match

What it does: Within a selected row (or rows), selects cells that differ from the comparison cell in each row. Column Differences does the same for columns.

Keyboard-only: F5 → Alt+S → R (Row differences) or M (Column differences) → Enter.

Tax scenario: You have a column of formulas on a fixed asset schedule — each cell calculates current-year depreciation as =D8*E8, =D9*E9, =D10*E10, etc. But one cell in the column is =D11*0.2 — someone hard-coded a rate instead of referencing the rate column. The column formulas appear identical at a glance, but one is different.

Select the entire formula column. F5 → Alt+S → R → Enter. Excel compares every cell in each row to the first cell in that row. If row 1 has =A1*B1 and row 5 has =A5*0.2, row 5 gets selected because its formula pattern differs from row 1. This catches copy-paste errors and manually overridden formulas that break the pattern.

Column Differences for cross-footing: Select a row of subtotals. F5 → Alt+S → M (Column differences). If every subtotal cell should have the same formula pattern but one is a hard-coded number, it gets selected. This is a three-click cross-foot check.

When this is most useful:

• Checking that a column of formulas all follow the same pattern
• Verifying that subtotal rows are consistent across columns
• Finding the one cell in a range where someone typed a number instead of a formula
• Comparing PY to CY column structures — same formulas, different data

---

#The 3-Minute Inherited Workbook Audit

When you receive a workpaper from a preparer and need to understand what you’re dealing with, run this sequence. It takes under three minutes and catches the most common problems before you start your review.

#Step 1: Scan for Errors (30 seconds)

On every sheet with formulas: F5 → Alt+S → F → uncheck all except Errors → Enter.

If errors are selected: apply a yellow fill so they’re visible at a glance. Investigate the #REF! errors first — those are deleted sheets or ranges and usually cause footing problems. #N/A errors are usually VLOOKUPs with missing lookup values — fix the lookup table. #DIV/0! errors need an IFERROR wrapper or a data check.

If no errors are found: move on. This sheet is structurally sound on formulas.

#Step 2: Scan for Hard-Coded Numbers (30 seconds)

On every calculation sheet (schedules, TB, apportionment, M-1/M-3): F5 → Alt+S → C → uncheck Text and Logicals → Enter.

Hard-coded numbers are highlighted. Walk through them visually. Every hard-coded number should have a reason: it’s a tax rate (21%), a state-specific amount, an input the partner entered manually, or a rounding adjustment. If there’s no reason, it’s probably a formula that got pasted as values. Flag it.

#Step 3: Check the Last Cell (10 seconds per sheet)

Ctrl+End on every sheet. If the cursor lands beyond where the data visibly ends, the sheet has stale metadata. Note which sheets are affected. Run the Last Cell Resetter or manually delete excess rows and columns, then save.

#Step 4: Check for Hidden Restrictions (30 seconds)

F5 → Alt+S → V (Data Validation). If cells are selected, the workbook has input restrictions you might trip over during review. Decide whether to keep or remove them.

F5 → Alt+S → O (Conditional Formats). If a rainbow of formatting rules appears, decide which rules are intentional and which are legacy clutter.

#The Full Audit Sequence (Cheat Sheet)

Step	Action	What It Finds
1	F5 → Alt+S → F → Errors → Enter	#REF!, #N/A, #VALUE!, #DIV/0!
2	F5 → Alt+S → C → Numbers → Enter	Hard-coded numbers where formulas should be
3	Ctrl+End	Stale last-cell metadata
4	F5 → Alt+S → V → Enter	Data validation rules
5	F5 → Alt+S → O → Enter	Conditional formatting rules

Run this on every sheet of an inherited workbook before you start your review. Three minutes of keystrokes saves 30 minutes of clicking through cells one at a time wondering why numbers don’t tie.

---

#Go To Special vs. Macros: When to Use Which

This blog has macros that do what Go To Special does, plus more. Here’s when to use one vs. the other:

Task	Use Go To Special When…	Use the Macro When…
Find errors	You’re on one sheet	You need to scan every sheet and get a hyperlinked report
Find hard-coded numbers	Quick visual scan on one sheet	You want a sortable report across all sheets
Find blanks	Filling blanks in a known range	N/A — Go To Special is the right tool
Copy filtered data	Alt+; before every copy	N/A — Alt+; is the right tool
Find validation rules	Inspecting before manual removal	Removing all validation across all sheets at once
Find conditional formats	Inspecting rule scope on one sheet	Removing all conditional formatting across all sheets
Reset last cell	Fixing one sheet manually	Fixing every sheet in the workbook automatically
Row/column differences	Spot-checking formula consistency	N/A — Go To Special is the right tool

The principle: Go To Special is fast, manual, and interactive — best for live investigation on the sheet you’re looking at. Macros are automated, batch, and report-generating — best for scanning every sheet, producing documentation, and performing operations that need confirmation gates before changing data.

Use both. Go To Special during your review workflow. Macros when you need to batch-process or document.

#Pro Tips

#Master the Keyboard Paths

The mouse is fine when you’re learning. But Go To Special rewards keyboard fluency — each option has a letter shortcut that works in the dialog. Focus on learning the five you’ll use most:

Shortcut	Result
F5 → Alt+S → F → E → Enter	Select all formula errors
F5 → Alt+S → C → N → Enter	Select all constant numbers
F5 → Alt+S → K → Enter	Select all blanks
Alt+;	Select visible cells only
F5 → Alt+S → S → Enter	Jump to last cell

#You Can Stack Selections with the Dialog

Within the Formulas and Constants options, you can select multiple types at once. For formulas: check Numbers AND Text AND Logicals AND Errors to select all formulas regardless of their result. For constants: check Numbers AND Text to select all hard-coded values regardless of type. The dialog remembers your last selection — if you always search for formula errors only, it’ll default to that next time.

#Combine Go To Special with Ctrl+Enter for Batch Editing

After Go To Special selects a group of cells, Ctrl+Enter fills your entry into every selected cell simultaneously. The most powerful combinations:

• Select blanks → type 0 → Ctrl+Enter: Fill all blanks with zero
• Select errors → type "CHECK" → Ctrl+Enter: Mark all error cells for review (but this replaces the formula, so do it on a copy)
• Select constants → apply yellow fill: Highlight all hard-coded numbers for visual review
• Select conditional formats → Home → Conditional Formatting → Clear Rules → Clear Rules from Selected Cells: Remove conditional formatting from just those cells

#Use with Named Ranges for Repeated Audits

If you audit the same workbook structure repeatedly (monthly TB, quarterly fixed asset schedule), set up named ranges for the areas you always check. Then select the named range before running Go To Special — the search is limited to that range, making it faster and preventing false positives in header rows or summary sections.

#Teach Your Team the Two Most Important Ones

If you teach a new staff accountant nothing else about Go To Special, teach them:

1. F5 → Alt+S → F → E → Enter — Select all formula errors. This catches the #REF! before it gets to the partner.
2. Alt+; — Select visible cells only. This prevents hidden rows from sneaking into client deliverables.

Those two shortcuts alone eliminate the two most common errors in tax workpaper prep: formula errors going undetected and hidden data contaminating exports.

#Adapt It