Cell names have changed

%3CLINGO-SUB%20id%3D%22lingo-sub-2310932%22%20slang%3D%22en-US%22%3ECell%20names%20have%20changed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2310932%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20cell%20names%20are%20all%20numeric%20instead%20of%20being%20alpha%20for%20the%20columns%2C%20how%20can%20I%20change%20back%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2310932%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2310979%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20names%20have%20changed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2310979%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1041864%22%20target%3D%22_blank%22%3E%40Annette1845%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExcel%20for%20Windows%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESelect%20File%20%26gt%3B%20Options%20%26gt%3B%20Formulas.%3C%2FLI%3E%0A%3CLI%3EClear%20the%20check%20box%20'R1C1%20reference%20style'%20and%20click%20OK.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EExcel%20for%20Mac%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESelect%20Excel%20menu%20%26gt%3B%20Preferences%20%26gt%3B%20General.%3C%2FLI%3E%0A%3CLI%3EClear%20the%20check%20box%20'Use%20R1C1%20reference%20style'.%3C%2FLI%3E%0A%3C%2FUL%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

The cell names are all numeric instead of being alpha for the columns, how can I change back

1 Reply

@Annette1845 

Excel for Windows:

  • Select File > Options > Formulas.
  • Clear the check box 'R1C1 reference style' and click OK.

Excel for Mac:

  • Select Excel menu > Preferences > General.
  • Clear the check box 'Use R1C1 reference style'.