Excel's drop-down menus are useful ... This means that in the former case, you'll need to find and delete these options to remove the drop-down completely. The data in the cells remains intact ...

then this process is incredibly simple — just add or delete the items from the table, and Excel will update the drop-down list for you automatically. However, if your drop-down list is based on ...