How to Fix 'No Cells Were Found' in Excel Go To Special
Question details
The user needs to understand why Excel or WPS Office Spreadsheets shows 'No cells were found' when using Go To Special > Current Array and how to select the intended range correctly.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- While selecting cells with Go To Special, the user chose Current Array but the active cell is not part of a legacy array formula, so the dialog displays an error.
- Observed behavior
- Excel or WPS Office Spreadsheets displays 'No cells were found' when Go To Special is used with Current Array because the active cell is not part of an array formula entered with Ctrl+Shift+Enter.
Before using Go To Special, click the cell that contains the data you want to base the selection on. If you need to select an array formula range, confirm the active cell is part of a Ctrl+Shift+Enter array formula.
Select the Current Region Instead of Current Array
Use this when you want to select the contiguous rectangular data range around the active cell without requiring an array formula.
The 'No cells were found' message appears because Current Array only targets legacy array formula ranges. Current Region is the correct Go To Special option for ordinary contiguous data ranges.
In WPS Office Spreadsheets or Excel, click Home > Find & Select > Go To Special. You can also press Ctrl+G and then click Special.
In the Go To Special dialog, select Current Region, then click OK. WPS or Excel selects the contiguous rectangular range around the active cell.
Check that the highlighted range covers the intended data block before applying formatting, copying, or editing.
Use Current Array Only for Ctrl+Shift+Enter Array Formulas
Use this when the active cell is part of a legacy array formula and you need to select the full array range.
Resolve the 'No Cells Were Found' Error with WPS Office Spreadsheets
Use the Current Region option in WPS Office Spreadsheets to select the contiguous range around the active cell and avoid the 'No cells were found' message caused by Current Array.
- 1. Open the workbook in WPS Office Spreadsheets: Launch WPS Office Spreadsheets and open the Excel workbook (.xlsx or .xls) that shows the issue.
- 2. Click the cell inside the data range: Select the active cell that belongs to the contiguous data range you want to highlight.
- 3. Open Go To Special: Click Home > Find & Select > Go To Special, or press Ctrl+G and then click Special.
- 4. Choose Current Region: In the Go To Special dialog, select Current Region and click OK. WPS Office Spreadsheets highlights the rectangular range around the active cell.
- 5. Continue editing: Apply formatting, copy the selection, or perform other actions on the selected range without seeing the 'No cells were found' message.
Frequently Asked Questions
Why does Excel say 'No cells were found' when I choose Current Array?
Current Array only works when the active cell is part of an array formula entered with Ctrl+Shift+Enter. If the cell does not contain an array formula, Excel or WPS cannot find an array range to select.
How do I select the contiguous data range around a cell in WPS Office?
Click the cell inside the range, then go to Home > Find & Select > Go To Special > Current Region. WPS Office Spreadsheets selects the contiguous rectangular data area around the active cell.
Does WPS Office have the same Go To Special options as Microsoft Excel?
Yes. WPS Office Spreadsheets includes Find & Select > Go To Special with options such as Current Region and Current Array, and it supports Excel .xlsx and .xls files.
How can I tell if a cell contains a legacy array formula?
Select the cell and look at the Formula Bar. Legacy array formulas entered with Ctrl+Shift+Enter are enclosed in curly braces, such as {=SUM(A1:A5*B1:B5)}.
What is the difference between Current Array and Current Region in Go To Special?
Current Array selects the full range of an array formula that includes the active cell. Current Region selects the contiguous rectangular data region around the active cell and does not require an array formula.
