NEWSheetSteps AI now turns entire websites into clean spreadsheet columnsExplore web scraping  →
Google Sheets · Verified tutorial

Mention someone in a comment in Google Sheets

This is a notification-free mention register. Record Morgan as the person mentioned for the B4 entry by entering exactly "Morgan" in D2. Do not type an @ address, create an actual Google comment, or send a notification. Keep every other cell unchanged.

Verified by PhilisAbout 60 seconds
Quick answer

This is a notification-free mention register. Record Morgan as the person mentioned for the B4 entry by entering exactly "Morgan" in D2. Do not type an @ address, create an actual Google comment, or send a notification. Keep every other cell unchanged.

Step-by-step

1

Select the targetThis is a notification-free mention register.

2

Apply the changeRecord Morgan as the person mentioned for the B4 entry by entering exactly "Morgan" in D2.

Shortcut or faster method

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

Expected result

The B4 register entry records Morgan as the mention and preserves the existing D7 entry.

Common mistake

Applying the change to more rows, columns, or cells than the task specifies.

Troubleshooting

Re-select B4 and repeat the final action. The B4 register entry records Morgan as the mention and preserves the existing D7 entry.

Example spreadsheet data

This is the clean fixture used for the verified run.

CellCommentStatusMention
B4Confirm the launch dateOpen
D7Check the campaign totalOpenAlex

Video transcript

  1. Open the prepared Mention register spreadsheet.
  2. Select the target. This is a notification-free mention register.
  3. Apply the change. Record Morgan as the person mentioned for the B4 entry by entering exactly "Morgan" in D2.
  4. The B4 register entry records Morgan as the mention and preserves the existing D7 entry.