Why Go To Special Says “No Cells Were Found” in Excel
Question details
The user needs to know why Go To Special > Constants reports “No cells were found” and how to select constants, clear reusable inputs, or keep formula results.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is trying to isolate or clear constant cells while reusing a spreadsheet without deleting formulas.
- Observed behavior
- Go To Special > Constants returns “No cells were found” because the selected range contains only formulas, not typed values.
Before using Go To Special, select only the range you want to search. In Excel and WPS Office, Constants means typed values, not formula results.
Select Cells That Contain Typed Values with Go To Special
Use this method when you need to identify constants in a range and highlight or format only manually entered values.
In spreadsheet terminology, a constant is a value typed directly into a cell. Formula results are calculated values and are not constants, which is why Go To Special reports no cells found when the selection contains only formulas.
Open the workbook in WPS Office Spreadsheets and select the cells, column, or table range you want to check.
Click Home > Find & Select > Go To Special.
In the Go To Special dialog, select Constants, then click OK. Only the cells containing typed values will be selected.
Clear Reusable Input Cells Without Removing Formulas
Use this method when you want to reset a working spreadsheet by deleting only the values that formulas depend on.
Remove Formulas but Keep the Displayed Results
Use this method when you need to finalize a report or dataset so the current values remain and the formulas are removed.
Find Constants and Manage Formula Cells in WPS Office
Open your Excel file in WPS Office Spreadsheets and use Home > Find & Select > Go To Special to select constants, clear input cells while preserving formulas, or paste values to keep results.
- 1. Open your file in WPS Office: Download WPS Office, install it, and open your existing Excel workbook in WPS Office Spreadsheets.
- 2. Run Go To Special: Select the range, click Home > Find & Select > Go To Special, choose Constants, and click OK.
- 3. Clear reusable fields only: Select the input cells that formulas reference and press Delete to clear values without removing formulas.
- 4. Keep results with Paste Special: To remove formulas but keep displayed results, copy the range and click Home > Paste > Paste Special > Values.
Frequently Asked Questions
Why do I get “No cells were found” when I choose Constants?
Because Go To Special > Constants only finds cells that contain values typed directly into the sheet. If the selected range contains formulas only, there are no constants to select.
How do I select all cells that contain typed values instead of formulas?
Click Home > Find & Select > Go To Special, choose Constants, and click OK. WPS Office Spreadsheets and Excel use the same command.
Can I clear a spreadsheet for reuse without deleting formulas?
Yes. Clear the input cells that formulas reference, not the formula cells. Select those input cells and press Delete; the formulas stay and recalculate.
How do I remove formulas but keep the current calculated results?
Copy the formula range, then use Home > Paste > Paste Special > Values. This replaces the formulas with their displayed values.
Does WPS Office support Excel's Go To Special feature?
Yes. WPS Office Spreadsheets includes Go To Special and Paste Special under the Home ribbon, so you can work with Excel-compatible files without an Office 365 subscription.
