This guide was created with Scribe in 41 seconds. Sign in and create your own!
How to lock a column in Google Sheets
|
0 step |
41 seconds
Tip! This Scribe will show you how to lock columns on Google Sheets to prevent others from making changes, or send a warning when changes are made.
1
Navigate to Google Sheets [https://docs.google.com/spreadsheets/d/1E0V5OQHw9ALvqfg2pB51ZIyesoSaKBwOwnRVKbi852g/edit#gid=0](https://docs.google.com/spreadsheets/d/1E0V5OQHw9ALvqfg2pB51ZIyesoSaKBwOwnRVKbi852g/edit#gid=0)
2
Right click on the column you want to lock.
Zoom Saved
3
Click "View more cell actions"
Zoom Saved
4
Click "Protect range"
Zoom Saved
5
Click "Add a sheet or range"
Zoom Saved
6
Optionally, you can name your range.
For example, Sheet1A! here is titled "Company Name"
7
Edit your Range if needed by clicking the button on the right hand side.
Zoom Saved
8
Once done, click "Ok"
Zoom Saved
9
To edit your sheet, click "Sheet"
Zoom Saved
10
Once complete, click "Set permissions"
Zoom Saved
11
Select whether you want to warn a user when editing this range, or restrict who can edit this range.
Zoom Saved
12
Click "Done"
Zoom Saved
Was this Scribe helpful? Save this document for future reference.
Save for Later
Have something to say?Create an account to leave messages for the author to see!Create an account
Feedback
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe