Formula Errors

Find and Remove an Unknown Equals Sign in Excel

Maira MehtabMaira Mehtab Nov 18, 2026 869 views

Question details

The user needs to locate an unknown equals sign that starts a formula and remove or correct it.

How to Find and Remove an Unknown Equals Sign in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants to identify the cell containing an unwanted formula in a worksheet or workbook.
Observed behavior
An equals sign starts a formula somewhere in the worksheet, but its location is unknown.
Before you start

Open the affected workbook and decide whether to search the current sheet or the entire workbook. Remember that valid Excel formulas also begin with an equals sign, so review matches before editing them.

Solution 1Recommended

Find and inspect formulas containing an equals sign in Excel

Search formula content to locate candidate cells, then correct the unwanted entry.

1
Open Find

In Excel, open the affected workbook and press Ctrl+F, or select Home > Find & Select > Find.

2
Set the search options

Enter = in the Find what box, select Options, and set Within to Sheet or Workbook. Set Look in to Formulas.

3
Review the matches

Select Find All, then select each result to inspect its cell and formula bar. Valid formulas may appear in the results too.

4
Correct the unwanted entry

Select the affected cell and edit it in the formula bar. Remove the accidental equals sign or correct the formula, then press Enter.

Find and inspect formulas containing an equals sign in Excel
Keep valid formulas intact: Removing the leading equals sign from a valid formula stops Excel from calculating it. If the entry should be displayed as text, enter an apostrophe before the equals sign instead.
Find formulas in WPS Spreadsheets

Find and correct an unwanted equals sign in WPS Spreadsheets

Open the workbook in WPS Spreadsheets, search for the equals sign, and inspect matching cells before correcting the unwanted entry.

  1. 1. Open the workbook: Open WPS Spreadsheets and select Open to load your Excel workbook.
  2. 2. Search for the sign: Press Ctrl+F and enter = in the Find box. If search options are available, choose to look in formulas and select the appropriate sheet or workbook scope.
  3. 3. Inspect matching cells: Select Find All or Find Next, then review each matching cell and its formula bar to identify the unwanted entry.
  4. 4. Edit the entry: Select the affected cell, remove the accidental equals sign or correct the formula in the formula bar, and press Enter.
Search workbook cells for an unwanted equals signOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceWork with a free Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

How do I search every sheet in an Excel workbook?

Press Ctrl+F, select Options, and set Within to Workbook. Enter =, set Look in to Formulas, and select Find All.

Why does searching for an equals sign return so many cells?

Excel formulas normally begin with =, so valid formulas can appear in the results. Select each result and check the formula bar before making changes.

How can I show an equals sign as text instead of starting a formula?

In the cell or formula bar, type an apostrophe before the equals sign, such as '=example, and press Enter. The cell displays the entry as text.

Can I search for the equals sign in WPS Spreadsheets?

Yes. Open the workbook in WPS Spreadsheets, press Ctrl+F, and search for =. Review the matching cells in the formula bar before editing them.