how to remove blanks from dependent drop down list in excel YouTube

Removing a drop-down list from a cell in Excel is a simple process. Just right-click on the cell with the drop-down list, select 'Data Validation,' and then click 'Clear All.' This will remove the drop-down list from that particular cell. After removing the drop-down list, the cell will revert to a normal cell.. Pro Tip: This method removes the drop-down list from any cell but keeps the last values selected from the list within the cell. So, if you have used the drop-down list for easy data entry and later want to remove the list, this option would work best for you. Using Data Validation, you can remove the drop-down list without having to lose the cell values.

Method 1 - Using the Data Validation Feature Case 1: From Selected Cells. Select the cell range. Note: Press CTRL+Click to select non-adjacent cells. Go to the Data tab > Data Tools > Data Validation.; In the Data Validation dialog box, go to the Settings tab > Clear All > OK.; The drop-down lists are removed from the selected cells.. Steps to Remove a Drop-Down List. To get rid of a drop-down list, use the following steps: First, select the cell or range of cells where you have the data validation drop-down list. After that, go to the Data Tab ⇢ Data ⇢ Data validation ⇢ Data Validation (You can also use the keyboard shortcut Alt ⇢ A ⇢ V ⇢ V).