How to use WPS Table Auto Fill

do you know the automatic filling function of a WPS table or Excel table? To enter the 7 days of the week, simply enter the first two, and the remaining 5 are handled by the AutoFill feature:

But, did you try the second method--right-drag method?

What do you see? Is there a lot of choice?

Select "Fill in Days" and you will see the result

Select "Fill in Month" and you will see the result

Instead, select "Fill in workdays" and see this

The third way--ctrl+ left-drag, what will be the effect?

This is a quick way to copy cells. The equivalent approach is to enter the content and enter it when all the cells are selected, or you can quickly type the same content in different cells.

So, can you be more free to personalize it automatically? for example:

Actually, it's simple.

You can also define any kind of autofill rule yourself. Do you want to create a few more magical automatic additions? The above is achieved in the WPS form, you go to Excel to try it! Much the same, just a little bit different. Did you find it?

Yes, that's right. The last setting is different, which is located under the Advanced Group of Excel options: