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 the months. However, if you fill a row with a,b,c,d and you drag it with autofill, it copies the inputs instead of expanding to e,f,g, etc.
I guess it has been here before, but I am new here, trying to find a solution. Thanks for the help.
4 Replies
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.
You may create a custom list with the desired letters and then fill will recognize it.
Create or delete a custom list for sorting and filling data - Microsoft Support
Hi, thank you. It is a part of the solution, only limited to the new list you create. when the entries from the new lsit are used, it goes back to copying the previous list. I made a list from a-z, it goes x,y,z,a,b and so on.
