This Scribe shows you how to lock certain ranges (groups of cells) or entire sheets in Google Sheets

Right click on a cell in the range you want to lock

Hover your mouse over "View more cell actions" at the bottom of the menu and click "Protect range"

A side panel will appear. Click "Add a sheet or range"

If you just want to lock a specific group of cells, select "Range" and input the cell range in the range field

If you want to protect a whole sheet, select "Sheet"

Select the sheet you want to lock by opening up the dropdown

You can set it so only you can edit the restricted range/sheet, or you can set a custom permission.

Google Sheets is a powerful online tool to help you do quantitative analysis. Learn how to use formulas to manipulate and analyze datasets, such as Google Sheets' COUNTIF and SUMIF functions, among many others.

How to lock cells and sheets in Google Sheets