Office for Mac Issues

Fix Excel for Mac AutoFill Copying Same Number Instead of Sequence

Algirdas Jasaitis Sep 28, 2026 871 views

Question details

The user needs to know how to make Excel for Mac's AutoFill feature continue a number sequence instead of repeatedly copying the same starting value.

Fix Excel for Mac AutoFill Copying Same Number Instead of Sequence

Product: Excel for Mac
Device & OS: macOS
Scenario: Dragging the fill handle to automatically generate a sequential list of numbers in a spreadsheet.
Observed behavior: Excel repeatedly copies the single selected number down the column instead of extending the sequence incrementally.

Before you start

Ensure you are clicking exactly on the small square at the bottom-right corner of the active cell selection, known as the fill handle, until your cursor turns into a black cross.

Solution 1Recommended

Select Multiple Cells to Establish the Sequence Pattern

Excel needs at least two numbers to recognize a sequence pattern before you use the fill handle; selecting just one cell defaults to copying its exact value.

By default, if you type a number into a single cell and drag the fill handle, Excel assumes you want to duplicate that number. Providing two values gives Excel the necessary context to calculate the step difference and build the sequence.

Enter the starting number

Click on a blank cell and type the first number of your sequence, such as '1'.

Enter the second number

Click the cell immediately below or next to the first cell and type the second number in your sequence, such as '2'.

Highlight both cells

Click and hold the first cell, then drag over the second cell to highlight both of them simultaneously.

Drag the fill handle

Hover your mouse over the bottom-right corner of the highlighted area until the cursor becomes a cross. Click and drag the handle down or across to automatically generate the rest of the sequence.

Select Multiple Cells to Establish the Sequence Pattern

Custom Sequences: This method also works for skipping numbers. If you want an even-number sequence, simply enter 2 and 4, highlight both, and drag.

Solution 2

Verify Fill Handle Preferences in Excel

If the fill handle is not appearing or functioning at all, the drag-and-drop preference might be disabled in your Excel settings.

Efficient Spreadsheet Editing

Create Number Sequences Easily in WPS Spreadsheet

WPS Spreadsheet offers an intuitive and seamless AutoFill feature that effortlessly creates numbers, dates, and custom sequences. It functions exactly as you expect, preventing formatting frustrations while providing an interface that feels instantly familiar.

1. Open your file: Launch WPS Office and open a new or existing spreadsheet.
2. Input sequence starters: Type the first two numbers of your desired sequence into two consecutive cells.
3. Select the pattern: Click and drag to select both cells so WPS Spreadsheet recognizes the incremental pattern.
4. AutoFill the sequence: Click and drag the small square fill handle at the bottom-right corner to automatically extend the sequence.

Smart AutoFill intelligently handles numbers, dates, and complex custom listsFully compatible with Microsoft Excel (.xlsx, .xls) files without formatting lossFree, lightweight, and delivers fast performance on macOS devicesFamiliar user interface requires no learning curve for immediate productivity

microsoft office alternative - wps office

Frequently Asked Questions

Why does AutoFill work perfectly for dates with just one cell but not numbers?

Spreadsheet software has built-in lists for standard temporal sequences like days of the week, months, and dates. Because these progress in a guaranteed pattern, Excel can auto-generate them from a single cell. Numbers, however, can increment by any amount, so two cells are required to define the rule.

Can I use AutoFill for negative numbers or decimals?

Yes. As long as you provide the first two cells of the sequence to establish the pattern, you can increment by negative integers (e.g., -5, -10) or decimals (e.g., 0.5, 1.0).

Is there a keyboard shortcut to fill down a sequence instead of dragging?

While there isn't a direct shortcut to auto-generate a sequence, you can fill the exact same value down by selecting the top cell and the empty cells below it, then pressing Command + D on your Mac. To generate a sequence without a mouse, you would need to use the Fill > Series menu command.

Office App Problems