Results 1 to 3 of 3

Thread: Numbered Columns displaying plus (+) and minus (-) signs next to row numbers

  1. #1
    Seeker watermt69's Avatar
    Join Date
    Nov 2014
    Posts
    11
    Articles
    0
    Excel Version
    2010

    Numbered Columns displaying plus (+) and minus (-) signs next to row numbers



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I received a report with columns numbered 1 and 2 to the far left of the Excel (2010) sheet along with plus (+) and minus (-) signs next to the row numbers that can expand or collapse hidden data. I know how to access the data but what I do not know how to do is create a similar Excel sheet for my own data. I'm not sure if this has to do with Pivot Tables or VBA programming. Can someone tell me what this king of Excel sheet is and where can I find more information on using it for one of my own Excel projects? Please see attachment for clarity with my question.
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	2019-05-14_Xcel Guru Attachment.png 
Views:	8 
Size:	3.0 KB 
ID:	9111  

  2. #2
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,662
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Under the Data tab -Outline Group - Group/Ungroup/Subtotal icons
    Thank you Ken for this secure forum.

  3. #3
    Seeker watermt69's Avatar
    Join Date
    Nov 2014
    Posts
    11
    Articles
    0
    Excel Version
    2010
    Thanks Pecoflyer, this is a new area for me as an Excel user. I appreciate your quick reply and "Wizardry"!

Posting Permissions

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