How does wps schedule dates automatically? wps tables automatically generate tutorials with consecutive dates
wps is a very practical office software, can help users simply and easily complete the editing process of the file, users can set the form style according to their own needs, calculate the form data or organize the form format, but want to automatically generate continuous dates in the form, how to operate it, then let Xiaobibian introduce wps forms automatically generate continuous dates method.
Setting method
1, first open the wps software and go to the edit page of the form file and select the cell.
2, then the user clicks with the right mouse button, and then the user selects the set cell format option in the pop-up menu.
3, go to the Set Cell Format window, in the number TAB set the classification to date.
4, Select the appropriate date style in the type section and press the OK button.
5, then return to the editing page, move the mouse cursor to the lower right corner of the cell containing the date, become a cross icon and pull down.
6. As shown in the figure, the current date is automatically generated continuously, and the month will be automatically updated on the last day of the end of the month, rather than only the consecutive days.
The above is the wps table automatically generate consecutive dates tutorial, I hope you like, please continue to pay attention to the script home.
Related recommendations:
How does wps autofill dates? WPS Excel autofill the current date method
Related article
-
What can I do if the message "Cannot start the source application of this object" appears when I am editing wps? This problem may occur because you are trying to open a link or file, but its source application no longer exists or has been deleted2024-05-01 -
wps file needs handwritten signature, we can use the photo of the signature to remove the background color, make the effect of handwritten signature, how to achieve it? See below for details2024-04-28
-
How to use wps format brush? wps format brush shortcuts and use tips
In WPS Office, format brush is a very practical tool, it can help us quickly apply the format of a paragraph to another paragraph, saving the trouble of setting one by one, here is to introduce the use of WPS format brush2024-04-28 -
How to use wps Formula Editor? WPS input formula tips
wps documents often need to display some formulas, how to enter the formula? We can use the formula editor to input, let's take a look at the formula editor to use2024-04-22 -
How do wps score? wps tips for entering score lines
When editing a document, we will need to enter a score, so how does WPS score? If we use the "/" symbol, it is often not very consistent with reading habits, because in our habits, the score line is horizontal, the following to give you a detailed introduction to WPS how2024-04-22 -
What does wps mean? wps Basics tutorial for beginners
Now many friends are using wps, then wps is what software, novice white how to know this software? Let's take a look at wps2024-04-22 -
How to print pictures in WPS? WPS Word document setup method for printing pictures on both sides
In WPS, we can insert pictures to print photos to add to the document, according to the need to choose double-sided printing, let's take a look at the detailed steps below2024-04-16 -
Want to set two vertical axes, but do not know how to operate to achieve, in fact, this problem is very well solved, the user directly on the chart after selecting a column of data, click on the menu bar to set the format and check the next axis, and then in the open change2024-04-13
-
How can WPS date only show the year? We can directly enter [=text ()] in the blank cell behind, position the mouse cursor in parentheses, and then enter A1, yyyy/m, separated by commas in the middle to operate on it2024-04-13
-
How to take quick screenshots with WPS? Wps screenshot shortcut key introduction
wps screenshot can have many methods, the fastest is to use the shortcut key screenshot, then wps shortcut key is what combination? See below for details2024-04-13
Latest comments