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
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 katifund.org in the Answers community.
Need even more help?
Expand also your skills
Get brand-new attributes first
Join katifund.org 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
Easy to follow
Didn't complement my screen
Not sufficient information
Not enough pictures
Any additional feedback? (Optional)
Thank you for your feedback!
English (United States) © katifund.org 2021