How To Organize & Manage Your Worksheets – Tab Hound & Tab Control
In the last video we learned how Tab Hound can save time with common tasks like finding and jumping to sheets, flipping between sheets, and unhiding multiple sheets.
I really appreciate all your suggestions and support for Tab Hound.
In this video I am going to explain:
- Shortcuts for copying and renaming sheets.
- A fast way to copy sheets to a new workbook.
- How to create a Table of Contents in your workbook.
- How to organize and manage your worksheets with Tab Control.
I also address some of your questions from the last video, so check it out!
Please leave a comment below letting me know what you think of Tab Hound & Tab Control.
Why Tab Control?
As I started adding more features to Tab Hound, I quickly realized that I wanted it to be able to automate more of the complex tasks I do with my worksheets. This included processes like:
- Renaming multiple sheets at one time.
- Re-ordering the sheets in the workbook.
- Changing the colors of all the tabs quickly.
- Hiding and unhiding sheets based on some criteria like the current month.
- Adding a bunch of new sheets with specific names and tab colors.
Some of these were possible in a form like the Tab Hound window, but it is difficult to develop in a way that is easy for the user. My goal is to make these tools very easy to use. So that led me to use a worksheet instead.
Having the sheet list in the TabControl worksheet makes it very easy to work with. You can quickly rename the sheets in the cells, change the tab colors with the fill color, sort and re-order the list with the Filters, etc. And you can do this in an environment that you are very familiar with (the Excel worksheet).
In this video I only scratch the surface of what is possible with Tab Control. There are a lot of possibilities with this tool, and I can't wait to see what you will do with it.
In the next video I will show examples of how I use Tab Control to automate some monthly reporting packages. I am also going to give more info on when Tab Hound and Tab Control will be available.
What Do You Think?
I really appreciate you taking the time to leave a comment with your thoughts about these tools. Your suggestions are great, and it's nice to learn more about how you are using Excel.
Thank you! 🙂
Please watch the next video in this series to see a real world example of how you can use Tab Control to automate your processes.
Tab Hound is Now Available
The Tab Hound Add-in is now available. Please click the link below to learn more about it.