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. 

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. 

Select whether you want to warn a user when editing this range, or restrict who can edit this range. 

Google

This guide provides step-by-step instructions on how to protect (lock) a column in Google Sheets. It explains the process of protecting a range in order to prevent others from making changes or receive a warning when changes are made. Following this guide will help users secure their data and maintain control over their Google Sheets documents.

How to lock a column in Google Sheets