+ Reply to Thread
Results 1 to 4 of 4

Collapse/Expand tabs in Excel

  1. #1
    Registered User
    Join Date
    04-08-2015
    Location
    Philadelphia
    MS-Off Ver
    2013
    Posts
    6

    Collapse/Expand tabs in Excel

    Hello all,

    I have a worksheet that has about 15-20 tabs where 3 of them are similar and I wanted to collapse them under one single tab and have a +/- to expand or collapse as needed. Is this possible at all? I have tried reading some articles online about writing the code on VBA but it's not working for me.

    Any help is appreciated

    Thank you!

  2. #2
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: Collapse/Expand tabs in Excel

    You can't really combine them.
    However, what you could do is name the sheet tabs and do hide/show actions on activate.

    For example

    Original situation:
    Sheet 1
    Sheet 2
    Sheet 3
    Sheet 4
    Sheet 5
    Sheet 6

    "Tabbed" situation:
    Sheet 1
    Sheet 2
    Sheet 3-4
    Sheet 5-6

    When you click on Sheet3-4, there would be two Sheets (3 and 4) and Sheet 1 and 2 would be only one tab as 'Sheet 1-2'. etc

    To do this, you don't really combine the sheets, but rename them and hide/unhide on activate.
    See attach for example.

    Hope this helps.
    Attached Files Attached Files
    Please click the * below if this helps

  3. #3
    Registered User
    Join Date
    04-08-2015
    Location
    Philadelphia
    MS-Off Ver
    2013
    Posts
    6

    Re: Collapse/Expand tabs in Excel

    Hello JasperD,

    While your suggestion gave me an idea on how to combine the tabs, I couldn't get the code to work for my tabs. Maybe because I have three tabs or I am just doing it wrong. I don't know!

    Thanks anyway

  4. #4
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: Collapse/Expand tabs in Excel

    Upload a sample file please

+ 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. Excel Collapse and expand
    By dahlin in forum Excel General
    Replies: 2
    Last Post: 08-13-2013, 04:49 AM
  2. Excel - Expand and Collapse Section
    By john_prince in forum Excel General
    Replies: 7
    Last Post: 06-29-2012, 07:26 AM

Tags for this Thread

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