To change the options for a drop-down list, you edit the data for the drop-down list, and possibly the Data Validation Source field.įor a drop-down list that uses a comma-delimited list in the source field, select the cells with the drop-down list, and in the Data Validation, in Source field, make the desired changes to the comma-delimited list.įor a drop-down list that is based on a cell range, click a cell in the range and type the changes you want to make. I can type in an unlocked cell, but if I try to type in a locked cell, I get an error. Only these cells on the worksheet are locked. In Format Cells, check Locked, and click OK. Select the specific cells you want to lock, right-click them, and click Format Cells. In Format Cells, click the Protection tab, uncheck Locked, and click OK. Select the entire worksheet, right-click it, and click Format Cells. To lock specific cells, you first have to change the default for the worksheet. To unprotect a worksheet, right-click the worksheet’s tab, click Unprotect Sheet, enter the password, and click OK. Now, if I try to type in any cell on the worksheet, I get an error.
#Drop down menu in excel 2016 wont go away password#
Re-enter the password and click OK again. To password-protect a worksheet, right-click its tab and click Protect Sheet. To unhide a worksheet, right-click any worksheet tab, click Unhide, and click OK.īy default, all cells on a worksheet are locked.īut, this has no effect until the worksheet is password-protected. To hide a worksheet, right-click the worksheet’s tab, 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 columns or rows, select the columns or rows, right-click them, and click Hide. You can also lock and password-protect the cells on the worksheet, or even the entire worksheet.īy password protecting the data, only people with the password can make changes.īut it’ll also require a little more effort on your part, if you decide to make changes, because you have to unprotect the data first. You can then unhide them, if you need to make changes. To prevent anyone from accidentally changing drop-down list data, you can hide the columns, rows, or the entire worksheet that contains the data.