|  

» Deleting All Cell Comments in a Sheet

To delete all Comments in a sheet:

1. Press F5 to open the Go To dialog box, and click Special.
2. In the Go To Special dialog box, select Comments.
3. Click OK. All cells containing Comments are selected.
OR
Skip steps 1 through 3 and press Ctrl+Shift+O (the letter O, not the number zero) to select all Comments.
4. Press Shift+F10 or right-click, and select Delete Comment from the shortcut menu.
Screenshot // Deleting All Cell Comments in a Sheet
Deleting All Cell Comments in a Sheet


Rate This Tip
12 34 5
Rating: 4.17     Views: 15748
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments