New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Errors›Protected range not working

Google Sheets · Verified tutorial

Protected range not working in Google Sheets

Protect B2:B4 using Data > Protect sheets and ranges. Keep the current account able to edit the range.

Verified by JosephineJuly 25, 2026About 75 seconds

Quick answer

Protect B2:B4 using Data > Protect sheets and ranges. Keep the current account able to edit the range.

Step-by-step

1

Select the targetProtect B2:B4.

2

Complete the next actionData > Protect sheets and ranges.

3

Apply the changeKeep the current account able to edit the range.

Shortcut or faster method

Select the full target range first. This avoids repeating the same change cell by cell.

Expected result

A protected range covers B2:B4.

Common mistake

Starting with the wrong cell or range selected.

Troubleshooting

Re-select B2:B4 and repeat the final action. A protected range covers B2:B4.

Example spreadsheet data

This is the clean fixture used for the verified run.

Item	Amount
Hosting	80
Software	120
Design	500

Video transcript

Open the prepared Protection repair spreadsheet.
Select the target. Protect B2:B4.
Complete the next action. Data > Protect sheets and ranges.
Apply the change. Keep the current account able to edit the range.
A protected range covers B2:B4.