Learn how to create a drop-down list using Data Validation in Excel. Data Validation limits the type of data that can be entered into a cell.

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.

Now, create a new number list in the next adjacent column (see the above screenshot). You have to use this number list to reverse the list in Excel.

Figure B How to return a sequence of dates in Excel Excel’s fill handle can generate a quick list of dates for you, but the list is static; you must create a new list if your needs change.

10 ways Excel can be useful for the average person If you think Excel is only for number crunchers, you're missing out.Here are ways the average person can use the spreadsheet software.