troubleshooting Question

Share editing privileges for locked areas in Google sheets

Avatar of WeThotUWasAToad
WeThotUWasAToad asked on
GoogleSpreadsheets* google spreadsheetsMicrosoft ExcelMicrosoft Office
1 Comment1 Solution36 ViewsLast Modified:

How can I share editing privileges for locked ranges of cells in Google sheets?

I've got a Google Drive spreadsheet in which I have locked the first three columns on the left and all of the heading rows. The remainder of the sheet is unlocked.

I've shared a general "can edit" link with a number of people so they can enter data in the unlocked areas of the sheet. As I expected, those who use this link cannot edit the locked areas.

Now I've got someone with whom I want to share editing privileges for the entire sheet, including the locked areas.

Is there any way to do that?

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros