To show row number in alphabetic order, simply right this
formula is first location where you wish to start the alphabet i.e. A and then,
drag and paste the formula in rows below:
=SUBSTITUTE ((ADDRESS (1, ROW (A1), 4)), 1,"")
Same the case of alphabetical column numbers, at start point,
write the following formula and drag and paste on adjacent columns:
=SUBSTITUTE ((ADDRESS (1, Column (A1), 4)), 1,"")
