Thread: AutoFill A to Z
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Hardeep kanwar Hardeep kanwar is offline
external usenet poster
 
Posts: 65
Default AutoFill A to Z

Thanks Jacob

"Jacob Skaria" wrote:

Dear Hardeep

To populate the series in a column starting from row 2 use
=CHAR(ROW()+63)
To populate the series in a row starting from col 2 use
=CHAR(COLUMN()+63)

Adjust the character code to make it between 65 and 90.

If this post helps click Yes
---------------
Jacob Skaria


"Hardeep kanwar" wrote:

There is an Option in Excel to AutoFill

Like want to Autofill Sunday ,Monday

or January, February
Or 1,2,3 like this

Is it Possible to Autofill A,b,c,d,e and on in a Column or row

Or I have type Manually

Thanks

Hardeep kanwar