I have a spreadsheet on the network for other users and someone changed the columns from A,B,C... to 1,2,3... This results in column A1 being identified as R1C1. A standard formula: =SUM(C5:C54) is now =SUM(R[-50]C:R[-1]C). My questions are how did someone make this change and how can I protect the spreadsheet from anyone making changes like this? Any help would be greatly appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel columns changed from A,B,C to 1,2,3!
- Thread starter Clarinet
- Start date
AnotherHiggins
Technical User
Tools > Options > General
Uncheck the box beside R1C1 reference style.
I probably wouldn't bother protecting it after one incident. It's pretty rare for a user to accidentally change this setting.
But if you want to, check out Tools > Protection
[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]
Help us help you. Please read FAQ 181-2886 before posting.
Uncheck the box beside R1C1 reference style.
I probably wouldn't bother protecting it after one incident. It's pretty rare for a user to accidentally change this setting.
But if you want to, check out Tools > Protection
[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]
Help us help you. Please read FAQ 181-2886 before posting.
- Thread starter
- #3
That did the trick anotherhiggins. Thank you so much for such a quick response! Can you think of anyway a user could have invoked the R1C1 reference style without going into Tools > Options > general or is this the only way to make this happen?
AnotherHiggins
Technical User
I'm pretty confident that no keyboard shortcut exists to toggle this option. (unlike, say, [Ctrl]+[`] which is a keyboard shortcut for Tools > Options > View > View formulas.)
I think the only way to change this is to go into that menu. But someone might have been going in to change something else and checked that box by mistake.
[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]
Help us help you. Please read FAQ 181-2886 before posting.
I think the only way to change this is to go into that menu. But someone might have been going in to change something else and checked that box by mistake.
[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]
Help us help you. Please read FAQ 181-2886 before posting.
- Status