Hover over the lower-right corner of the cell until it’s a black plus sign. Click and hold the left mouse button and drag the plus sign over the cells you want to fill. And the series will be filled in automatically for you using the autofill feature.
Where is the autofill button in Excel?
The Fill button is in the Edit group, just below the AutoSum button (the button with the Greek sigma). When you select the Series option, Excel opens the Series dialog box. In the Type column, click the Autofill radio button, and then click the OK button in the Series dialog box.
How do I use AutoComplete in Excel?
Just do this:
- Select the cell with the formula and the adjacent cells you want to fill.
- Click Home > Fill and then select Bottom, Right, Top, or Left. Keyboard shortcuts: You can also press Ctrl+D to fill in the formula in a column below, or Ctrl+R to fill in the formula directly in a row.
What is the AutoFill feature in Excel?
What is AutoFill? Excel has a feature that allows you to enter data automatically. If you enter a predictable series (e.g. 1, 2, 3…days of the week, hours of the day), you can use the AutoFill command to automatically extend the series.
How to autofill Excel without dragging?
Quickly fill numbers into cells without dragging
- . Enter 1 in cell A1.
- Go to Home -> Edit -> Fill -> Series.
- In the Series dialog box, make the following selections: Series in: Columns. Genre: Linear. Step value: 1. Stop value: 1000.
- Click OK.
How to Autofill Excel 2016?
If, after copying a label or initial value to a range, you decide that you should have used it to fill a series, click the drop-down button that appears on the fill handle in the cell containing the last copied entry and then select Fill from Series Command from the AutoFill Options pop-up menu that appears.