Try it!
Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells. Watch this video from community expert Mike Girvin to learn how.
-
Select the cell or cells you want to use as a basis for filling additional cells.
Note: If you want a series like 1, 2, 3, 4, 5..., type 1 and 2 in the first two cells. If you want the series 2, 4, 6, 8..., type 2 and 4. If you want the series 2, 2, 2, 2..., you can leave the second cell blank.
-
Drag the fill handle
-
If needed, click Auto Fill Options
Want more?
Need more help?
Want more options?
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
