ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to change Colomn headings from (1,2,3,) to (A,B,C,) (https://www.excelbanter.com/excel-discussion-misc-queries/249721-how-change-colomn-headings-1-2-3-b-c.html)

hana

How to change Colomn headings from (1,2,3,) to (A,B,C,)
 
How to change Colomn headings from (1,2,3,) to (A,B,C,)

Stefi

How to change Colomn headings from (1,2,3,) to (A,B,C,)
 
ToolsOptionsGenaral tabUncheck R1C1 reference style4

Regards,
Stefi

€˛HANA€¯ ezt Ć*rta:

How to change Colomn headings from (1,2,3,) to (A,B,C,)


trip_to_tokyo[_3_]

How to change Colomn headings from (1,2,3,) to (A,B,C,)
 
In EXCEL 2007:-

- Office Button

- Excel Options

- Formulas

- Working with formulas (there is a toggle in here called R1C1 reference
style - change the setting here)

If my comments have helped please hit Yes.



"HANA" wrote:

How to change Colomn headings from (1,2,3,) to (A,B,C,)


David Biddulph[_2_]

How to change Colomn headings from (1,2,3,) to (A,B,C,)
 
Tools/ Options/ General
Unset: R1C1 reference style
--
David Biddulph


"HANA" wrote in message
...
How to change Colomn headings from (1,2,3,) to (A,B,C,)





All times are GMT +1. The time now is 11:46 PM.

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