WPS Spreadsheet: Fill a Series by Increments of 10
Question details
The user needs to autofill a spreadsheet sequence that increases by 10 between cells.
- Product
- WPS Spreadsheet
- Device & OS
- not provided
- Scenario
- The user wants to create a numeric series with a step value of 10 rather than the default increment of 1.
- Observed behavior
- The fill operation needs to continue values such as 10, 20, 30, and 40 down a column.
Decide the starting value and confirm how many rows the series should contain. Open the target worksheet and identify the first cell where the sequence will begin.
Use a formula to create a series that increases by 10
Use this method when you want every new value to remain linked to the previous value and update automatically.
A formula that adds 10 to the cell above creates a consistent step size. Copying the formula downward continues the sequence without manually entering each number.
In WPS Spreadsheet, select cell A1 and type the starting number, such as 10, then press Enter.
Select cell A2, enter =A1+10 in the formula bar or directly in the cell, and press Enter.
Select A2, point to the fill handle at the lower-right corner of the cell, and drag it downward across the required rows.
Use the first two values and the fill handle
Use this method when you prefer a quick drag-and-fill operation without creating a formula.
Create 10-Point Number Series in WPS Spreadsheet
WPS Spreadsheet lets you create a series in increments of 10 with either a simple formula or the fill handle. The familiar spreadsheet interface makes it easy to extend the pattern while keeping your worksheet compatible with common Excel files.
- 1. Open WPS Spreadsheet: Launch WPS Office and open an existing workbook or choose Spreadsheet to create a new worksheet.
- 2. Enter the starting pattern: Type a starting value and either enter =A1+10 in the next cell or enter the first two values, such as 10 and 20.
- 3. Select the cells: Select the formula cell or the two cells that define the 10-point pattern.
- 4. Drag the fill handle: Drag the fill handle downward or across the worksheet to extend the sequence.
Frequently Asked Questions
How do I make WPS Spreadsheet increase values by 10?
Enter a starting value in A1, enter =A1+10 in A2, select A2, and drag its fill handle downward. Each copied formula adds 10 to the previous value.
Can I autofill a series of 10, 20, 30, and 40 without using a formula?
Yes. Enter 10 and 20 in adjacent cells, select both cells, and drag the fill handle. WPS Spreadsheet uses the difference between the selected values to continue the series.
Why does dragging the fill handle repeat the same number?
The spreadsheet may have only one value selected, so it repeats that value instead of detecting an increment. Enter and select the first two values, such as 10 and 20, before dragging.
Can I start the series with a number other than 10?
Yes. For example, enter 5 in A1 and =A1+10 in A2 to produce 5, 15, 25, and 35. You can also enter 5 and 15, select both cells, and drag the fill handle.
Will the increment-of-10 series work with Excel files?
Yes. WPS Spreadsheet supports common Microsoft Excel .xlsx and .xls files. Save the completed workbook in its original format through File > Save As if you need to share it with Excel users.
