Highlight all cells with comments
Master this Excel shortcut with our comprehensive guide
Special Cells Shortcuts
Ctrl + Shift + O
⌘ + Option + O
How to Use This Shortcut
Keyboard Shortcut
Ctrl + Shift + O
Instructions
1. Press Ctrl + Shift + O
2. Highlights all cells containing comments in the worksheet
2. Highlights all cells containing comments in the worksheet
Keyboard Shortcut
⌘ + Option + O
Instructions
1. Press Command + Option + O
2. Highlights all comment-containing cells
2. Highlights all comment-containing cells
💡 Pro Tip: Useful when reviewing or editing feedback within a spreadsheet.
Quick Actions
More Special Cells Shortcuts
Ctrl + Shift + 8
Ctrl + `
Alt + ;