Excel 2002: Can I fill alphabetically ?

  • Thread starter Thread starter Mr. Low
  • Start date Start date
M

Mr. Low

Hi,

Happy New Year 2010.

May I know if I can fill A,B, C,.. ZZ across and downwards ?


Thanks

Low
 
Same approach but "a little shorter":
=SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","")
Micky
 
Thamks

Low
מיכ×ל (מיקי) ×בידן said:
Same approach but "a little shorter":
=SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","")
Micky
Click to expand...
 
Glad to help.
Please note that although you mentioned ZZ - Gary''s Student formula will
present up to 2(!) Letters only.
Those who need to present and/or use ALL 2^14 Columns letters in Excel
"2007/2010" should consider to use my suggestion.
Micky
 
Just to point out, if you change the 3 in Gary''s Student's formula to a 4,
it will work for up to 3 letters, so it is easily modified to handle
XL2007/2010 worksheets as well.

With that said, I would still use *your* formula as it involves one less
function call, so it should be ever so slightly more efficient.
 
Back
Top