See who changed a cell in Google Sheets
The history is ordered newest first. In E2, enter the name of the person who most recently changed B2. Enter exactly "Josephine" and do not alter the history.
Verified by JosephineAbout 60 secondsThe history is ordered newest first. In E2, enter the name of the person who most recently changed B2. Enter exactly "Josephine" and do not alter the history.
Step-by-step
Select the targetThe history is ordered newest first.
Complete the next actionIn E2, enter the name of the person who most recently changed B2.
Apply the changeEnter exactly "Josephine" and.
Shortcut or faster method
Select the target cell, type or paste the formula in the formula bar, then press Enter.
Expected result
E2 identifies Josephine as the most recent editor, and the source history remains unchanged.
Common mistake
Applying the change to more rows, columns, or cells than the task specifies.
Troubleshooting
Re-select E2 and repeat the final action. E2 identifies Josephine as the most recent editor, and the source history remains unchanged.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Cell | Current value | Changed by | Change time | Review result |
| B2 | 480 | Josephine | 10:42 UTC | |
| B2 | 450 | Marco | 10:15 UTC |
Video transcript
- Open the prepared Cell history spreadsheet.
- Select the target. The history is ordered newest first.
- Complete the next action. In E2, enter the name of the person who most recently changed B2.
- Apply the change. Enter exactly "Josephine" and.
- E2 identifies Josephine as the most recent editor, and the source history remains unchanged.