by T. L. Thomas and Margaret Kavanagh
When creating worksheets, you may regularly use a series of associated items that aren’t numeric or date-related, and you probably end up typing the series each time. Rather than repeatedly typing (or copying and pasting from another worksheet), you can create a custom fill series.
Streamline data entry
The Fill feature can extend a data series based on a numerical value. Excel also automatically extends series based on calendar months[…]