Why is my data validation not working?

Why is my data validation not working?

If data validation isn’t working, make sure that: To prevent users from copying and filling data by dragging and dropping cells, go to File > Options > Advanced > Editing options > clear the Enable fill handle and cell drag-and-drop check box, and then protect the worksheet.

How do I fix data validation in Excel?

Fix: Change Data Validation Source

1. Select the data validation cells.
2. On the Excel Ribbon’s Data tab, click Data Validation.
3. On the Settings tab, change the range address* in the Source box, to include the new items.
4. Click OK, to complete the change.

How do you validate a column?

How to create Column Validation

1. Create a new column on a list or a library or edit the existing one.
2. In my example, I will create a Renewal Date column on a Policy Document Library.
3. At the bottom of the column screen, click on More options.
4. Next, click on Column validation.

Why is my data validation grayed out?

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.

How do you include a blank in a Data Validation list?

In the Data Validation dialog, select List from the Allow drop-down list, select the list including the blank cell you want to create data validation list based on and uncheck the Ignore blank option. 4. Click OK. Now you will see the first option in the data validation list is blank.

How do I unlock data validation in Excel 2010?

How to remove data validation in Excel

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

Why is my data validation not working in Excel?

In the Data Validation dialog box, you can turn off the option for a dropdown list. To turn it back on: In you have a linked picture in an Excel 2013 workbook, on Window 8, the data validation arrow might not appear in the active cell, unless you are pressing the mouse button.

How to fix missing items in data validation?

To fix the missing item problem, follow these steps: 1 Select the data validation cells. 2 On the Excel Ribbon’s Data tab, click Data Validation. 3 On the Settings tab, change the range address* in the Source box, to include the new items. 4 Click OK, to complete the change.

How to change data validation settings in Excel?

Or, follow these steps, to change the Option settings: 1 Click the File tab on the ribbon, and click Options 2 Click the Advanced category 3 Scroll down about halfway, to the section, Display Options for This Workbook . 4 In the setting, “For Objects, show:”, click All 5 Click OK

What happens when the data validation list is blank?

The person who set up the list left a few blank cells at the end, where new items could be added. When there’s a blank cell in the source list, and the cell with the data validation list is blank, the list will open with the blank entry selected.