Forum Discussion
Solved
excel added column number from previous save
after I saved this last night this morning I have the word column at the top over the month name & wish to know how to get rid of that or perhaps recover the document to yesterday's save.?? Totally inexperienced other than adding what is given to me to insert then 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...?
R1C1 is not the issue here.
The data was tabled and the option for 'my table has headers' was unchecked. When this happens, Excel will add a 'dummy header' - Column1, Column2, Column3, etc.
One of the benefits of a tabling a range it it also freezes panes for you. When you scroll vertically, it shows your header instead of the letter markers.
To resolve, go to Table Design | Convert to range. You can then clear the dummy header and re-table the correct range, if needed.
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
