Make a Cell Drop Down List in Excel for Easy Data Entry

To make data entry easy, and help prevent errors, make an in cell drop down list in Excel. First, create a list of items in an Excel table. Then use Excel data validation to make the drop down list with those items. People can quickly select from your list, instead of typing