SOLVED

excel added column number from previous save

Copper Contributor

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.

 

 

 

excel.png

6 Replies

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

best response confirmed by James1056 (Copper Contributor)
Solution

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 :facepalm:

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.

@James1056 

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.

Patrick2788_0-1706043481502.png

 

To resolve, go to Table Design | Convert to range. You can then clear the dummy header and re-table the correct range, if needed.

1 best response

Accepted Solutions
best response confirmed by James1056 (Copper Contributor)
Solution

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...?

 

View solution in original post