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.
Click "View more cell actions"
Click "Protect range"
Click "Add a sheet or range"
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.
Once done, click "Ok"
To edit your sheet, click "Sheet"
Once complete, click "Set permissions"
Select whether you want to warn a user when editing this range, or restrict who can edit this range.
Click "Done"
Documents you might like
0 Selected
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