Have you entered data, only to find one cell contains the word “Meal” and another one contains “Meals”. As you found out the hard way, they are not the same in Excel.
Data validation takes the stress out of making sure the data entered is correct by not allowing data that does not match one of the items in the list to choose from.
I know I’ve been frustrated in the past, having to take time to fix errors. Data validation using a drop down list eliminates that frustration.
Watch the short video to learn how it’s done.
To schedule a FREE 15 minute conversation on how you can use Excel to make your business accurate and efficient, click the link below.