+ Reply to Thread
Results 1 to 4 of 4

Expand/Collapse data by trigger cells

  1. #1
    Registered User
    Join Date
    12-17-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    39

    Expand/Collapse data by trigger cells

    Hi,

    I have a set of data which I have arranged into 3 levels by grouping. Please see the attached for an example of my data.

    I would like to double click the level 1 (B3) heading and it should expand into level 2. Then i would like to double click any of the headings in level 2 to expand into its respective level 3.

    This should work for expanding and collapsing of the data. eg. Double clicking B3 once should expand into level 2, and double clicking it again should collapse the data into level 1.

    Is this possible? any assistance would be much appreciated.

    Thanks in advance!
    A-man
    Attached Files Attached Files

  2. #2
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Expand/Collapse data by trigger cells

    Maybe :

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    12-17-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Expand/Collapse data by trigger cells

    Thank you! This is exactly what I've been looking for!

  4. #4
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Expand/Collapse data by trigger cells

    You are welcome, glad I can help.


    Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to expand and collapse rows based on criteria in cells
    By jholiday78 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-26-2015, 10:32 AM
  2. Macro to expand or collapse fields with 0 data
    By ahouston in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-07-2015, 10:47 AM
  3. [SOLVED] Data Outlining (Collapse / Expand) - setting user restrictions
    By TC1980 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2013, 09:00 AM
  4. Expand and Collapse Date Cells - Gantt Chart
    By hrmason in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-17-2013, 07:55 AM
  5. Replies: 0
    Last Post: 04-18-2012, 01:41 PM
  6. Expand/Collapse Grouped Data in Protected Worksheet
    By Robert Slattery in forum Excel General
    Replies: 4
    Last Post: 11-08-2005, 03:10 PM
  7. Expand and Collapse Cells?
    By fernandes70 in forum Excel General
    Replies: 1
    Last Post: 03-19-2005, 01:50 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1