Drop down list in excel can help you to prepare clean data
Excel Removing Drop Down List. On the settings tab, click clear. Click data > data validation.
Click data > data validation. On the settings tab, click clear.
On the settings tab, click clear. Click data > data validation. On the settings tab, click clear.