Column Headings

  • Thread starter Thread starter lsg
  • Start date Start date
L

lsg

My column headings show numeric numbers instead of alpha. How do I change
the heading bar back to alpha (A,B,C,D....AA,AB, etc.)
 
From the Main Menu Select:
Tools->Options
Click on the "General" Tab and remove the check mark from the box that reads:
"R1C1 Reference Style"

--
If this posting was helpful, please click on the Yes button on the bottom
right of this window.
Regards,

Michael Arch.
 
lsg said:
My column headings show numeric numbers instead of alpha. How do I change
the heading bar back to alpha (A,B,C,D....AA,AB, etc.)
Click to expand...


Tool / Options / General / R1C1 reference style (un-check)
 
Hi

Just in case you are using XL2007, the method would be
Round Office button>Excel options>Formulas>Working with formulas>uncheck
R1C1 reference style

--
Regards
Roger Govier

lsg said:
My column headings show numeric numbers instead of alpha. How do I change
the heading bar back to alpha (A,B,C,D....AA,AB, etc.)

__________ Information from ESET Smart Security, version of virus
signature database 4530 (20091021) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...

__________ Information from ESET Smart Security, version of virus signature database 4530 (20091021) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top