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.
3
Click "View more cell actions"
4
Click "Protect range"
5
Click "Add a sheet or range"
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.
8
Once done, click "Ok"
9
To edit your sheet, click "Sheet"
10
Once complete, click "Set permissions"
11
Select whether you want to warn a user when editing this range, or restrict who can edit this range.
12
Click "Done"
