ExcelBanter - Column Header is not in Letter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Column Header is not in Letter (https://www.excelbanter.com/excel-discussion-misc-queries/181487-column-header-not-letter.html)

jhunjayme

Column Header is not in Letter

the Excel Column Header is in number(1,2,3) instead of letters (A,B,C). How
can I change it?
--
Jhunex
Jeddah
Kingdom of Saudi Arabia

Bernard Liengme

Column Header is not in Letter

Use Tools | Options; open the General tab; uncheck the box "Use R1C1
references" near top left corner
best wishes from Canada
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"jhunjayme" wrote in message
...
the Excel Column Header is in number(1,2,3) instead of letters (A,B,C).
How
can I change it?
--
Jhunex
Jeddah
Kingdom of Saudi Arabia

All times are GMT +1. The time now is 10:04 PM.