Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells.
Note: This article explains how to automatically fill values into other cells. It does not explain how to enter data manually or simultaneously across multiple worksheets.
![Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.](https://cxcs.microsoft.net/static/public/surface-and-devices/neutral/4873755a-8b1e-497e-bc54-101d1e75d3e7/d07c07fd6aabfe12ed716e87301dc3a1a3a7b5b0.png)
Find more videos on Mike Girvin's YouTube channel, excelisfun.
-
Select one or more cells you want to use as a basis for filling additional cells.
For a series like 1, 2, 3, 4, 5..., type 1 and 2 in the first two cells. For the series 2, 4, 6, 8..., type 2 and 4.
For the series 2, 2, 2, 2..., type 2 in first cell only.
-
Drag the fill handle
. -
If needed, click Auto Fill Options
and choose the option you want.
Need more help?
You can always ask an expert in the Excel Tech Community or get support in Communities.