Send to a Friend

Dutchess_III's avatar

How do I leave certain cells in an Excel spreedsheet unlocked so that other users can modify them?

Asked by Dutchess_III (46828points) 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?

Using Fluther

or

Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.