RFP Remove Dropdown List For Free

The worksheet with the DropDown list can then be hidden. Just right click the worksheet tab name and select Hide. (Unhide again by right clicking any worksheet tab and select Unhide and follow prompts to complete.

Just right click the worksheet tab name and select Hide. (Unhide again by right clicking any worksheet tab and select Unhide and follow prompts to complete. If you are not using a Data Validation Dropdown then please get back to me and explain how you created the DropDown.

To hide columns or rows, select the columns or rows, right-click them, and click Hide.To unhide them, select the column or row on one side of the hidden columns or rows, drag your mouse to the other side, right-click, and click Unhide.To hide a worksheet, right-click the worksheet's tab, and click Hide.More items...

Remove a drop-down listSelect the cell with the drop-down list. If you have multiple cells with drop-down lists that you want to delete, you can use Ctrl+Left click to select them.Click Data >Data Validation.On the Settings tab, click Clear All.Click OK.

Chosen solution If you put your text cursor on the input field, and press the down key on your keyboard until that entry is selected on the dropdown suggestions list, you can press "delete" to remove it from the list.

Remove a drop-down listSelect the cell with the drop-down list. If you have multiple cells with drop-down lists that you want to delete, you can use Ctrl+Left click to select them.Click Data >Data Validation.On the Settings tab, click Clear All.Click OK.

If you want to make any changes to the drop-down box, just select it while in Developer Mode and click "Properties" again. Select "Content control can't be deleted" to ensure readers cannot delete the drop-down box or its options. Don't select the "Contents cannot be edited" option.