View original (French)

Displaying X and Y Axes in Excel

veheme Posted messages 1 Status Member -  
 Juho -
My display settings in Excel 2013 changed unintentionally. Vertically, I still have a ruler with a series of numbers, but horizontally, I no longer have a series of letters—just another series of numbers.
When I click on a formula, I can no longer see the formula with the correct cell references from which it originates.
Thank you for your help.

1 answer

  1.
    PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835
     
    Hello

    I'm not sure if I understood correctly

    File
    Options
    Formulas
    Uncheck the box in front of L1C1 reference style

    --
    It is by forging that one becomes a blacksmith. - It is at the foot of the wall that one sees the mason - one always learns from one's mistakes.
    23
    1. ESOR
       
      And on Excel 2017??
      0
    2. Juho
       
      Simple, clear, precise, effective: thank you PHILOU10120!
      0