Use the Auto Fill feature to fill cells with information that complies with a pattern or are based on data in various other cells.

You are watching: Which of the following auto fill options menu options is the same as the fill series option?

Note: This post describes how to automatically fill worths into various other cells. It does not describe just how to enter data manually or at the same time throughout multiple worksheets.


Find even more videos on Mike Girvin"s YouTube channel, excelisfun.

Select one or even more cells you desire to usage as a basis for filling extra cells.

For a series like 1, 2, 3, 4, 5..., type 1 and also 2 in the first two cells. For the series 2, 4, 6, 8..., form 2 and 4.

For the series 2, 2, 2, 2..., kind 2 in initially cell only.

Drag the fill manage


If required, click Auto Fill Options 

and select the choice you desire.

See more: Too Bad You Will Die - Mortal Kombat 11 Ultimate On Twitter: Too Bad You

Need more help?

You deserve to always ask an experienced in the Excel Tech Community or acquire in the Answers community.


Need even more help?

Expand also your skills
Explore Training
Get brand-new attributes first
Join Insiders

A subscription to make the a lot of of your time
Try one month free

Was this information helpful?

Thank you! Any more feedback? (The more you tell us the even more we deserve to assist.) Can you assist us improve? (The even more you tell us the more we can aid.)

What impacted your experience?

Resolved my issue
Clear instructions
Easy to follow
No jargon
Pictures helped
Didn't complement my screen
Incorrect instructions
Too technical
Not sufficient information
Not enough pictures

Any additional feedback? (Optional)

Submit feedback

Thank you for your feedback!

What's new Store
English (United States) © 2021