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.
Navigate to Google Sheets [https://docs.google.com/spreadsheets/d/1E0V5OQHw9ALvqfg2pB51ZIyesoSaKBwOwnRVKbi852g/edit#gid=0](https://docs.google.com/spreadsheets/d/1E0V5OQHw9ALvqfg2pB51ZIyesoSaKBwOwnRVKbi852g/edit#gid=0)
Right click on the column you want to lock.
Zoom Saved
Click "View more cell actions"
Zoom Saved
Click "Protect range"
Zoom Saved
Click "Add a sheet or range"
Zoom Saved
Optionally, you can name your range.
For example, Sheet1A! here is titled "Company Name"
Edit your Range if needed by clicking the button on the right hand side.
Zoom Saved
Once done, click "Ok"
Zoom Saved
To edit your sheet, click "Sheet"
Zoom Saved
Once complete, click "Set permissions"
Zoom Saved
Select whether you want to warn a user when editing this range, or restrict who can edit this range.
Zoom Saved
Click "Done"
Zoom Saved
Documents you might like
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe
Have something to say?Create an account to leave messages for the author to see!
Press space bar to start a drag.
When dragging you can use the arrow keys to move the item around and escape to cancel.
Some screen readers may require you to be in focus mode or to use your pass through key