Bookmark page
Printable version
Course updates
|
RSS feeds
Hints and tips home » Excel hints and tips » Shortcut for deleting all comments in a spreadsheet
Shortcut for deleting all comments in a spreadsheet
If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:
1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.
2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.
3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.
Added by Amanda on 24th November 2006
More Excel hints and tips, like:
- Adding Rows or Columns in an Excel 2010 Worksheet
- Stop Formula Returning A "#DIV/0" Error
- Use the Ctrl-key for quick navigation in Excel 2010
 |
How To Quadruple Your Investment In IT Training IT training should become a priority which is placed at the top of the agenda rather than at the bottom. Although many companies fall under the illusion that retraining will mean a slow and costly return, it is actually more cost effective in the long run to train existing staff. Read on to discover the advantages to staff training. » Article: Microsoft training providers uk |
» Forum post: Macros |
|
When writing a macro, I have difficulty where end up with lots of decimnal places (i.e. 
It is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar. 
