Comments

Resolved · Low Priority · Version 2003

Tue 11 Aug 2009, 16:41 Delegate Kate said...

Kate has attended:
Excel Intermediate course
Excel Introduction course

Comments

How can I delete a comment? (Not just the text, the little red triangle that appears in the cell).

thanks!

Wed 12 Aug 2009, 10:05 Trainer Anthony said...

RE: Comments

Hi Kate, thanks for your query. You can delete a comment by right clicking on the relevant cell and selecting "Delete Comment". This will remove the comment text and the little red triangle. Alternatively, in Tools-Options and the view tab, you can alter the display options for comments and thereby remove the triangle even when there is still a comment attached to a cell.

Hope this helps,

Anthony

Tue 18 Aug 2009: Automatically marked as resolved.

Excel tip:

Move data worksheet to worksheet

To move data from one worksheet to another, highlight the data.

Select and hold down the ALT key and position the mouse on the border of the selection until the mouse pointer displays four-headed arrows.

Drag the selection down to the destination worksheet tab.

When the arrow touches the tab, Excel switches to the desired worksheet. Now drag the selection to the correct position. Let go of the mouse and then the ALT key.

To copy data from one worksheet to another, select and hold down the CTRL+ALT keystroke combination and perform the steps above.

View all Excel hints and tips

Comments

Comments

RE: Comments

Excel articles

Excel tip:

Move data worksheet to worksheet