I want to make a list with the letters A...Z. Is it possible to do that with the auto fill feature through drag&drop or auto fill through the menu? For example if I use A, B, C as a "starting list". I tried various combination of selecting A-C and "dragging" and using the auto fill feature, but nothing worked (I got results like A,B,C,A,B,C...). Something I forgot to get the desired result? (If possible without manually adding an custom list).
From here (for example):
Column A A B C
and I want to get to this:
Column A A B C D E F G [...] Z
Please note: I want to have values inside the cells, not formulas.