P
pursu1t
I would like to copy down by rows using letters (a...........z) Pleas
help me.
Thanx
help me.
Thanx
M
Max
One guess as to what you want?
Put in any cell, say in D3: =CHAR(ROW(A1)+96)
Copy down the col a total of 26 rows (till D28)
This will "fill" D3
28 with the lower case letters a .... z
Put in any cell, say in D3: =CHAR(ROW(A1)+96)
Copy down the col a total of 26 rows (till D28)
This will "fill" D3
28 with the lower case letters a .... z
P
Phaedrusz
I'm not sure what you're asking, but if you want to have an incremen
series, i.e.
a
b
c
d
...
Than put "a" in the first cell, then drag the autofill handle, (th
little square on the bottom right corner) to where you want. It'll fil
in the series automaticall
series, i.e.
a
b
c
d
...
Than put "a" in the first cell, then drag the autofill handle, (th
little square on the bottom right corner) to where you want. It'll fil
in the series automaticall
M
Max
I'm afraid this doesn't work in xl 97.
Don't know about later versions ..
Don't know about later versions ..
D
David McRitchie
You could create a series Tools, Options, Custom Lists
A,B,C,D,E,....,X,Y,Z,a,b,c,d,e,....,x,y,z
or you could use something like
=CHAR(96+ROW())
Then use the fill handle to copy either down
http://www.mvps.org/dmcritchie/excel/fillhand.htm
A,B,C,D,E,....,X,Y,Z,a,b,c,d,e,....,x,y,z
or you could use something like
=CHAR(96+ROW())
Then use the fill handle to copy either down
http://www.mvps.org/dmcritchie/excel/fillhand.htm