How to restrict the format of wps table content input wps table content input restriction format setting

Excel spreadsheet is often used as our daily office software because of its powerful functions. So how to restrict the content input conditions of the WPS table? For example, if we set the column where the name is located, numbers cannot be entered. How should this be set? In fact, we only need to set the text length menu in the data validity window. Let’s take a look at the specific operations. Solution 1. First open the Excel table and select the cell range that needs to be set.

2. Then, switch to the [Data] page and select the inverted triangle symbol to the right of [Validity].

3. Select the [Validity] function.

4. In the pop-up data validity panel, set [Validity Condition] to [Text Length], [Minimum Value] to 2, and [Maximum Value] to 5; finally press [Confirm].

5. Let’s set the content entered in the cell to text with a limited length of 2-5 data. Return to the Excel table and an error message will appear when entering numbers. Enter the correct content and no prompt will appear. fenye

The above is the detailed content of How to restrict the format of wps table content input wps table content input restriction format setting. For more information, please follow other related articles on the PHP Chinese website!