» Deleting All Cell Comments in a Sheet
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
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:
- Microsoft PowerPoint Version 2002 Step by Step
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Excel 2002 Power Programming with VBA
- Windows XP All-in-One Desk Reference For Dummies
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
No comments have been submitted.
