Prevent Data Entry Errors in Excel

When you're running a business, Excel is a great tool to keep track of sales and expenses.

However, if you're entering lots of data into a worksheet, it's easy to make a typing mistake, or put information into the wrong cell.

To help prevent data entry errors, you can create drop down lists in the Excel sheet. These are made with the data validation feature.



Then, if you or your assistant are entering sales data, just select an item from the drop down list, instead of typing. It's quicker, and easier, and safer!

The step by instructions are here: Excel Data Validation -- Introduction

To see the steps for adding a drop down list in an Excel worksheet, you can watch this short video tutorial:

Drop Down List in Excel