Now, all you have to do is double-simply click that icon and Excel will routinely autofill your complete column, but only down to where the adjacent column really has data. To get a drop down record with numerous values, locating a appropriate one will not be a fairly easy work. http://howtoautofillmonthsinexce35019.idblogz.com/2594237/the-basic-principles-of-how-to-turn-off-autofill-in-excel