How to Protect Cells on Google Sheets on PC or Mac

Beginner 30 min 10 steps 44702 views Rating: 3.7/5 Published: 2026-02-25

Open Google Sheets in your internet browser.. Click the spreadsheet you want to edit.. Select the cells you want to protect.

Start Playback
E
Author

Steps

1

Open Google Sheets in your internet browser.

Step 1

Open Google Sheets in your internet browser.

2

Click the spreadsheet you want to edit.

Step 2

Click the spreadsheet you want to edit.

3

Select the cells you want to protect.

Step 3

Select the cells you want to protect.

4

Click the Data tab.

Step 4

Click the Data tab.

5

Click Protected sheets and ranges on the Data menu.

Step 5

Click Protected sheets and ranges on the Data menu.

6

Click the blue Set permissions button.

Step 6

Click the blue Set permissions button.

7

Select the Restrict who can edit this range option.

Step 7

Select the Restrict who can edit this range option.

8

Click the drop-down menu.

Step 8

Click the drop-down menu.

9

Select Only you on the drop-down menu.

Step 9

Select Only you on the drop-down menu.

10

Tap the blue Done button.

Step 10

Tap the blue Done button.

View as Slideshow

Rate This Guide

★ ★ ★ ☆ ☆ 3.7/5
3

Comments (0)

No comments yet. Be the first to share your thoughts!