Different cell numbering within Excel

New Contributor

Since a few weeks the format of cells is i.e. Z1S1 instead of A1. That makes it more complicate to work with cells. How can I get back to A1-Format?

Thanks for any help in advance.

2 Replies


Select File > Options.

Select Formulas in the navigation pane on the left.

Clear the check box 'R1C1 reference style'.

Click OK.


Wählen Sie Datei > Optionen.
Wählen Sie links im Navigationsbereich Formeln aus.
Deaktivieren Sie 'Z1S1-Bezugsart'.
Klicken Sie OK.


@Hans Vogelaar perfect. Thanks for your help.