replied toTR9Casten
Feb 25 202308:43 AM - edited Feb 25 202308:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 25 202308:43 AM - edited Feb 25 202308:45 AM
On Windows:
Select File > Options > Formulas.
Under 'Working with formulas', clear the check box 'R1C1 reference style'.
Click OK.
On Mac:
Select the Excel menu > Preferences > Calculation.
Clear the check box 'Use R1C1 reference style'.