How to Make Excel Autofill Increase Numbers by 10 in WPS Spreadsheets
Question details
The user wants to create an increasing number sequence such as 10, 20, 30, 40 using the fill handle, and needs a reliable method when automatic pattern recognition does not fill the expected 10-step sequence.
- Product
- WPS Office Spreadsheets
- Device & OS
- Windows 11
- Scenario
- The user is entering numerical data and wants to fill a column or row with values that increase by 10 without typing each cell manually.
- Observed behavior
- When dragging the fill handle, the sequence does not increase by 10 as expected, or the step value is not recognized.
Open the worksheet in WPS Spreadsheets and verify that the destination cells are formatted as General or Number so the sequence values display correctly.
Create a 10-Step Sequence with the Fill Handle
Use this method when you want a fast, visual autofill based on two starting values.
The fill handle recognizes the interval only when it has at least two seed values. Selecting a single value and dragging copies that value instead of continuing a sequence.
Click cell A1, type 10, press Enter, click cell A2, and type 20. These two values define an increment of 10.
Select the range A1:A2 by dragging from A1 to A2 or by clicking A1, holding Shift, and clicking A2.
Move the pointer to the lower-right corner of the selection until it changes to a thin cross, then hold the left mouse button and drag down as far as needed.
Release the mouse button. WPS Spreadsheets continues the pattern as 10, 20, 30, 40, and so on.
Use the Fill Series Dialog to Set a Step Value of 10
Use this method when you need a precise sequence, a long series, or the visual fill handle is not working as expected.
Create a 10-Step Number Sequence in WPS Office Spreadsheets
WPS Office Spreadsheets includes the same familiar fill handle and Series dialog as Excel, so you can quickly build a 10-step sequence and keep working in a free, lightweight Office suite.
- 1. Open your workbook in WPS Spreadsheets: Launch WPS Office, open your Excel .xlsx file, or create a new spreadsheet.
- 2. Enter the two starting values: Type 10 in A1 and 20 in A2 to establish the increment.
- 3. Select A1:A2 and drag the fill handle: Select both cells, grab the fill handle at the lower-right corner, and drag downward.
- 4. Check the filled sequence: Release the mouse to see 10, 20, 30, 40, and continuing values.
Frequently Asked Questions
Why does dragging only one cell not increase numbers by 10?
Autofill needs at least two starting values to recognize a step. Enter 10 in A1 and 20 in A2, select both cells, then drag the fill handle downward.
Can I fill a 10-step sequence horizontally instead of vertically?
Yes. Enter 10 and 20 in the same row, select both cells, and drag the fill handle to the right. WPS Spreadsheets continues the sequence across the row.
How do I create a long 10-step sequence without dragging far down?
Select the range, go to Home > Fill > Series, set Type to Linear, Step value to 10, and enter the Stop value for the final number.
What if the fill handle copies the values instead of filling a series?
Make sure both seed cells are selected before dragging. You can also click the Auto Fill Options button that appears after releasing and choose Fill Series.
Does this work in WPS Spreadsheets on Windows 11 with Excel files?
Yes. WPS Spreadsheets on Windows 11 supports the fill handle and Series dialog, and it opens and saves Excel .xlsx files.
