How to find errors in a worksheet
Excel has great built-in features. The following one lets you search an entire worksheet for formulas that return an error.
Instructions:
- Go to "Home" tab
- Press with left mouse button on "Find & Select"
- Press with left mouse button on "Go to Special..."
- Press with left mouse button on "Formulas"
- Enable "Errors"
- Press with left mouse button on ok!
If any formulas errors exist, they are now selected. The picture below demonstrates error cells being selected.
Weekly Blog EMAIL
[newsletter_signup_form id=1]
Welcome! I am Oscar and here to help you out.Feel free to comment and ask Excel questions.
Make sure you subscribe to my newsletter so you don't miss new blog articles.
Related articles
Count how many times a string exists in a cell range (case insensitive)
Question: How do I count how many times a word exists in a range of cells? It does not have […]
Easily select data using hyperlinks
The image above shows two hyperlinks, the first hyperlink lets you select a data set automatically based on a dynamic […]
Extract cell references populated with values [VBA]
This article demonstrates a macro that returns cell references for cell ranges populated with values on a worksheet. Jinesh asks: […]
Lookup using multiple conditions
Debraj Roy asks: Hi Oscar, I failed to search for "Ask" Section.. so submitting my query here.. Apologize for hijacking […]
Charts in Microsoft Excel lets you visualize, analyze and explain data. Charting in Excel is very easy and you […]
How to replace columns with pictures in a column chart
I found an interesting chart on CNN's website: Rise of the supersize rugby player It shows the average height of athletes […]
In this blog post I will provide two solutions on how to remove blank cells and a solution on how […]
Table of Contents Delete blanks and errors in a list How to find errors in a worksheet 1. Delete blanks […]
In this article, I am going to show you two ways on how to find blank cells. Both techniques are […]
In this smaller example, column D (Category) has empty cells, shown in the picture above. If your column contains thousands of […]
What is a reference in Excel? Excel has an A1 reference style meaning columns are named letters A to XFD […]
A non-contiguous list is a list with occasional blank cells and that makes it harder to select the entire cell […]
Have you ever wondered how these lines got there on a worksheet? They show where pages will break, in other […]
Selecting cell ranges in Excel can sometimes be a real pain scrolling forever it seems. There is a quick and easy […]
4 Responses to “How to find errors in a worksheet”
Leave a Reply to Formation Excel
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Excellent, thank you! Took quite a few google searches to come across this. VERY simple and helpful!
[…] For Excel for Windows, there’s an option to search a sheet for errors and go straight to them, under the “Find and select” icon in the ribbon. […]
Excellent, thank you!
we can use conditional formatting too !!
THis was very handy as teh latest version of Office 365 Win 10 has an Error Check (under Formulas tab) but it was not finding several errors. This method most most of them. They were hidden in merged cells where the left cell was find but the 3 to the right were not. THe last errors neither found were in tables where the #ref was not visible due to formatting.
Thank you so much. I was starting to go crazy.