Forum Discussion
wverheyen
Feb 25, 2021Copper Contributor
Different cell numbering within Excel
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.
HansVogelaar
Feb 25, 2021MVP
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.
- wverheyenFeb 25, 2021Copper Contributor
HansVogelaar perfect. Thanks for your help.