coyping down by rows in excell

  • Thread starter Thread starter pursu1t
  • Start date Start date
P

pursu1t

I would like to copy down by rows using letters (a...........z) Pleas
help me.

Thanx
 
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:D28 with the lower case letters a .... z
 
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
 
I'm afraid this doesn't work in xl 97.

Don't know about later versions ..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top