ExcelBanter

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

JCereda

why have column letters changed to numbers in excel
 
For some reason the column headings have changed from letters to numbers.
Row headings still appear with numbers. This is happening in all my excel
workbooks so it must be some sort of global change that I have inadvertantly
made. Does anyone know why and what I need to do to change it back. (Excel
in Office 2000.)

Many thanks

David Biddulph

"JCereda" wrote in message
...
For some reason the column headings have changed from letters to numbers.
Row headings still appear with numbers. This is happening in all my excel
workbooks so it must be some sort of global change that I have

inadvertantly
made. Does anyone know why and what I need to do to change it back.

(Excel
in Office 2000.)


Tools/ Options/ General:
Uncheck "R1C1 reference style"
--
David Biddulph




All times are GMT +1. The time now is 03:08 PM.

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