How to select cells with error values in Excel?
When opening a worksheet, you might encounter error messages like #DIV/0!, #N/A!, #NAME?, #REF!, and #VALUE!. These errors usually arise from formula calculation mistakes or incorrect function conditions. If you need to select all cells containing these error values at once—whether to correct, delete, or format them—how can you efficiently achieve this? This guide will show you how to quickly identify and select cells with error values in your Excel spreadsheet.
Using the Go To Special function to select cells with error values
Quickly select cells with error values with Kutools for Excel
| Feature | Go To Special | Kutools for Excel |
|---|---|---|
| Best for | Selecting formula error cells using Excel’s built-in tools | Quickly selecting all cells containing formula errors with one command |
| Setup complexity | Simple to moderate | Very simple |
| Formula cells only | Yes; uses Formulas > Errors in Go To Special | Yes; targets cells with formulas resulting in errors |
| Main advantage | Built into Excel and requires no add-in | Selects error-value cells directly with a single command |
| Main limitation | Requires opening Go To Special and configuring the error option each time | Requires Kutools for Excel |
| Recommended use | Occasional checking or troubleshooting of formula errors | Frequent error checking in larger worksheets |
Using the Go To Special function to select cells with error values
To select and locate the error values, you can use the Go To Special function of Excel. Please do as follows:
1. Highlight the range that you want to select the error values.
2. Click Home > Find & Select > Go To Special…and a Go To Special dialog box will pop out. Then click the Formulas option from the Select section, and check the Errors checkbox. See screenshot:
3. And then click OK. All of the error values will be selected.
Quickly select cells with error values with Kutools for Excel
If you have installed Kutools for Excel, this tool will select all cells on your worksheet with a formula that results in an error value easily and quickly.
Select the range and click Kutools > Select > Select Cells With Error Value.
And the error values have been selected. See screenshot:
 |  |  |
- Click Select Cells With Error Valueto learn more about this feature.
- Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. Get Kutools for Excel Now!
Conclusion
Selecting cells that contain formula errors can make it easier to locate problems, troubleshoot formulas, and clean up large Excel worksheets.
Go To Special is a useful built-in option for occasional error checking and requires no additional tools. If you frequently work with large datasets, Kutools for Excel provides a quicker approach by selecting all cells containing formula errors in the chosen range with a single command.
Tip: After selecting the error cells, review the underlying formulas before replacing or deleting anything, as different error types may require different fixes.
Choose Go To Special for occasional troubleshooting, or use Kutools when you need a faster and more convenient way to identify formula errors regularly.
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license — set up in minutes (MSI-ready)
- Works better together — streamlined productivity across Office apps
- 30-day full-featured trial — no registration, no credit card
- Best value — save vs buying individual add-in