NEWSheetSteps AI now turns entire websites into clean spreadsheet columnsExplore web scraping →

Google Sheets tutorials›Collaboration›Share with view only access

Google Sheets · Verified tutorial

Share with view only access in Google Sheets

Change Priya's access in B2 from Editor to exactly "Viewer". Keep both people active and do not change Marco's row.

Verified by PhilisJuly 15, 2026About 60 seconds

Quick answer

Change Priya's access in B2 from Editor to exactly "Viewer". Keep both people active and do not change Marco's row.

Step-by-step

1

Select the targetChange Priya's access in B2 from Editor to exactly "Viewer".

2

Apply the changeKeep both people active and.

Shortcut or faster method

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

Expected result

Priya and Marco both have active view-only access.

Common mistake

Changing the source values while applying the formatting or structure change.

Troubleshooting

Re-select B2 and repeat the final action. Priya and Marco both have active view-only access.

Example spreadsheet data

This is the clean fixture used for the verified run.

Person	Access	Status
Priya	Editor	Active
Marco	Viewer	Active

Video transcript

Open the prepared Viewer access spreadsheet.
Select the target. Change Priya's access in B2 from Editor to exactly "Viewer".
Apply the change. Keep both people active and.
Priya and Marco both have active view-only access.