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?
.
|