Column titles A,B,C.... changing to 1,2,3....

[gheyman]

When you open a spreadsheet the top is always shows the columns as A, B, C, D... and the rows are always number 1,2,3,4..

When I click in a column the "Letters" and changing to numbers. I have never seen Excel do this. What's is happening to my spreadsheet???

It happened right after I ran into a bug in my VBA code that adds formulas to part of my sheet.

The formulas in the sheet are also now showing in the R1C1-Style References style and not A1 style

 

[Joe4]

Have a look here and see if this is what is going on: https://support.office.com/en-ie/ar...-letters-d43c23f2-7eec-4345-9c76-29858bd91a7e

If not, you may need to post your code, so we can see what it might have changed.

 

[gheyman]

In Options in the Formulas and then subsection "Working with Formulas" I unchecked "R1C1 reference style"


Thanks. Not sure why everything changes all of a sudden. Never had that happen before.

 

[Joe4]

Sorry, looks like those directions may be directed for towards Mac versions.
See here: https://www.techonthenet.com/excel/questions/column_letters2016.php