Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
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?


.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Some comments stay hidden even after picking show/hide all why? stevepowell Excel Discussion (Misc queries) 2 July 13th 09 08:37 PM
Hidden comments Oldjay Excel Discussion (Misc queries) 13 February 11th 08 11:27 PM
hidden comments DonnaO New Users to Excel 3 May 3rd 07 05:50 PM
Hidden Comments Phippsy Excel Discussion (Misc queries) 3 November 1st 05 07:46 AM
Printing hidden comments Tammy Excel Discussion (Misc queries) 1 May 24th 05 02:16 AM


All times are GMT +1. The time now is 10:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"