Auto Fill/Sequential Numbering
Oops ... misread you posting so ignore my crass reply!
"Toppers" wrote:
Highlight cells A1 to A3 and then drag down.
or
Highlight A1, then hold Ctrl and drag down.
Both should work.
"tjh" wrote:
Hello,
I am trying to use the autofill feature to drag the letters for sequential
numbering/lettering.
It works for numbers 1, 2 ,3 then automatically drags in 4, 5, 6. But for
letters it is just copying.
For instance, I have
A in cell A1
B in cell A2
C in cell A3
and then I want to highlight and drag down so that
D is in A4
E is in A5
F is in A6
Do I need to change an option to get this to work?
Thank you,
|