So, no gaps are lying now between these two columns. Now the data from Column D have been transferred to Column C. Due to the presence of blank cells in Column C, the Fill Handle with double-click won’t function properly in the distinct column. The problem lies within the gap between Column B and Column D. Now if we try to double-click the Fill Handle option in D5, we’ll find that it’s not working at all. There is a gap between these two columns which has made these columns distinct from each other. And Column D has two numbers only, 1 and 3 in D4 and D5.
HOW TO DO FLASH FILL ON MAC SERIES
In this example, we’ll see what’s wrong with using the Fill Handle option when two distant columns are present in the same worksheet.Īssuming that Column B has a series of numbers starting from 1. Excel Autofill Not Working in Distant Column in Same Worksheet
HOW TO DO FLASH FILL ON MAC HOW TO
Read more: How to Fill Down to Last Row with Data in Excelģ. After selecting the cells, we have to use the Fill Handle option from Cell B5 to drag down to the last Cell B10.Īnd finally, we’ll get the proper series of numbers without getting any repetition as displayed in the screenshot below. To get a proper arithmetic series, we have to select the range of cells available in the column first. That means our arithmetic series should look like this: 1,3,5,7,9…īut if you drag down only 3 from Cell B5 then you’ll find the repetitions of 3 only as shown in the following picture. What we want here is to make a series of numbers with a common difference of 2. Let’s assume, we have two numbers ‘1’ and ‘3’ in B4 and B5 respectively. Now let’s think of a case where multiple cells are occupying a series of numbers and you have to fill the next cells by following the series. Autofill of Series Not Working While Dragging Only Last Cell
![how to do flash fill on mac how to do flash fill on mac](https://support.content.office.net/en-us/media/f0368a80-9bf0-4cc7-902b-b764687d82ae.png)
After you select the related option, you’ll find the series of numbers starting from 1 in Column B immediately.Ģ. In the picture below, you’re seeing the option Fill Series from the menu.
![how to do flash fill on mac how to do flash fill on mac](https://i.ytimg.com/vi/lCVOmWdy1Hc/maxresdefault.jpg)
To get a series of numbers (1,2,3…), we have to use the Fill Series option manually. But we have got the repetitions of 1 in return. In Column B, the FIll Handle has been used here to make a series of numbers starting from ‘1’. Here is our first case in the following picture. Getting Repetitions of a Number Instead of a Series While Using Autofill
![how to do flash fill on mac how to do flash fill on mac](https://yodalearning.com/wp-content/uploads/Flash-Fill-in-Excel.png)
Issues That May Cause Autofill Not Working Properly in Excel 1.