cancel
Showing results for 
Search instead for 
Did you mean: 

Excel column identities

penneck
Pro
Posts: 1,289
Thanks: 108
Registered: ‎03-08-2007

Excel column identities

All of a sudden, any new Excel files have the columns identified with numbers instead of letters - for example R4C7. The older Excel files aren't affected by this - they still identify each cell such as D7.

I haven't been able to find the way back to the older IDs. Does anyone know the cause and the solution, please?

Thankyou

2 REPLIES 2
PhilipHeyes
Seasoned Champion
Posts: 1,407
Thanks: 586
Fixes: 28
Registered: ‎10-11-2021

Re: Excel column identities

"R1C1 reference style"   is enabled for formulas.


File >> Options >> Formulas >> R1C1 reference style ( tick to enable / clear to disable ) 

penneck
Pro
Posts: 1,289
Thanks: 108
Registered: ‎03-08-2007

Re: Excel column identities

Thankyou @PhilipHeyes   that did the trick. It was well hidden though, and doesn't explain why it got set in the first place.

All the best