Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Check for Data Entry Errors in Excel (2 Easy Ways)

In Excel, you need to work with a set of data. Sometimes, errors may occur in data entry. So, you need to check for data entry errors to fix the error data and make a perfect dataset. In this article, I will show you how to check for data entry errors in excel. I will show two easy ways here. The methods are suitable and handy. Hopefully, you will have fun learning the procedures. Additionally, I have added the necessary images for your better understanding. Let’s follow the procedure step-by-step.


Download Practice Workbook

Please download the workbook to practice yourself.


2 Effective Ways to Check for Data Entry Errors in Excel

For this article, I will consider the following dataset called Customer Information of ABC Co. The dataset has four columns B, C, D, and E called ID, Name, Location, and Product. The dataset ranges from B4 to E10 cells. As you can see, the dataset has some errors in entries. I will check for data entry errors. So, here, I will show how to check for data entry errors in excel in two suitable ways.


1. Use Data Validation to Check for Data Entry Errors in Excel

This is the first method of this article. Here I will use the data validation process to fix data entry errors in excel. Please follow the procedures step by step. You can get a clear idea of every step from the additional images.

Steps:

  • Select the data table from B4 to B10.

Use of Data Validation to Check for Data Entry Errors in Excel

  • From your toolbar, select the Data Validation option under the Home tab.

Use of Data Validation to Check for Data Entry Errors in Excel

  • Then, you will see the Allow drop-down menu.

Use of Data Validation to Check for Data Entry Errors in Excel

  • Then, select the Decimal option.

Use of Data Validation to Check for Data Entry Errors in Excel

  • After that, enter the minimum value of 1000 and the maximum value of 10000.

Use of Data Validation to Check for Data Entry Errors in Excel

  • As a result, now, if you want to enter an id less than 1000, Excel will show you this disclaimer.

Use of Data Validation to Check for Data Entry Errors in Excel

This is how you can avoid errors by using data validations.

Read More: Types of Data Entry in Excel (A Quick Overview)


2. Check for Data Entry Errors in Excel by Using Sort and Filter Options

This is the second and last method of this article. This is another method to check for data entry errors in excel. I will use the sort and filter options here. Follow the procedure step by step. I hope this will increase your excel skill.

Steps:

  • First, select the dataset ranging from B4 to E10.

Check for Data Entry Errors in Excel by Using Sort and Filter Option

  • Then, in your toolbar, select the Home tab.
  • After that, select the Sort and Filter options in the editing part.

Check for Data Entry Errors in Excel by Using Sort and Filter Option

  • Additionally, select the Filter option here.

Check for Data Entry Errors in Excel by Using Sort and Filter Option

  • Then a filter arrow will be shown beside the heading of every column.

  • After that, click on the arrow beside the location heading, and locate the errors.

  • Then, fix the errors.
  • As a result, you will find the following corrected results.

Read More: How to Automate Data Entry in Excel (2 Effective Ways)


Things to Remember

  • For the second method, you can locate the error by filtering a column only. For every column, you need to filter separately.

Conclusion

In this article, I have explained how to check for data entry errors in Excel. I hope, you have learned something new from this article. Now, extend your skill by following the steps of these methods. You will find such exciting blogs on our website Exceldemy.com. I hope you have enjoyed the whole tutorial. If you have any queries, please ask me in the comment section. Don’t forget to give us your feedback.


Related Articles

Souptik Roy

Souptik Roy

Hello there. This is Souptik Roy. I graduated from Naval Architecture & Marine Engineering department. I am trying to explore the world of Microsoft Excel and want to increase my analytical power apart from my Engineering degree, as I have a curious mind. this is why I am trying to learn Excel Operations and write articles to help others.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo