Contract Remove Dropdown Menu Fields For Free

Select a cell or several cell from which you want to remove drop down boxes. Go to the Data tab and click Data Validation. On the Settings tab, select the Clear All button. This method removes the drop-down menus from the selected cells, but keeps the currently selected values.

Go back to your Excel sheet and select any cell. Select the View tab, click on the Macros menu on the far right and then choose the macro/code you've just pasted in. It should be the first one on the menu. Select it, click Run, and all the arrows will disappear from the table.

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.

Removing Entries When the drop-down list of suggestions appear, you can highlight an entry by pressing the down arrow key. Press "Shift-Delete" to remove the highlighted entry from the list.

Press "Shift-Delete" to remove the highlighted entry from the list. If you want to remove multiple entries, visit your browser history by pressing "Ctrl-H." Click the check box next to each entry you wish to remove and select "Remove Selected Items" to delete the selected entries.

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.

Select 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.