Forum Discussion
Autofill with only letters instead of numbers
If you do the autofill on numbers, months etc, it runs as expected. a row of 1,2,3,4 with the autfill dragged down gives 5,6,7, and so on. jan, feb, mrt (sorry dutch) does the same for the rest of th...
How about this?
- Enter the starting letter in the first cell (e.g., A1 with "a").
- In the next cell, use the following formula to get the next letter:
=CHAR(CODE(A1) + 1) - Drag the formula down to fill the subsequent cells.
Hi, thank you. It might work but it is too complicated. tested it and the result came in not as i wanted, have to name a cell. I like to drag autofill with letters like with numbers, for ex: 1,2,3, draggin goes to 4,5,6, etc. Like it works in Numbers from apple.