How to Fix Excel AutoFill Generating Decimal Values Instead of Repeated Integers
Question details
The user needs to prevent Excel from generating decimal numbers when attempting to auto-fill a sequence of repeated integers, such as repeating user IDs.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Dragging the AutoFill handle to extend a custom pattern where each integer is meant to be repeated a specific number of times.
- Observed behavior
- Excel predicts a linear trend and generates a series of decimal values instead of maintaining and incrementing the repeated integer pattern.
Before you begin, determine exactly how many times each integer needs to be repeated in your sequence so you can structure the starting cells or formulas correctly.
Use an Addition Formula to Control Increments
By using a simple addition formula that references a specific preceding cell, you bypass Excel's trend prediction and force the series to generate whole numbers.
This method is highly reliable for large datasets where you need precise control over how frequently a number repeats before incrementing.
Type your starting integer (e.g., '1') in the first two cells of your column, such as A2 and A3.
In cell A4, type the formula =A2+1. This tells Excel to add 1 to the value located exactly two rows above it.
Select cell A4, click and hold the square fill handle in the bottom-right corner of the cell, and drag it downward to apply the pattern to the remaining rows.

Use AutoFill Options to Copy Cells
Override Excel's default behavior by manually forcing the AutoFill tool to copy the pattern rather than calculating a numeric trend.
Easily Manage Data Patterns with WPS Spreadsheet
WPS Spreadsheet provides intuitive AutoFill tools and identical formula capabilities to accurately fill patterns and manipulate data without unexpected decimal conversions.
- 1. Open your worksheet: Launch WPS Spreadsheet and open the document where you need to input data.
- 2. Input the initial values: Type the first integer in your starting cells to establish the base pattern.
- 3. Apply formula or AutoFill: Enter =A2+1 in the subsequent row and drag the fill handle downward to instantly generate your repeated integer series.

Frequently Asked Questions
Why does Excel create decimal values when I use AutoFill?
When you select a pattern of numbers that doesn't form a simple, straightforward progression, Excel attempts to find a 'trend' to predict the next numbers. This mathematical prediction often results in calculated decimal values instead of whole numbers.
How can I repeat a number exactly 3 times before it increments?
Enter your starting number manually into the first three consecutive cells (for example, A2, A3, and A4). Then, in cell A5, enter the formula =A2+1. Drag the fill handle from cell A5 downwards to continue the sequence of repeating each integer three times.
Is there a way to quickly turn off Excel's default trend filling?
While you cannot permanently disable trend prediction in the settings, you can hold down the 'Ctrl' key on your keyboard while dragging the fill handle to instantly toggle between copying cells and filling a series.




