How to set Excel table to only enter fixed content?

php editor Banana will introduce to you how to set up a method that can only input fixed content in an Excel table. Through the data validation function, you can easily restrict the input content of cells to ensure the accuracy and consistency of the data. This feature is especially important when working with worksheets that require specific input, allowing you to manage and analyze your data more efficiently. Next, let us learn how to use the data validation function of Excel to set the form to only input specific content to improve work efficiency!

First, after opening the Excel table, select the table area where fixed content needs to be entered.

In the picture form, if you need to enter "male" or "female" in the gender column, you can only select these two options and cannot enter other content. To achieve this restriction, you can first select the area where you want to enter content, then click the [Data Validation] tab in the menu and select the [Data Validation] function.

If the old Excel version does not have the [Data Validation] tab, please click [Data] → [Validity].

Subsequently, on the [Data Verification] page, click the "Allow" drop-down arrow to select the required permission conditions. The "Gender" item is "Sequence", so select "Sequence", and you can also select "Date" as needed. ”, “integer”, “decimal”, etc.

After selecting the "Allow Condition", enter the content in the "Source" option. For example, in our example chart, if you need to enter "Male" and "Female", enter "Male, Female". Remember that each content in the sequence needs to be separated by half-width commas. Then click [OK] to set it up.

If you want to issue a prompt when you enter incorrect content, you can select [Error Warning] on the [Data Verification] page, then fill in the content you want to prompt in the "Title" and "Error Message", and finally click [ OK].

After the setting is completed, you can see that a "drop-down triangle" appears in the selected area. The sequence set previously is in the list, that is, you can only enter or directly select the content specified in the list.

If the input is not the specified content, an error prompt will pop up, and the prompt content is the content set previously.

You will no longer need this function in the future, and you can cancel it. You only need to select the fixed content area again, then click the menu tab [Data] → [Data Verification], and then click [Clear All].

If you find that [Data Verification] is in a gray state and cannot be clicked when canceling, then you need to check whether the Excel table has been set to "Restrict Editing", because the Excel table under "Restrict Editing" cannot be edited and Change, many other options are also unclickable.

In this case, we only need to lift the Excel "restrictions". Click [Revoke Worksheet Protection] in the menu tab, then enter the originally set password in the pop-up dialog box. After clicking [OK], the "restrictions" will be lifted.

Of course, if you forget your password, you cannot undo it, but we can use tools to solve the problem, such as the Pepsi Niu Excel Password Recovery Tool, which can directly remove the "restricted editing" of Excel tables without entering a password.

Just select the [Unrestriction] module in the tool and then import the Excel table.

Tool link: Pepsi Niu Excel Password Recovery Tool

The Excel table after the restrictions are lifted will be saved as a new table, which can be found by clicking [Go to View] in the tool.

The above is the detailed content of How to set Excel table to only enter fixed content?. For more information, please follow other related articles on the PHP Chinese website!