Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts

    Hide All Comments On All Sheets... (XP-PRO OFFICE-2003)

    Hi everybody,

    I received a workbook with 35 sheets and zillions of visible comments on each sheet...

    is there a fast method to "hide" all of them at once?!

    Thank you and

    best regards...

    Wolfgang

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Hide All Comments On All Sheets... (XP-PRO OFF

    Hi Wolfgang

    Simply View | Comments will toggle between showing and Hiding
    Jerry

  3. #3
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts

    Re: Hide All Comments On All Sheets... (XP-PRO OFF

    Hi Jerry,

    do you mean to say: select all sheets with shift-click and then perform the steps that you suggested?!

    I'm not at my comupter now so i can't test it...

    Thank you very much for your reply...

    Best,

    Wolfgang

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hide All Comments On All Sheets... (XP-PRO OFF

    There is no need to select all sheets. The View | Comments menu option toggles the visibility of all comments in all worksheets in all open workbooks.

  5. #5
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts

    Re: Hide All Comments On All Sheets... (XP-PRO OFF

    Hi Hans...

    "you learn something new every day".....really.......

    thank you very much and

    best regards,

    Wolfgang

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •