Nov 03, 2016 · How to Automatically Fill Sequential Data into Excel with the Fill Handle Lori Kaufman @howtogeek November 3, 2016, 10:24am EDT The Fill Handle in Excel allows you to automatically fill in a list of data (numbers or text) in a row or column simply by dragging the handle. Press the LEFT mouse button and drag to select the cells to auto fill (figure 2). Release the mouse button and the worksheet cells are autofilled (figure 3). There are two other methods in Microsoft Excel to autofill a linear series that you may find of interest though they require more steps.

Return value. Variant. Example. This example performs an autofill on cells A1:A20 on Sheet1, based on the source range A1:A2 on Sheet1. Before running this example, type 1 in cell A1 and type 2 in cell A2. Aug 02, 2018 · If you wanted to fill a series of cells in Excel with the numbers 1 through 100, you could do it the hard way by manually typing each number, one cell at a time. Or, you could choose the easy way by using the autofill Excel feature. Autofill is a feature in Excel where Excel completes a series that you begin. Using the example above, the ...