News
Hosted on MSN2mon
How to Create a Drop-Down List from a Column of Data in Excel - MSN
To create a drop-down list, select cell where you want it to be (in this case, cell I2), and in the Data tab on the ribbon, click "Data Validation" in the drop-down option with the same name.
Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results