See comment locations in worksheet

**Lewis Koh** · 04-24-2010, 08:20 PM

Hi,

Is there any ways to see all the location of my comments are located in a work sheet? Some of my comments has shifted to extreme rows and cause the worksheet to have many blank rows below.

**DonkeyOte** · 04-25-2010, 04:48 AM

Not entirely sure I follow ... pending the number of comment ranges you might get away with something like:

Please Login or Register  to view this content.

**Lewis Koh** · 04-25-2010, 06:47 AM

er...how do I use the above information?

**teylyn** · 04-25-2010, 09:40 PM

You can hit F5, then click Special, tick Comments and hit OK.

Now all cells with comments are highlighted. You can cycle through them by hitting the Enter key. Right-click on a cell and deal with showing / hiding / deleting the comment, or drag a visible comment to a preferred location.