Sure, Excel can fill January, February, March, but what about A, B, C or I, II, III?
For the upper case alphabet, use a formula of =CHAR(ROW(65:65)) and copy down.
For the lower case alphabet, use =CHAR(ROW(97:97))
For upper case Roman numerals: =ROMAN(ROW(1:1))
For lower case Roman numerals =LOWER(ROMAN(ROW(1:1)))
Tip: After filling any of these, copy and Paste Values so the list does not change when someone inserts rows in the 65-91 range.
Note: Custom lists could also solve this problem, but that is a Quick Tip for another day. (If you can’t wait, turn to page 79 in the book).