R1C1 reference style as default while opening Excel

  • Thread starter Thread starter Pavol Cernak
  • Start date Start date
P

Pavol Cernak

Excel 2007

When I open Excel (by clicking on Excel shortcut or directly a file), it everytime opens in the R1C1 reference style. I don´t use this style in 99% of my work. It´s pretty harassing me to put it back to A1 style.

How to get rid of this?

Thanx for your time to help me.

P.
 
Hi Pavol,

Am Tue, 23 Jul 2013 00:03:09 -0700 (PDT) schrieb Pavol Cernak:
When I open Excel (by clicking on Excel shortcut or directly a file), it everytime opens in the R1C1 reference style. I don´t use this style in 99% of my work. It´s pretty harassing me to put it back to A1 style.

How to get rid of this?
Click to expand...

Excel-Options => Formulas => Working with formulas and deactivate
R1C1 reference style


Regards
Claus B.
 
Hi Claus,

thanx, this is clear. But next time I start Excel, it is the same - R1C1 :-(.
I suppose there must be a problem with some .ini file or something like this.

P.
 
Excel 2007



When I open Excel (by clicking on Excel shortcut or directly a file), it everytime opens in the R1C1 reference style. I don´t use this style in 99% of my work. It´s pretty harassing me to put it back to A1 style.



How to get rid of this?



Thanx for your time to help me.



P.
Click to expand...

There was a problem with the PERSONAL.xls file set up. I fixed it in that file and everythig works well.
 
Back
Top