Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Remove Drop Down List. Select the cells you want to locate the drop down list then click Data Data Validation. Click the Source box select your list range and select OK.
Here S How To Create A Drop Down List In Excel To Restrict Data Excel Drop Down List Data from in.pinterest.com
Select the cells you want to locate the drop down list then click Data Data Validation. Select the cell where you want the drop-down list to appear and then select Data Data Validation Settings Allow List. ShiftDelete to delete the highlighted entry.
Click Data Data.
To remove go to Data Data Validation Settings Clear All. Learn how to remove a drop-down list in Excel - quick and easy. And I cant delete the cells that do not have data because of the information in adjacent columns. In the Data Validation dialog box you need to.
