Forum Discussion
Solved
Change in the way formulas are shown
All my spreadsheets dating back used to show columns alphabetically. Now going back to even old spreadsheets they are shown as numbers and the resultant formulas used are shown as for example +Su...
- Open Excel, point to 'File' on the ribbon.
Select 'Options' at the bottom of the list.
In the dialog box that opens, select 'Formulas' in the left hand side list.
Under 'Working with formulas' try un-checking the 'R1C1 reference style'
Select 'OK', and see if that works for you.
Open Excel, point to 'File' on the ribbon.
Select 'Options' at the bottom of the list.
In the dialog box that opens, select 'Formulas' in the left hand side list.
Under 'Working with formulas' try un-checking the 'R1C1 reference style'
Select 'OK', and see if that works for you.
Select 'Options' at the bottom of the list.
In the dialog box that opens, select 'Formulas' in the left hand side list.
Under 'Working with formulas' try un-checking the 'R1C1 reference style'
Select 'OK', and see if that works for you.
