[Fixed! ] Excel transfer not working (8 possible solutions) - ExcelDemy (2023)

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.

DOWNLOAD THE WORKBOOK

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

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 firstdocumentCards on tape.
• then selectchoices.

• result,Excel optionsThe box will open. now goAdvancedcards on the left side of the frame.
• then check it outEnable fill handles and drag and drop cellsoptions belowediting optionsgroup on the right.

• Finally, clickWell.

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 becausecalculation capabilitiesThe 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, chooseofficiallyCards on tape.
• choose nowcalculation capabilitiesfromcalculate
• then selectautomaticfrom 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 celloption is selected. but we needBatch 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 clickCtrl+Shift+Lon your keyboard or follow the steps below.

rhythm:

• First, go toDomCards on tape.
• then selectsorting and filteringlobe, belowprocessingclub.
• After this clickblanketsEnable/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 columnsButIManBetween them is a column of spaces. So if you select a row in a columnManand 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 columnBut.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 cellC3It's 49. But our purpose is to get the GOP out of the cellsB7.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 valueB7Modified 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)