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...