This tutorial demonstrates how to autofill numbers without dragging the fill handle in Excel and Google Sheets.If you don’t want to use drag and drop or double-click to autofill numbers in Excel, you can achieve the same effect using the Fill command on the Ribbon....
The step value lets you define the sequence. So, for example, if your dates are 10/05/2017, 10/09/2017, 10/13/2017, etc., the step value is 4. Plug 4 into the box and press “OK.” Then, watch as the rows fill themselves… How to autofill in Excel without dragging In method...
Now, if you try to use thefill handleto drag values down in cells A1 and A2, you’ll see that there is no fill handle option. Disable AutoFill in Google Sheets In Google Sheets, there are no settings similar to Excel to turn Smart Fill off, but there is an option to disable autofi...
SelectFill Seriesfrom the menu and the series of numbers will be displayed. Solution 2 – TheSeriesAutofill is Not Working While Dragging the Last CellOnly ‘1’and‘3’are entered inB4 and B5. You want to create a series of numbers with a common difference of 2:1,3,5,7,9… Dragging...