Find, Replace, and Select Cells in Excel

Excel’s Find & Select tools solve four related but different problems. Find locates text, numbers, formulas, or formatting. Replace changes matching cell content. Go To jumps directly to a cell or range. Go To Special selects cells that share a property, such as formulas, blanks, or data validation.

The key is to define the scope before running the command. A precise search can save minutes; an unrestricted replacement can change cells you never intended to touch.

The menu paths and shortcuts in this guide use current desktop Excel for Windows. Find and Replace are also available on Mac and the web, but their interfaces and some advanced options differ. Microsoft documents Go To Special primarily for desktop Excel on Windows.

Choose the tool that matches the task

All four commands are also available from Home > Editing > Find & Select. The shortcuts are usually faster once you know which command you need.

Find text, numbers, or formulas

Use Find when you need to inspect matches without changing them. For example, you might locate every occurrence of a product code, find formulas that refer to a particular worksheet, or search a workbook for an outdated label.

1. To limit the search, select the relevant range first. Otherwise, select a single cell.
2. Press Ctrl+F.
3. Enter the text, number, or pattern in Find what.
4. Select Find Next to move through matches one at a time, or Find All to list them together.
5. Select a result to move to its cell.

The Find All command lists every cell containing "Pending" and lets you jump directly to each match in the worksheet.

Find Next is useful when context matters and you want to review one cell at a time. Find All is better for auditing because the results list shows every match in the current scope. You can select a result to activate its cell and sort the list by a column heading.

Microsoft’s Find and Replace guide documents the current search controls for Windows, Mac, and the web.

Refine a search with Options

If a simple search returns too much—or nothing at all—open Options >> in the Find and Replace dialog. These settings determine where Excel searches and what counts as a match.

Enable Match entire cell contents to find only exact matches like North and exclude partial matches such as Northwest or Northeast.

Search settings can explain surprising results. Before deciding that data is missing, check the selected range, the Within scope, Look in, case matching, whole-cell matching, and any active format criterion.

Find cells by formatting alone

Leave Find what empty, open the Format menu, and choose the formatting to locate. You can define it manually or use Choose Format From Cell and select a cell that already has the desired appearance. This is useful for finding stray fills, inconsistent number formats, or manually highlighted cells.

Search patterns with wildcards

Wildcards let one search term match several possible strings. Excel supports three wildcard symbols in Find and Replace:

The wildcard pattern INV-* finds all reference codes that start with INV- when Match entire cell contents is enabled.

Test a wildcard pattern with Find All before using it in Replace. A broad pattern such as *old* may match more cells—or more of each cell’s content—than you expect.

Replace data without changing the wrong cells

Replace edits cell content, so scope matters more than speed. A safe approach is to confirm a few matches individually before running a bulk replacement.

1. Select only the range that should be eligible for the change, if practical.
2. Press Ctrl+H.
3. Enter the current content in Find what and the new content in Replace with.
4. Open Options >> and confirm the scope, case setting, whole-cell setting, and any format criteria.
5. Select Find Next, inspect the cell, and use Replace for the first few correct matches.
6. Use Replace All only when every remaining match should receive the same change.
7. Review the confirmation and inspect the affected area.

Use Replace to prepare a text change, then review the first match before replacing values in the selected worksheet.

Replace All changes every match in the active scope. For an important workbook, save a copy first. If the result is wrong, use Ctrl+Z immediately and refine the search.

On the Replace tab, Excel searches cell formulas—the content stored in each cell—rather than offering the Find tab’s separate Values, Notes, and Comments choices. That distinction matters when a displayed result comes from a formula.

Replace formatting without replacing content

The two Format controls on the Replace tab let you find one format and apply another. Leave the text boxes empty when the formatting itself is the only criterion. This can standardize an incorrect number format or remove an inconsistent visual treatment without rewriting cell values.

Jump directly to a cell with Go To

Use Go To when you know the destination. Press Ctrl+G or F5, enter a reference such as G250 or a defined name, and select OK. Excel activates that location without requiring you to scroll through the sheet.

For a more selective task, open the same dialog and choose Special.

Select cells by condition with Go To Special

Go To Special does not search for a word. It selects cells that meet a structural condition. Start with a selected range when you want to limit the result; otherwise, a single active cell makes the whole worksheet the search area.

1. Select the range, rows, or columns you want to inspect, or select one cell to use the entire worksheet.
2. Press Ctrl+G and choose Special.
3. Select a condition, such as Formulas, Blanks, or Visible cells only.
4. Choose any available sub-options, then select OK.
5. Apply the intended action to the selected cells, or select any single cell to cancel the selection.

Go To Special can select all cells containing formulas in a chosen range, making them easier to review or format together.

Microsoft’s Go To Special reference lists the available conditions and explains how the active cell affects row and column comparisons.

Fill selected blanks carefully

After choosing Blanks, type a value or formula and press Ctrl+Enter to place the entry in every selected blank cell. Use this only inside a deliberately selected data area. Empty cells can be meaningful, and filling every blank across a large range may alter the structure of the sheet. Microsoft’s Excel shortcut reference documents Ctrl+Enter as the command that fills the selected range with the current entry.

Copy only cells that are visible

When rows or columns are hidden, a normal copy can include them. Select the source range, open Go To Special, choose Visible cells only, and then copy. Microsoft notes that this desktop option is not available for an ordinary range in Excel for the web, although filtered Excel tables behave differently. See the visible-cells guide for the platform details.

Use Go To Special and choose Visible cells only to select the displayed cells while excluding hidden rows from the selection.

Troubleshoot searches that do not behave as expected

Excel Find & Select questions

Search narrowly, then act

Start by choosing the tool that matches the job: Find to inspect, Replace to edit, Go To to navigate, or Go To Special to build a selection. Define the range and options before changing anything, preview broad searches with Find All, and treat Replace All as the final step rather than the first. That small discipline makes Excel’s search tools both faster and safer.