Home >Topics >excel >How to increase the date drop-down in WPS table

How to increase the date drop-down in WPS table

藏色散人
藏色散人Original
2020-04-24 09:52:5632830browse

How to increase the date drop-down in WPS table

How to increment the wps table date by drop-down

The details are as follows:

1. The first step is to click to enter Excel In the table, select a cell, then click "Sequence" in "Fill" as shown in the picture,

How to increase the date drop-down in WPS table

2. Then the window as shown in the picture will pop up. Finally, we choose to click "Column",

How to increase the date drop-down in WPS table

3. Then if the date we need to enter increases day by day, we need to enter it in the "Step Value" "1", if the increment is two days, you need to enter "2", and so on,

How to increase the date drop-down in WPS table

4. After that, we need to enter our end value in the "End Value" column The date,

How to increase the date drop-down in WPS table

#5. Finally, as shown in the figure, the quick date filling is completed.

How to increase the date drop-down in WPS table

#6. In addition, if the step value is "2", the page as shown in the figure will appear.

How to increase the date drop-down in WPS table

The above is the detailed content of How to increase the date drop-down in WPS table. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn