Inside Microsoft Excel

Customize your fill series and speed up your data entry

Inside Microsoft Excel

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[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)