Let’s see an example of how the auto-fill feature works in Excel.
We have some data right here and we want to use the Autofill feature to autofill the remaining numbers of this list.
The first two cells are clearly multiples of 8. This sets a pattern for Excel8️⃣
Now let’s see how Excel auto-fills the remaining cells.
All we need to do is select the first two cells (A1 and A2) and drag the Fill handle.
The results are as follows:
Did you notice how Excel picked up the pattern with only two entries? This shows how powerful the Autofill feature of Excel is💪
But its functionality is not only limited to filling series – it can do much more.
For instance, you can use the Autofill feature to copy cells. You can also fill series, years, months, days, weekdays, weekends, and copy formatting.
For example, write Monday in a cell. And drag the fill handle to the adjacent column (or cells); here’s what will happen.
Excel automatically fills the list for all the days of the week.
Now, if you click the small icon on the bottom right corner, a drop-down list will appear like this:
This gives you more auto-filling options to select from. Say we select the last option, Fill Weekdays, from the drop-down list.
The Autofill feature will fill the list with weekdays in the dataset only.
Yes, we get it. A list without weekends is just too boring 🙅♀️