+ Reply to Thread
Results 1 to 2 of 2

How do i create a collapsing/expanding list?

  1. #1
    Registered User
    Join Date
    01-02-2012
    Location
    Germany
    MS-Off Ver
    Excel 2007
    Posts
    3

    How do i create a collapsing/expanding list?

    Hi,

    Hoping someone can help me. I need to create a document that contains a number of columns, each of which contains a list of data (job titles and descriptions). I want to be able to put this data into different expanding lists within the same column.

    So, a column initially displayed like this

    HR
    +HR Analyst
    +HR Finance


    can become this;

    HR
    -HR Analyst
    - Payroll
    - Admin
    - Foobar
    -HR Finance
    - Numbers
    - Pasta

    I want to repeat this across each column. I've played around with the Data/Groups but this doesn't give me what i need because it collapses all rows across the workbook, rather than just the ones in the column. It also doesn't make clear which cell can be expanded.

    Any clues on how i can do this?

    Many thanks in advance.
    Last edited by ktmduke; 01-02-2012 at 05:07 AM.

  2. #2
    Registered User
    Join Date
    01-02-2012
    Location
    Germany
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: How do i create a collapsing/expanding list?

    Bumping this in case anyone has any suggestions

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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