» Deleting a Comment(s) in a Sheet in Excel 2007
CATEGORY - Excel Editing
VERSION - Microsoft Excel 2007
Select a cell contains a comment, select Review - Delete (in Comments Group).
Or
Right-click and select Delete Comment from the shortcut menu.
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.
Book Store:
Recommended Books:
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Excel Charts
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- Analyzing Markets, Products, and Marketing Plans
- Wall Street Journal Guide to Understanding Money and Investing
No comments have been submitted.

