Moving Checklist Delete Dropdown Menu Fields For Free

Create a drop-down listSelect the cells that you want to contain the lists.On the ribbon, click DATA > Data Validation.In the dialog, set Allow to List.Click in Source, type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list, and click OK.

Edit a drop-down list with items that have been entered manuallyOn the worksheet where you applied the drop-down list, select a cell that has the drop-down list.Go to Data > Data Validation.On the Settings tab, click in the Source box, and then change your list items as needed.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.

Right click the sheet tab contains the dependent drop down list you will clear automatically, then select View Code from the context menu.

Lock cells to protect themSelect the cells you want to lock.Click HOME, then click the Format Cell dialog box launcher (the arrow to the right of Alignment in the ribbon).Click the Protection tab, check the Locked box, and click OK.Click REVIEW > Protect Sheet or Protect Workbook, and reapply protection.

Press the Keyboard Shortcut Ctrl + A to select all the cells of the sheet. Right click and choose Format cells. Go to the Protection tab and uncheck Locked option and click Ok. Now select only the cells or columns, rows that you want to protect.

Restrict data entrySelect the cells where you want to restrict data entry.On the Data tab, click Data Validation > Data Validation.In the Allow box, select the type of data you want to allow, and fill in the limiting criteria and values.