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 answers

  1. Charly
     
    Under Excel 2007:

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