ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Column headings (https://www.excelbanter.com/excel-discussion-misc-queries/182883-column-headings.html)

MACAVITY500

Column headings
 
I have just opened a workbook and found my column headings have suddenly
changed from letters ABC etc to numbers! This does not happen in new books so
what can I do to get letters at the top of my columns?
This is very annoying for fromulas etc

muddan madhu

Column headings
 
Go to tools | Options | General tab | uncheck R1C1 reference sytle |
ok


On Apr 8, 5:24*pm, MACAVITY500
wrote:
I have just opened a workbook and found my column headings have suddenly
changed from letters ABC etc to numbers! This does not happen in new books so
what can I do to get letters at the top of my columns?
This is very annoying for fromulas etc




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

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