How to Create Tabs Within Tabs in Excel

ExcelDemy
ExcelDemy
67,568
23
Published 2023-11-30
In this video, I'll guide you through multiple steps to create tabs within tabs in Excel. You'll learn about organizing required datasets, creating multiple tabs, aligning the tabs, creating a VBA code, assigning a VBA code with tabs, and compiling all tabs. Creating tabs within tabs can be used to organize and enhance the presentation of data, enabling effective sorting and display within a limited space. With practical examples and step-by-step instructions, you can effortlessly make tabs within tabs in your Excel spreadsheets.

👨‍🏫 Instructor: Farihatul Mim
🎥 Editor: Mohammad Ullah

✨ ⯆ Resources:
Alt+F11 - To open the Visual Basic

▬ Contents of this video ▬▬▬▬▬▬▬▬▬▬
0:00 - Intro
0:40 - Organizing required Datasets
1:15 - Creating multiple tabs
3:35 - Aligning the tabs
5:24 - Creating a VBA Code
7:50 - Assigning VBA Code with tabs
8:49 - Compiling all tabs

📚 ⯆ DOWNLOAD the workbook here:
www.exceldemy.com/create-tabs-within-tabs-in-excel…

🌍 ⯆ Checkout the article here:
www.exceldemy.com/create-tabs-within-tabs-in-excel…

🚩 Stay connected with us on social media for more Excel tips and tricks!
Facebook: www.facebook.com/ExcelDemy/
Twitter: twitter.com/exceldemy
LinkedIn: www.linkedin.com/company/exceldemy/

🙋‍♂️ Stuck with an Excel formula or a VBA code? You can post your questions or upload your Excel file to get in touch with the professionals and get the solution you need.
ExcelDemy Forum: exceldemy.com/forum/

👉 If you found this video helpful, don't forget to subscribe to our channel for more Excel tutorials, tips, and tricks! Hit the subscribe button and turn on notifications, so you never miss an upload. By subscribing, you'll be supporting our channel and helping us to reach more people who can benefit from our content. Thank you for watching, and we'll see you in the next video!

🔔 ⯆ Subscribe on YouTube:
youtube.com/@exceldemy2006
#excel #exceltutorial #exceltips #exceltricks
All Comments (18)
  • @carlosbastos9755
    Creative but I think that using Power Query and slicers would be much easier. This solution also requires no code at all.
  • @rwfrench66GenX
    That was very creative! Thank you for sharing this video. I would’ve put this into a pivot chart and used the three tables as a filter at the top so I could just chose what table I wanted to see. There are other ways to set this up too but this way allows for a lot of options!
  • @AymanFarag-zd4er
    Hi, thank you so much for sharing this amazing concept. Pardon me, but when I attempted to add checkboxes to the sheet, they kept appearing in each tab. Is there a way to have each checkbox appear in a tab separately? Thanks in advance.
  • @kevin66rn
    This tutorial is awesome. If I wanted to add a second tab in excel, how would the coding change?
  • @AkbarAli-es4vo
    The way you are explaining/teaching is very nice. there are little bit difference between vba code showing in video and in the attached file. However its very nice vide.
  • @vikasgupta1618
    creative. well explained. i am thankful. please keep uploading such creative excel reporting/presentation videos.
  • @dakshmishra5185
    how can i do it for google excel..pls can you make video on it !!
  • @user-cybermahmud
    Thanks for the good work. Keep uploading creative content. I am very happy to see useful content.😀😀😀🥳🥳🎉🎉
  • @AngelMendi
    Excelente su creatividad y lo fácil que lo haces ver, de verdad impresionado. Gracias. Me agradaría hacer algo así con mi trabajo...
  • @rorybryant783
    Hi there, great video and thanks for sharing. Is there any way to duplicate the tab in the same workbook and have the new tab contain all of the same macros? Thanks in advance!
  • @angelanna728
    I would like to create 7 tabs. How much more complicated would this be
  • @markantoniorodriguez5278
    Thank you for a Very well-done and pleasant to hear/follow video. Appreciate the steps, I wish you the best of luck.