# The Excel Autofill is Not Working – 7 Issues and Solutions

### Solution 1 –Â  Getting Repetitions of a Number Instead of a Series While Using Autofill

In Column B, the Fill Handle was used to make a series of numbers starting from â€˜1â€™. But repetitions of 1 were returned. To get a series of numbers (1,2,3â€¦), use the Fill Series option manually.

Select Fill Series from the menu and the series of numbers will be displayed.

### Solution 2 – The Series Autofill is Not Working While Dragging the Last Cell Only

â€˜1â€™ and â€˜3â€™ are entered inÂ B4 and B5. You want to create a series of numbers with a common difference of 2: 1,3,5,7,9…Â

Dragging down the Fill Handle fromÂ B5 returns repetitions.

Select the column first. Here, B4 and B5.

Use the Fill Handle in B5 and drag it down toÂ B10.

The correct series of numbers is displayed.

### Solution 3 – The Excel Autofill is Not Working in Distant Columns in the Same Worksheet

Column B has a series of numbers starting from 1. Column D has two numbers only, 1 and 3 in D4 and D5.

If you double-click the Fill HandleÂ in D5, it won’t fil the series due to the gap between Column B and Column D andÂ the presence of blank cells in Column C.

Transfer the data in Column D to Column C.

Double-click the Fill Handle to see the series of numbers.

### Solution 4 – The Fill Handle Option Is Not Enabled in Excel

To enable the Fill Handle option manually:

• In Excel Options, go to the Advanced tab.
• Â In Editing Options bar, check â€˜Enable fill handle and cell drag-and-dropâ€™ and â€˜Enable AutoComplete for cell valuesâ€™.
• Click OK.

### Solution 5 – The Autofill is Not Functioning Properly with a Filtered Table

To remove the Filter, press CTRL+SHIFT+L.

### Solution 6. The Automatic Calculation Is Turned Off

In the following dataset,Â C4 contains a value (calculated by multiplying the value inÂ B4 with 5).

The Fill Handle will show repeated values, beacuse the Automatic Calculation is turned off.

Go to Formulas. In Calculation Options, choose â€˜Automaticâ€™.

This is the output.

Read More: [Fix] Auto Fill Options Not Showing

### Solution 7. The Autofill with Flash Fill is Not Working Properly

The Flash Fill option looks for a particular pattern in a column for a specified cell value and then extracts data by following the pattern.

The dataset contains text values in Column B under the Text header. To extract the country names, useÂ the Flash Fill option.

Extract the country name manually from the first cell only and enter it in C5. Use the Fill Handle to autofill the column and select the Flash Fill option.

Flash Fill option found a pattern and extracted the values between two hyphens.

Data must be arranged in a specific pattern as shown below in Column B.

## AutoFill Not Working: Knowledge Hub

<<Â Go Back toÂ Excel AutoFill

Get FREE Advanced Excel Exercises with Solutions!

NEHAD ULFAT is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including ABACUS, AutoCAD, Rhinoceros, Maxsurf, and Hydromax. He got his B.Sc in Naval Architecture & Marine Engineering from BUET but switched gears, working as a content developer.Â  In this role, he creates techy content all about Excel... Read Full Bio