Read this article to be able to enter data automatically in worksheet cells. (For Office 365 and Excel 2010, 2013, 2016, 2019)
Use the Auto Fill feature to fill Excel cells with data that follows a pattern or is based on data in other cells .
Note: This article describes how to automatically enter values into other cells. It does not explain how to enter data manually or in multiple worksheets at the same time.
1. Select one or more cells that you want to use as a base to fill extra cells.
For series such as 1, 2, 3, 4, 5 and…, type the numbers 1 and 2 in the first two cells. For numbers 2, 4, 6, 8 and…, enter the numbers 2 and 4.
For series 2, 2, 2, 2 and…, just type 2 in the first cell.
2- Select the desired cells and click and drag on the small square on the right.
3- If necessary, click on the Auto Fill Options button Click and select the option you want.
But what if you have hundreds or thousands of rows? That’s a lot of dragging.
Next time, write your formula, then when you see the auto-fill handle double-click on it. Your formula automatically copies down to every row that has data next to it. And you know what ? It’s still handy if you only have 3 rows.