Excel

Resolved · Urgent Priority · Version 2007

Fri 31 Oct 2008, 16:12 Delegate Alex said...

Alex has attended:
Excel Intermediate course
PowerPoint Introduction course

Excel

Simon was so helpful and i think i've learnt everything so no questions from me! Ta x

Wed 4 Oct 2023, 20:24 Trainer Rich said...

RE: Excel

Thanks Alex, glad to hear. We know this is a very late reply, but our new forum alerts have told us this quesiton was unanswered, so we are 'resolving' it now! Regards, Rich

Excel tip:

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.

View all Excel hints and tips

Excel

Excel

RE: Excel

Excel articles

Excel tip:

Shortcut for deleting all comments in a spreadsheet