Find and Remove an Unknown Equals Sign in Excel
Question details
The user needs to locate an unknown equals sign that starts a formula and remove or correct it.

- 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.
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.
Find and inspect formulas containing an equals sign in Excel
Search formula content to locate candidate cells, then correct the unwanted entry.
In Excel, open the affected workbook and press Ctrl+F, or select Home > Find & Select > Find.
Enter = in the Find what box, select Options, and set Within to Sheet or Workbook. Set Look in to Formulas.
Select Find All, then select each result to inspect its cell and formula bar. Valid formulas may appear in the results too.
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 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. Open the workbook: Open WPS Spreadsheets and select Open to load your Excel workbook.
- 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. Inspect matching cells: Select Find All or Find Next, then review each matching cell and its formula bar to identify the unwanted entry.
- 4. Edit the entry: Select the affected cell, remove the accidental equals sign or correct the formula in the formula bar, and press Enter.

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.




