ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Column Headings (https://www.excelbanter.com/excel-worksheet-functions/246178-column-headings.html)

LSG

Column Headings
 
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.)

Michael Arch

Column Headings
 
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" wrote:

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.)


Glenn

Column Headings
 
lsg wrote:
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.)



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

David Biddulph[_2_]

Column Headings
 
Tools/ Options/ General
Unset R1C1 reference style.
--
David Biddulph

lsg wrote:
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.)




Roger Govier[_3_]

Column Headings
 
Hi

Just in case you are using XL2007, the method would be
Round Office buttonExcel optionsFormulasWorking with formulasuncheck
R1C1 reference style

--
Regards
Roger Govier

"lsg" wrote in message
...
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




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

The message was checked by ESET Smart Security.

http://www.eset.com





All times are GMT +1. The time now is 07:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com