Thread: Hidden Comments
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Hidden Comments

E2007

Office button - excel options - advanced tab- scroll to 'Display' and select
'Indicators only, and comments on hover'
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"ClaireView" wrote:

Sorry, I forgot to say I'm using MS Office 2007.

Although 2007 doesn't have a "Tools" option, you did give me the hint I
needed, John. I went to the Microsoft Office Button, chose Excel Options at
the bottom, then Advanced, scrolled down to the Display section, and, as you
said, under "For cells with comments, show:" and I clicked "Indicators only,
and comments on hover."

So here's the solution in case someone else searches the subject. Thanks
for the inspiration, John!

"John" wrote:

Hi ClaireView
With XL2003 go to ToolsOptionsView Tab. In the Comments section, select
Comment Indicator only.
HTH
John
"ClaireView" wrote in message
...
The two options for Comments are Show and Hide. Show shows them all the
time. When I choose Hide it truly hides them; rollover or clicking on the
cell won't show my Comments at all! I'd like to get the rollover option to
work again; what did I do to mess this up and how do I fix it?


.