Select Cells with Comments in Excel
This shortcut allows you to instantly select all cells that contain comments (including notes or threaded comments) within the active worksheet. It is extremely useful when reviewing feedback or cleaning up comments.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + Shift + O | Not Available |
What Does This Shortcut Do?
When you press this shortcut, Excel selects every cell that contains a comment in the active worksheet. All commented cells are highlighted at once.
How to Use the Shortcut
- Click anywhere in the worksheet
- Press Ctrl + Shift + O
- All cells with comments will be selected
- You can now edit, delete, or format those cells
Tips & Best Practices
- Great for reviewing collaborator feedback quickly
- Use before deleting comments to ensure none are missed
- Works best when comments are spread across large sheets
FAQ
- Q: Does this select both notes and threaded comments?
- Yes, it selects cells containing any type of comment.
- Q: Can I use this on filtered data?
- Yes, but hidden rows may affect visibility after selection.
- Q: Why doesn’t this work on Mac?
- Excel for Mac does not support this shortcut.