Drop down list in excel can help you to prepare clean data
Copying Drop Down Lists In Excel. Go to the data tab on the ribbon. Select the cell or cells where you want to create the drop down list.
All you need is a few named ranges and the indirect. Select the cell or cells where you want to create the drop down list. Go to the data tab on the ribbon.
Select the cell or cells where you want to create the drop down list. Go to the data tab on the ribbon. All you need is a few named ranges and the indirect. Select the cell or cells where you want to create the drop down list.
