Social Question
How do I leave certain cells in an Excel spreedsheet unlocked so that other users can modify them?
Asked by Dutchess_III (47127)
July 12th, 2013
This is ridiculous! OK, here’s how far I’ve gotten.
1) With the sheet unprotected I select Allow Users to Edit Ranges
2) It comes up with a dialog box that says “Ranges unlocked by a password when sheet is protected.”
3) It names it Range 1
4) I hold the ctrl key down, and click on the cells I want users to be able to access. I watch it list those cells.
5) I click “apply” then “OK.”
The dialog box disappears.
6) I protect the worksheet.
It doesn’t work. I’m only able to access one of the cells I selected (Which happens to have the name “Auggie” in it!) The rest of them stay protected.
WTH am I missing?
Observing members:
0
Composing members:
0
5 Answers
Answer this question
Have a question?
Ask Fluther!