Function Problems

Fix Excel AutoFill Not Continuing Number Sequences on Mac

Maira Mehtab Sep 22, 2026 869 views

Question details

The user is experiencing an issue where dragging the Excel fill handle on a Mac copies the same number instead of generating a sequential list of numbers.

Product: Excel for Microsoft 365
Device & OS: Mac
Scenario: Trying to automatically fill a column or row with a sequence of numbers using the fill handle.
Observed behavior: Excel repeatedly copies the first number into the selected cells instead of continuing the numeric sequence.

Before you start

Ensure your Mac operating system and Excel for Microsoft 365 application are updated to the latest versions to rule out any temporary software glitches.

Solution 1Recommended

Establish the Sequence Pattern with Two Cells

Excel needs at least two numbers to recognize a sequence pattern. Providing only one number will usually cause Excel to copy it.

By default, if you only highlight a single cell containing a number and drag the fill handle, Excel assumes you want to duplicate that data. Providing a second number establishes a mathematical pattern for Excel to follow.

Enter the first number

Type '1' (or your preferred starting number) in the first cell.

Enter the second number

Type '2' (or the next logical number in your sequence) in the cell directly below or next to the first one.

Select both cells

Click and drag your cursor to highlight both cells containing your numbers.

Drag the fill handle

Click the small green square at the bottom-right corner of the selection and drag it down or across. The sequence will now continue properly.

Alternative Method: You can also drag a single cell and then click the small 'AutoFill Options' icon that appears at the bottom right of the selection. Choose 'Fill Series' from the dropdown menu.

Solution 2

Enable Fill Handle in Excel Preferences

If the fill handle isn't working at all or the crosshair cursor doesn't appear, the feature might be disabled in your Mac Excel settings.

Try WPS Spreadsheet

Easily AutoFill Number Sequences in WPS Office

WPS Office provides a highly compatible and user-friendly spreadsheet tool. Generating number sequences is seamless, intelligent, and works exactly as you expect on Mac.

1. Open WPS Spreadsheet: Launch WPS Office on your Mac and open a new or existing Spreadsheet.
2. Type your sequence: Enter '1' in a cell, then click and hold the fill handle at the bottom right corner.
3. Select Fill Series: Drag down to fill the cells, click the small AutoFill Options icon that appears, and choose 'Fill Series' to complete the sequence.

Smart AutoFill recognizes numeric patterns instantly.Fully compatible with Microsoft Excel (.xlsx, .xls) formats.Lightweight and runs smoothly on all macOS versions.Free to download and use with a familiar interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why is Excel just copying the text instead of filling a series?

By default, if you only select a single cell with a number and drag the fill handle, Excel copies that number. You must select two cells to establish a pattern, or use the AutoFill Options button after dragging to choose 'Fill Series'.

Where is the AutoFill options button on Mac?

After you drag the fill handle to populate adjacent cells, a small square icon appears at the bottom right of your filled selection. Clicking this icon opens the AutoFill Options menu where you can switch from 'Copy Cells' to 'Fill Series'.

Does the Mac version of Excel handle AutoFill differently than Windows?

The core functionality is identical. However, the settings menu on Mac is located under Excel > Preferences > Edit, whereas on Windows it is accessed via File > Options > Advanced.

What if dragging the fill handle doesn't do anything at all?

If the cursor doesn't change to a black cross and dragging does nothing, the drag-and-drop feature is likely disabled. Go to Excel > Preferences > Edit and check 'Allow fill handle and cell drag-and-drop' to re-enable it.

Excel & Data Problems