Forum Discussion

sudha1k's avatar
sudha1k
Copper Contributor
Sep 28, 2021
Solved

Need help on Collapsing and Expanding Worksheet Tabs in Excel

Hi, 

I want to create tabs in excel that expands and shows other tabs associated with it.  For example, I have tabs A, A1, A2, A3, B, B1, B2, B3 . . etc. I want tabs A1, A2, A3 and be shown only when I click on tab A and tabs B1, B2, B3 only when I click on tab B. Can anyone guide me. 

 

Thanks

Sudha

excel
    • lisaxiong's avatar
      lisaxiong
      Copper Contributor
      May 11, 2022

      HansVogelaar 

      I need to create more collapsible tabs (12 for each month of the year). How do I add more collapsible tabs? I would greatly appreciate your help!

      • HansVogelaar's avatar
        HansVogelaar
        MVP
        May 11, 2022

        lisaxiong 

        Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.

    • sudha1k's avatar
      sudha1k
      Copper Contributor
      Sep 29, 2021

      Hi Hans,
      Thank you very much. Very useful.

Resources