G
Guest
Hi Everyone
I have a spreadsheet which allows people to enter some figures in some cells.
Those cells then add together to creat bew totals.
I want to allow them to see all the individual lines or allow them to use
the group +or - (the rows have already been grouped) to change the views.
But, if I lock some cells in those rows, the Group + or - no longer works.
Is there anyway around? I've tried "Allow Format rows" as a protection
option but it didn't work. I've tried to select the whole worksheet, unlocked
it, then locked smalls parts, that didn't work either.
If there is a solution, I'd love to hear from you!
I have a spreadsheet which allows people to enter some figures in some cells.
Those cells then add together to creat bew totals.
I want to allow them to see all the individual lines or allow them to use
the group +or - (the rows have already been grouped) to change the views.
But, if I lock some cells in those rows, the Group + or - no longer works.
Is there anyway around? I've tried "Allow Format rows" as a protection
option but it didn't work. I've tried to select the whole worksheet, unlocked
it, then locked smalls parts, that didn't work either.
If there is a solution, I'd love to hear from you!