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.

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.

Microsoft Excel can save you time in lots of little ways, like adding a drop-down list to cells so that only pre-written text can be entered.

The solution lies with using Excel's array feature to traverse a data list automatically and extract missing sequential numbers, even if the number list is out of order.

Microsoft Excel users, here's a quick tip on adding a condition to a drop down list.