ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   why have my column headings changed to numbers (https://www.excelbanter.com/excel-discussion-misc-queries/232575-why-have-my-column-headings-changed-numbers.html)

L Bentley

why have my column headings changed to numbers
 
Recently all my spreadsheets column heading have changed from letters to
numbers. Could anyone explain why this is and how do I change it back to how
it was.

Jacob Skaria

why have my column headings changed to numbers
 
Uncheck 'R1C1 reference style' from ToolsOptionsGeneral Tab

If this post helps click Yes
---------------
Jacob Skaria


"L Bentley" wrote:

Recently all my spreadsheets column heading have changed from letters to
numbers. Could anyone explain why this is and how do I change it back to how
it was.



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

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