How to lock columns in google sheet

ST

by Sanskar Tiwari

Intro: Locking columns in a Google Sheet is an easy way to protect your data from unauthorised changes. This guide will show you how to lock columns in a Google Sheet.
 
Step 1: Open the Google Sheet you want to lock columns in.
Step 2: Select the columns that you want to lock.
Step 3: Right-click on the selected columns and select “Protect range…” from the menu.
Step 4: In the pop-up window, enter a description for the range you are protecting and select the “Restrict who can edit this range” option.
Step 5: Select “Only you” from the drop-down menu, then click “Save.”
Step 6: Your columns are now locked, and you can only edit them if you have the correct permissions.
Conclusion: Locking columns in a Google Sheet is easy and can help you protect your data from unauthorised changes. Follow the steps above to lock columns in your Google Sheet.