ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   columns read 1,2,3 rather than A,B,C (https://www.excelbanter.com/excel-programming/386933-columns-read-1-2-3-rather-than-b-c.html)

Clueless in Indio

columns read 1,2,3 rather than A,B,C
 
Column headings are numbered rather than A B C. If I open a new worksheet, it
is also numbered. I probably had too many files open and Excel froze - I
couldn't close the files and had to shut down.

Vergel Adriano

columns read 1,2,3 rather than A,B,C
 
Hi,

Go to Tools-Options, in the General tab, make sure "R1C1 reference style"
is NOT checked...


--
Hope that helps.

Vergel Adriano


"Clueless in Indio" wrote:

Column headings are numbered rather than A B C. If I open a new worksheet, it
is also numbered. I probably had too many files open and Excel froze - I
couldn't close the files and had to shut down.



All times are GMT +1. The time now is 06:12 PM.

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