Excel Office 365 formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-2099723%22%20slang%3D%22en-US%22%3EExcel%20Office%20365%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2099723%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20it%20happened%20I%20don't%20know.%20But%20when%20I%20create%20a%20formula%20or%20use%20a%20built-in%20formula%20such%20as%20Sum%3C%2FP%3E%3CP%3EI%20get%20this%3A%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%220%22%20width%3D%22128%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22128%22%20height%3D%2220%22%3E%3DSUM(R%5B-2%5DC%3AR%5B-1%5DC)%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EHow%20do%20I%20get%20it%20back%20to%20A1%2BB1%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2099723%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2101030%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Office%20365%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2101030%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F154214%22%20target%3D%22_blank%22%3E%40Lilly%20Hughes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExcel%20for%20Windows%3A%3C%2FP%3E%0A%3CP%3ESelect%20File%20%26gt%3B%20Options%2C%3C%2FP%3E%0A%3CP%3ESelect%20Formulas%20in%20the%20navigation%20pane%20on%20the%20left.%3C%2FP%3E%0A%3CP%3EUnder%20'Working%20with%20formulas'%2C%20clear%20the%20check%20box%20'R1C1%20reference%20style'.%3C%2FP%3E%0A%3CP%3EClick%20OK.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExcel%20for%20Mac%3A%3C%2FP%3E%0A%3CP%3ESelect%20Excel%20%26gt%3BPreferences%3C%2FP%3E%0A%3CP%3ESelect%20General.%3C%2FP%3E%0A%3CP%3EClear%20the%20check%20box%20'Use%20R1C1%20reference%20style'.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

How it happened I don't know. But when I create a formula or use a built-in formula such as Sum

I get this: 

=SUM(R[-2]C:R[-1]C)

How do I get it back to A1+B1

 

2 Replies

@Lilly Hughes 

Excel for Windows:

Select File > Options,

Select Formulas in the navigation pane on the left.

Under 'Working with formulas', clear the check box 'R1C1 reference style'.

Click OK.

 

Excel for Mac:

Select Excel >Preferences

Select General.

Clear the check box 'Use R1C1 reference style'.

@Hans Vogelaar  It worked. Thanks bunches.