Forum Discussion
excel added column number from previous save
Thanks for your speedy reply I followed your tips and the r1c1 option was unchecked, would checking it perhaps resolve my issue or what other ideas you may have for me to try...?
Hello James1056
Happy New Year! And I'm sorry you are having trouble with MS-Excel.
It seems that you may have inadvertently turned the R1C1 reference on, and here is how to turn it off.
If you are working on a MacOS device do these steps:
A) In Excel go to the Preferences
B) In the Preferences look for Authoring and find Calculation
C) Uncheck "Use R1C1 reference style" checkbox.
If you are working on a Windows device do these steps:
A) From the File Menu choose Options (way on the bottom)
b) From the Options dialog choose Formulas on the left side
C) Uncheck "R1C1 reference style" checkbox.
In Excel you have two modes of referencing cells, the old R1C1 (Stands for Row 1, Column 1) which would equal cell A1 (First cell in the First column A and the First cell in the first row 1). The R1C1 still exists for backward compatibility plus it is the way we (old timers with spreadsheets) used to work.
Hope this helps!
Georgie
Thanks for your speedy reply I followed your tips and the r1c1 option was unchecked, would checking it perhaps resolve my issue or what other ideas you may have for me to try...?
I found the key to my issue by selecting the row with the name column and then select hide and now my spreadsheet is back to normal except for the bills I have to pay
- next day I went back to square one again with the same issue, not sure if I should start a new excel workbook sheet and copy all the data over, would that recreate the same issue?
- Hello James1056
Sorry about you still having that issue. By any chance was the workbook opened on a different machine using a different version of Excel? Something like running Windows version then a Mac then back Windows?
Recraeting the workbook might be tedious and long process but its always a good idea.
But before you do that try a simple new workbook and see if the behavior is still there. If it is, try an older file, and see if its the workbook of Excel that is having this issue. If its Excel then you know it maybe a setting some where, if its the workbook well then recreating it might help.