Comments not showing in Google Sheets
Two comment-register entries are not showing because rows 3 and 4 are hidden. Unhide all rows without changing any comment text or status.
Verified by JosephineAbout 75 secondsTwo comment-register entries are not showing because rows 3 and 4 are hidden. Unhide all rows without changing any comment text or status.
Step-by-step
Select the targetTwo comment-register entries are not showing because rows 3 and 4 are hidden.
Apply the changeUnhide all rows without changing any comment text or status.
Shortcut or faster method
Select the full target range first. This avoids repeating the same change cell by cell.
Expected result
Every comment-register row is visible and all entries remain unchanged.
Common mistake
Changing the source values while applying the formatting or structure change.
Troubleshooting
Undo the last change, reselect the intended range, and try again. Every comment-register row is visible and all entries remain unchanged.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Cell | Comment | Status |
| B4 | Confirm the launch date | Resolved |
| D7 | Check the campaign total | Open |
| F9 | Verify the forecast | Open |
Video transcript
- Open the prepared Missing comments spreadsheet.
- Select the target. Two comment-register entries are not showing because rows 3 and 4 are hidden.
- Apply the change. Unhide all rows without changing any comment text or status.
- Every comment-register row is visible and all entries remain unchanged.