Shulou(Shulou.com)06/03 Report--

What this article shares with you is about how to solve the problem that the wps auto-filling option is missing. The editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

Solution to the disappearance of the wps auto-fill option:

1. Click to select the location of the first serial number, select "find and quote" in the "Formula" in the menu bar, click it, and select the "ROW" function in the pop-up window. If you want to understand the meaning of this function, you can select "insert function" in the space, click on the function name, and there is a specific description below.

2. The content in the diagram appears in the input box in the table. Regardless of the pop-up window, click on the input box and enter-1 after the parentheses. The purpose is to enter a sequence number that is 1 less than the sequence number value included in the table. The number of serial numbers in the table before the serial number 1 minus 1 equals what it is, and minus a few after the function. For example: the table comes with a serial number of 3, a custom serial number of 1, and enter-2 after the parentheses.

3. Confirm after entering the content.

4. The input box becomes a number.

5, select the input box where 1 is located, when the lower right corner of the input box becomes a black cross, hold down the left button and drag the mouse down, release the left button to the specified number of lines, and the serial number will be generated automatically. This method is suitable for tables with more serial numbers.

The above is how to solve the problem that the wps auto-filling option is missing. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.