View original (French)

Pb EXCEL modification de L1c1 en A1

nad -  
 Marc- -
Hello,

I don't know how, but now the rows and columns in my EXCEL tables appear in R1C1 format instead of A1. I would like to switch back to A1 cells.
Thank you for letting me know how to do this.
Nad
Configuration: Windows XP Internet Explorer 7.0

2 réponses

Réponse 1 / 2
Charly
 
Under Excel 2007:

Excel logo => Excel Options => Formulas => Formula Manipulation
And uncheck "L1C1"
70
mmrru
 
Great, thank you for this very useful information.
0
Stiffy
 
Thank you very much!!!
0
hp
 
You're welcome :)
0
Marc-
 
Yes, but where do we find "options", especially since we don't have the right version of Excel?
0