Forum Discussion

wverheyen's avatar
wverheyen
Copper Contributor
Feb 25, 2021

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.

2 Replies

  • wverheyen 

    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.

     

Resources