AutoFill A to Z
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
|