Excel’s AutoFill feature is a great timesaver to create series of numbers or lists of days/months. Even better though is the ability to create your own series of values, e.g. a list of departments or branches of the company.
- Select File | Options | Advanced
- Scroll to the General section | select Edit Custom Lists
- Select NEW LIST in Custom lists
- Enter first series value | select Enter | repeat for whole list
- Once complete select Add | OK
