Forum Discussion
Autofill with letters is giving different results on different PC
In a classroom setup I am seeing differnt resutls if I want to autofill a row with letters from A to J.
I am typing A and B in two cells and then try to use the autofill function.
On one PC the result is A,B,A,B (i.e. simple copy)
On another PC it is A,B,C,D,C,D,A,B,C,D,C,D (i.e. C and D is added as row and then copied omce, then restart from A)
On a third PC it is A,B,C,D,E,F,G,H,A,B (i..e. a row from A to H and then restart from A)
I checked for settings (you never know on classromm PC), but could not find any setting to change this behavior.
Any pointers?
THX
Juergen
- You may also enter this formula to get A to J instantly:
=CHAR(SEQUENCE(,10,65,1))
For A to Z:
=CHAR(SEQUENCE(,26,65,1))
4 Replies
- You may also enter this formula to get A to J instantly:
=CHAR(SEQUENCE(,10,65,1))
For A to Z:
=CHAR(SEQUENCE(,26,65,1))- Sorry - not intentionally marked as best answer as it was the answer from Sergei
Most probably it depends on which custom list was created on each PC. See at the end of this post Autofill with Letters in Excel - Universal Solutions 4 Business (us4b.co.uk)
THX - that was the trick
I am surprised that letters were not included in the standard lists
