How do I unlock data validation?

Select the cell(s) with data validation. On the Data tab, click the Data Validation button. On the Settings tab, click the Clear All button, and then click OK.

How do I turn on data validation in Excel?

Add data validation to a cell or a range

Select one or more cells to validate.
On the Data tab, in the Data Tools group, click Data Validation.
On the Settings tab, in the Allow box, select List.
In the Source box, type your list values, separated by commas.
Make sure that the In-cell dropdown check box is selected.

Why is the Data Validation greyed out in Excel?

The reason Data Validation is Greyed Out is due to the characteristics of your spreadsheet. If you spreadsheet is “Protected” or being “Shared” with another file, the Data validation tool is turned off in Excel. The other option is to copy the data set into a new worksheet that is not shared.

Why can’t I see Data Validation in Excel?

The worksheet might be protected or shared – You cannot change data validation settings if your workbook is shared or protected. You’ll need to unshare or unprotect your workbook first.

Why is Data Validation greyed out Excel?

How do I unlock the greyed out menu?

You must unprotect the workbook, worksheet or cell to unlock the unavailable menus. Click the “Home” menu, then choose “Format” in the “Cells” tab. Select “Unprotect Sheet” from “Protection” section of the drop-down menu to unlock the worksheet.

Why are developer controls greyed out?

It sounds like you created the Table in Publishing Layout view, then switched to Print Layout View. If that’s the case, the document already is defined as a Pub document which does not support Forms Controls. Just switching from Pub View to Print Layout View does not change the document type.

Why is unhide greyed out in Excel?

If the Unhide command is grayed out both on the ribbon and in right-click menu, that means there is not a single hidden sheet in your workbook 🙂 This is how you unhide sheets in Excel.

How can I use data validation in Excel?

Here’s how: Select one or more cells to validate. Open the Data Validation dialog box. On the Settings tab of the Data Validation dialog window, select Custom in the Allow box, and enter your data validation formula in the Formula box. Click OK.