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

Google Sheets tutorials›Collaboration›Share with comment access

Google Sheets · Verified tutorial

Share with comment access in Google Sheets

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

Verified by PhilisJuly 15, 2026About 60 seconds

Quick answer

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

Step-by-step

1

Select the targetChange Lena's access in B2 from Viewer to exactly "Commenter".

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

Lena has active comment access and Marco remains an active viewer.

Common mistake

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

Troubleshooting

Re-select B2 and repeat the final action. Lena has active comment access and Marco remains an active viewer.

Example spreadsheet data

This is the clean fixture used for the verified run.

Person	Access	Status
Lena	Viewer	Active
Marco	Viewer	Active

Video transcript

Open the prepared Comment access spreadsheet.
Select the target. Change Lena's access in B2 from Viewer to exactly "Commenter".
Apply the change. Keep both people active and.
Lena has active comment access and Marco remains an active viewer.