ExcelBanter - Columns are labeled as numbers in the grid!!

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

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

- - Columns are labeled as numbers in the grid!! (https://www.excelbanter.com/excel-discussion-misc-queries/204508-columns-labeled-numbers-grid.html)

Dinosaur Pete

Columns are labeled as numbers in the grid!!

Suddenly Excel is labeling my columns as 1,2,3,etc. instead of A,B,C, etc.
How do I change this back?

Thomas [PBD]

Columns are labeled as numbers in the grid!!

Pete,
R1C1 has been enabled.

ToolsOptionsGeneralR1C1 reference style. Uncheck this box.

--
--Thomas [PBD]
Working hard to make working easy.

"Dinosaur Pete" wrote:

Suddenly Excel is labeling my columns as 1,2,3,etc. instead of A,B,C, etc.
How do I change this back?

Dinosaur Pete[_2_]

Columns are labeled as numbers in the grid!!

Tom,

Thanks so much!!!!!!! I was pulling what little hair I have left out.

Pete

"Thomas [PBD]" wrote:

Pete,
R1C1 has been enabled.

ToolsOptionsGeneralR1C1 reference style. Uncheck this box.

--
--Thomas [PBD]
Working hard to make working easy.

"Dinosaur Pete" wrote:

Suddenly Excel is labeling my columns as 1,2,3,etc. instead of A,B,C, etc.
How do I change this back?

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