Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Is this outline? or subtotal? (all - I guess)

    I have received a spreadsheet with markings along the left on rows 1-12 (see picture). What are these markings? I found that if I click on the top "box" (with the vertical line), rows 1-12 disappear (hide?). When I click on the bottom box, they reappear.

    How I remove this? And... how is it done?

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

    Re: Is this outline? or subtotal? (all - I guess)

    It looks like an outline, so you should be able to remove it by selecting Data | Group and Outline | Clear Outline. The Data | Group and Outline submenu can also be used to create an outline, as well as Data | Subtotals. You can find info about outlines in the Excel help.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Is this outline? or subtotal? (all - I guess)

    Another alternative is to "HIDE" the outlines. If you remove them it may expose details that are not necessary!
    To hide the symbols, use the shortkey combination: CTRL + 8. (The 8 is above the alpha characters, NOT in the numeric keypad!) Use the same shortkey to unhide them again.
    Regards,
    Rudi

Posting Permissions

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