Register Blogs Advertise with usHelp Desk Today's Posts Search

Rate this Entry

Prevent Data Entry Errors in Excel

Share
Submit "Prevent Data Entry Errors in Excel" to Facebook
Posted 1st April 2012 at 11:44 AM by ddalgleish

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
Views 595 Comments 0
Total Comments 0

Comments

 


All times are GMT -6. The time now is 02:07 PM.