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
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. See screenshot:
And the error values have been selected. See screenshot:
![]() | ![]() | ![]() |
- Click Select Cells With Error Value to 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!
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!
![Screen Shot of Excel (with Office Tab installed)](http://cdn.extendoffice.com/images/stories/kte-module/officetab-bottom-02.gif)