drag or double-clickFilling handleColumn fill icons are one of the most useful features in Excel. Using this feature, we can reproduce formulas or values to a large extent in a very short time. However, when working with drag to fill, there can be issues that cause it to not work properly or at all. This article will present solutions to all the problems that can cause Excel transfer completion to not work.

**Content** to hide

DOWNLOAD THE WORKBOOK

8 Possible Solutions for Excel Not Working

Solution 1: Turn on the charging dock mode

Solution 2: Change calculation options

Solution 3: Use other autocomplete options

Solution 4: Disable the filter

Solution 5: Select all values before dragging the fill handle

Solution 6: Remove spaces between columns

Solution 7: Enter sufficient values before withdrawal

Solution 8: Fix the autocomplete feature

in conclusion

Relevant Articles

## DOWNLOAD THE WORKBOOK

You can download a workbook that contains the examples we use in this article.

Drag to fill Not Working.xlsx

## 8 Possible Solutions for Excel Not Working

In this guide, we will discuss a total of eight possible solutions. Try each one in case it doesn't work. Hopefully the drag to fill feature will work again in Excel.

### Solution 1: Turn on the charging dock mode

When the Handle Fill option is first disabled in Preferences, Excel's fill handle icon may not work or appear at all. If it is disabled, do the following to enable the fill handles option in Excel.

**rhythm:**

- Click first
**document**Cards on tape. - then select
**choices**.

- result,
**Excel options**The box will open. now go**Advanced**cards on the left side of the frame. - then check it out
**Enable fill handles and drag and drop cells**options below**editing options**group on the right.

- Finally, click
**Well**.

This will fix the problem if you have selected a range in Excel if the transport icon for the fill handle does not appear at all.

**Read more:How to Enable Formula Transfer in Excel (Use Quick Steps)**

### Solution 2: Change calculation options

If your option is enabled to enable the fill handle icon in Excel preferences, but drag to fill doesn't work for formulas, it may be because**calculation capabilities**The setting is incorrect.

Normally this option is set to Automatic. So, if you chose the manual option or chose it for some reason, you'll find that Excel's drag to fill feature doesn't work with formulas.

Follow the steps below to reset it to automatic.

**rhythm:**

- First, choose
**officially**Cards on tape. - choose now
**calculation capabilities**from**calculate** - then select
**automatic**from the drop-down menu.

As a result, you will see that Excel's fill drag feature not working with formulas has been fixed. The carry to fill function should now work for both rows and formulas.

**Read more:[Fixed! ] Excel drag to fill not working (8 possible solutions)**

### Solution 3: Use other autocomplete options

Sometimes when you use Excel's drag and fill feature for a table, you find that it doesn't work as expected. Maybe you want a specific row, but drag and drop is a full copy or vice versa.

For example, suppose we have the following cell.

Now we want it to look like this after the pull.

But it seems to charge like this.

vice versa. In any case, follow the steps below to resolve the issue.

**rhythm:**

- First, select the cells and drag the fill handle icon all the way to fill in the values.

- When you're done dragging and clicking, you'll see an autocomplete option appear in the bottom right corner of the selection. Click now.

- This will bring up a drop down list. From here, select your desired fill option. In our example,
**copy the cell**option is selected. but we need**Batch loading**.

- Once you make this selection, you will see the drag fill change to the desired order.

Therefore, you may find that Excel's drag to fill does not resolve the desired string.

**Read more:[SOLVED]: Fill Handle Not Working in Excel (5 Easy Fixes)**

### Solution 4: Disable the filter

Some users reported that Excel's transport to fill function was not working on tables when the filter option was enabled. So disabling the filter option will solve the problem.

If there is a filter in the header, you can simply select a table or column and click**Ctrl+Shift+L**on your keyboard or follow the steps below.

**rhythm**:

- First, go to
**Dom**Cards on tape. - then select
**sorting and filtering**lobe, below**processing**club. - After this click
**blankets**Enable/disable filters from the drop down menu.

**Read more:How to Drag a Formula in Excel Using the Keyboard (7 Easy Ways)**

### Solution 5: Select all values before dragging the fill handle

You may find that it doesn't work properly when you drag to fill Excel and don't select all the table values before dragging. For this reason, you may find that the draw function fills the array with the wrong string or irrelevant numbers.

For example, suppose we need to complete the following sequence.

But before pulling, only the last cell is selected. As a result of the transfer, you will see that your batch may look something like this.

**rhythm:**

- For this question, select all cells in a row.

- Now click and drag the fill handle icon to the cell you want to expand the table to. As a result, the batch will fill as expected.

**Read more:Fill Up to the Next Value in Excel (5 Easy Ways)**

### Solution 6: Remove spaces between columns

If you double-click the fill handle icon to fill values in a column, but there are no adjacent columns, it simply won't work. The double-click fill function uses the column next to it as a reference length. If not, you will not get the reference length. So this excel fill function will not work.

For example, pay attention to the following columns.

In this case the tables are in columns**But**I**Man**Between them is a column of spaces. So if you select a row in a column**Man**and double click the charging handle icon, it doesn't work.

To fix this, place the strings next to each other to remove the gaps between them.

Now select the second batch and double click on the fill handle icon. This way you will see that the function works well.

**Read more:How to drag formulas horizontally with vertical references in Excel**

### Solution 7: Enter sufficient values before withdrawal

Sometimes when you use Excel's Drag to Fill feature, you may find that it doesn't fill the table with the appropriate data. Even if you have tried and applied all the solutions above. In some cases, the problem is a lack of batch data.

For example, notice the following two rows.

If you select all the data in both tables and drag it to fill the rest, you will see that the tables are different.

To eliminate this problem, first enter several values in the table. This will allow Excel to populate the table with the desired values.

**Read more:How to drag a formula in Excel and ignore hidden cells (2 examples)**

### Solution 8: Fix the autocomplete feature

Quick Fill is another useful feature that quickly fills in column values. Typically, this function recognizes a pattern from a set of reference cells and previous input values and returns results for the remainder.

So, if there is no common pattern in the data set, this function will not work.

For example, consider the following data set.

In this case, we just want to extract text values with letters from the column**But**.Now, if we use the quickfill function to fill in the values of this data set, the result will be this.

Here we can see the value in the cell**C3**It's 49. But our purpose is to get the GOP out of the cells**B7**.Since the first two entries we get the value before the hyphen (-), Excel's flash function recognizes this as a pattern and puts whatever is before the hyphen into the rest of the column.

Unfortunately, to solve this autocomplete problem, the only possible solution is to optimize the source text in the dataset. This way it matches the pattern that Excel needs to look for. So autocomplete should work fine. See the following data set, cell value**B7**Modified here so that the autocomplete correctly fills in the correct value.

So this will solve the problem of excel autocomplete not working properly.

## in conclusion

These are all possible solutions for excel fill not working. We hope one of these solutions did the job for you and you found this guide useful and informative. If the issue is still not resolved or you have questions, please let us know below. For more detailed fixes and instructions on this visitExceldemy.com.

## Relevant Articles

- Transferring numbers to increment not working in Excel (the solution in easy steps)
- How to Fill the Last Row with Data in Excel (3 Quick Ways)
- [Fixed! ] Pull down Excel VLOOKUP not working (11 possible solutions)
- How to Fill a Formula in a Specific Row in Excel (7 Easy Ways)