How to AutoFill values when adjacen column contains Blanks

How to AutoFill values when adjacent / side column contains Blanks. Simple Solution to AutoFill Issue When Adjacent Column Contains Blanks. Fill values automatically when adjacent / side column contains blanks.

How to AutoFill data in a column?

One of Excel's coolest features is Double-clicking the fill handle. It is the fastest way to fill formulas down a long column. It can AutoFill hundreds or even thousands of numbers or dates or formulas in a split second. I don’t think that Excel users are not aware of this.

Now suppose you 1000 records in a excel worksheet and there is a value in the adjacent cell and you want to fill it till the end of the Data (1000 Records). You just double click the right lower corner of the cell and the data will be automatically filled. But if you have blank cells in the middle of the data then data will not fill till the end of the data. When you double-click the Fill Handle, AutoFill stops dead in it's tracks if there are blank cells in the adjacent column.

So, how to fill the data automatically even if the adjacent column have blank cells in the data?

Here is a very simple and easy trick to update / fill the values automatically even if the adjacent column has blank cells in the data.

One alternative, is to select the first cell containing the formula to be filled down, drag the vertical scrollbar to move quickly down to the last row, hold down the SHIFT key and click the last cell you want to fill. This will select all cells from the first to the last cell. Then press CTRL+D to copy the formula to all the selected cells.

Here is an easier way by hiding Column(s).

If there are blank cells in an adjacent column preventing the double-click AutoFill from working, a quick workaround is to hide the column(s) containing blank cells until you have an adjacent column that is completely filled and then use the double-click fill method as usual.

NOTE:- Don't forget to unhide your column(s).