Social Question
![Dutchess_III's avatar](http://dkg88rp4qbe6q.cloudfront.net/avatars/Dutchess_III/FB_IMG_1737326897655_thumb.jpg)
How do I leave certain cells in an Excel spreedsheet unlocked so that other users can modify them?
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
![](http://d3phpakcjc7x1x.cloudfront.net/images/v2/eye.png)
![](http://d3phpakcjc7x1x.cloudfront.net/images/v2/pencil.png)
5 Answers
Answer this question
Have a question?
Ask Fluther!