Displaying X and Y Axes in Excel

veheme Posted messages 1 Status Membre -  
 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 réponse

PHILOU10120 Posted messages 6463 Registration date   Status Contributeur Last intervention   833
 
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.
22
ESOR
 
And on Excel 2017??
0
Juho
 
Simple, clear, precise, effective: thank you PHILOU10120!
0