=(pulling my hair out + gah!)

March 14, 2008 3:07 PM

Excel for Mac - Where the hell did my comments go!!??

I'm using Excel 2004 for Mac. I've created a lovely spreadsheet to track work turned in, and I leave info about who did the job and when in the comments. Its a very simple, visual way for me to see where I'm at in an instant, and then mouse over for more info as needed.

When I save and close the document, and reopen, some - but not all - of my comments are gone. To be specific, I gray out the box when the work is turned in, and then create the comment. Usually. But even when the comment disappears, the gray remains.

I feel like I'm doing something wrong and its not just the program - but stranger things have happened!

Thanks.

posted by fillsthepews to computers & internet (3 comments total)

Are you sure the comments are entirely gone? If you were using Windows, I'd say go to the Tools->Options->View and make sure you check the "Comments indicators only" box.

This website has some instructions for working with comments in Excel for Mac.

If you go to a cell that you previously created a comment in, what happens when you try to edit the comment (I think control+click on Mac, Shift+F2 on the PC)? Does it bring up a blank comment?
posted by mullacc at 7:02 PM on March 14, 2008

If the comments are still there, but just being hidden, the following macro will reveal them all (for the active sheet)

------------------------------
Sub showallcomments()

Set cmt = ActiveSheet.Comments
For Each c In cmt
c.Visible = True
Next

End Sub
posted by pompomtom at 11:52 PM on March 14, 2008

Thanks, guys! I'll try this on Monday.
posted by fillsthepews at 3:59 PM on March 15, 2008