Analysis of how to change the data validity setting in Excel2007 and the unavailability of the "data validity" command

Excel2007 how to change the data validity settings and the "data validity" command is not available problem analysis, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, hope you can gain something.

Change data validity settings

1. Click the cell whose data validity settings you want to change.

two。 On the data tab, in the data tools group, click data validity.

3. On each tab in the data validity dialog box, select the options you want and change them.

If you want to make the same changes to other cells on the worksheet, select the apply these changes to all other cells with the same settings check box on the Settings tab.

Problem: the data validity command is not available

-- the Excel form may be linked to the SharePoint site. You cannot change the data validity of the Excel form linked to the SharePoint site. To change the validity of the data, you must unlink the Excel table or convert the Excel table to a region.

You may be currently entering data when you enter data in a cell, the data validity command on the data tab is not available. To end the entry, press Enter or Esc.

-- A worksheet may be protected or shared. If the workbook is shared or protected, you cannot change the data validity settings.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.