Google Sheets - Protect Cells

Is there a way to make it so they can't even click the cell? Looking to convert many Excel work files and its just easier if the person can't even get into the cell at all.

Thanks. Helpful and concise!

This is great, thanks :)

Can you lock a cell from the originator?

hi there! I am trying to apply this to a shared document, but haven't been successful. Does this rule only apply prior to sharing with other collaborators?

Hi, If you hide/protect a cell and share. Is it possible that all that you're sharing with can not see or click on the arrow to see that particular cell, but only see what pertains to them? Great tutorial. Thanks.

thanq u so much

Dear sir how to protect all column in one formula & macro and paste other sheets

how to lock a cell after data has been entered by a user so other users cannot edit it?

I have a sheet where I've shared data from another sheet, such as the names only, and the email addresses only. Now I want to do attendance with those names. I've noticed as soon as I sort the data in the original sheet, the data gets out of sync with the names. How can I keep the names and the data aligned.

Thanks. Very helpful. Even though the format has changed slightly in the 5 years since this was published, I was still able to easily follow along and make the necessary changes to my sheet.

Can you limit the viewer? I mean we have 5 google sheet and we have 5 email shared with but can you limit the viewer for one sheet only you can see that one sheet not just protect the cell?

Is it possible to lock columns based on date in row 1. For example, lock column B when date in B1 has passed. Lock C when C1 has passed. It'll be great if you can help :)

I'm a teacher and I have created a sheet for students to type in their answer (like an answer document). It has been conditionally formatted to turn a certain color if answer is correct. I will share this sheet with them and each student will have their own copy to serve as their answer sheet. My questions is - how can I lock or protect all my formatting and still let students enter an answer in that cell?? for example I want students to type "5" but not be able to change the color of the cell themselves so it 'looks" like answer is correct.
Also I don't want students to see the "conditional formatting" that I set because then they would see the correct answer.

I don't know why but I can't find protect on my Google sheet irrespective of the machine I open it on or the browser I open it in. Is the feature no more available?

Hi, i have linked an email button to email my spreadsheet to parents etc. I have tried right clicking, protect range.. but when I go to my trial email (a completely different email) i can still change things??? It is possible to lock the spreadsheet in this state??

Suppose i m protect sheet so can other people delet the sheet ?

Useless

Can I hide some rows for all the users except me and another particular user?

Thanks sir

Pls help sir

in hindi language

Hi, thanks at first. Let me ask, can I somehow set a row to be editable but not deletable ?

I do not see protect range in my Google sheets

Kelly is in big trouble.

Can we hide(don't want let editors unhide) that protected column while other columns are editable