If you do these repetitive tasks in Excel:
- Searching for worksheets and navigating to them.
- Hiding and unhiding sheets.
- Copying and renaming sheets.
- Protecting and unprotecting sheets.
- Moving, organizing, and coloring sheets.
- Flipping back and forth between two sheets.
Then there is a solution that will help save you a lot of time…
Finding Sheets in a Workbook can be Time Consuming
Do you ever work with Excel files that contain more than 5 or 10 worksheets?
If so, you probably find yourself spending extra time navigating through these workbooks.
Especially when you are in a meeting, or someone is looking over your shoulder. Have you ever said these words when looking for a sheet in your workbook, “Hold on boss, I know it's here somewhere…”?
Just finding a worksheet in a large workbook can be a frustrating and time consuming task.
You have to scroll horizontally across the tab names at the bottom of the screen. And you either click the scroll arrows repeatedly with the mouse, or press the Ctrl+Page Up/Page Down keyboard shortcuts.
We Spend Too Much Time Doing Repetitive Tasks
What about common everyday processes like:
- Hiding & unhiding sheets
- Copying & renaming sheets
- Protecting & unprotecting sheets
- Moving, organizing, coloring sheets, etc.
Do you feel like you spend extra time doing any of the above?
If so, you're not alone.
These are common tasks we do every day, but they are not always easy to perform. Often times you will find yourself doing the same repetitive task over and over again, just to produce the same result as last week or last month.
Excel is an amazing tool, and it can be very fun and exciting to use. But these repetitive tasks are NOT the fun part. They take time away from your overall mission of finding and analyzing results to help make better business decisions.
Producing Results is the Most Important Part of Your Job
Your job is important and you are probably responsible for adding a lot of value to your organization through you work. Whether you are scrubbing data or creating complex financial models and dashboards, you are helping your organization succeed.
The more time you spend producing the results, the greater the impact you will have in your organization and your career. But spending time doing common repetitive tasks like, “unhiding 10 sheets for this month's reporting package”, takes time away from other tasks that are more important (and fun).
So how do we spend more time doing the fun stuff that will help others, and less time doing the boring repetitive stuff?
Well, I'm going to show you a few tools that will save you a lot of time with these common processes. Tools that are very easy to use…
We Need a Faster Way…
My name is Jon and I use Excel all day, every day.
I love Excel! 🙂
I spend so much time using it that Microsoft recently awarded me with their MVP award. Well, I think they actually gave me the award for helping others learn how to use Excel. But either way, I spend a lot of time using Excel.
Since I spend so much time using Excel, I strive to use it in the most efficient way possible. If you read my blog then you know I focus on saving time and being productive. I want to get my work done as quick as possible so I can spend time enjoying life with my family and loved ones.
One thing I've always found challenging in Excel is navigating to a specific worksheet in a workbook. Especially when this workbook contains a lot of sheets. It's difficult to find a worksheet and then navigate to it. Excel does NOT have a built-in search feature for this.
So I decided to create a tool that would solve this problem.
I wanted a way to quickly search for a worksheet and then jump to it. It needs to be as simple as performing a Google search; just type the sheet name in a box to search for it, select the sheet from a list of results, and then jump that sheet. Sounds simple right? Well now it is…
The tool I built to do this is Tab Hound.
Tab Hound is an add-in for Excel that will save you a ton of time with your everyday worksheet tasks. It is packed with features that automate common processes, and help you get your job done quickly.
Quickly Search and Jump To Worksheets with Tab Hound
Tab Hound makes it extremely fast and easy to find any sheet in your workbook and jump right to it.
I wanted a way to perform this search without touching the mouse. Simply press a keyboard shortcut, type the name of the sheet I'm looking for, then press enter to go to that sheet. Tab Hound makes this possible whether you're a keyboard or mouse user. Either way, it's lightning fast!
Searching sheet names was originally the main purpose behind Tab Hound. But it has turned into so much more…
Tab Hound Makes it FAST & EASY to Perform Common Tasks
I also wanted a way to automate other time consuming tasks like:
- copying and renaming sheets,
- copying sheets to a new workbook,
- unhiding multiple sheets at the same time, etc.
These are tasks we all do frequently, and they require multiple steps to complete.
Did you know Excel requires six mouse clicks to copy a sheet to a new workbook?
That's a lot of steps for such a simple task. And mouse clicks are time consuming because you are required to move the mouse to a new location for each of those clicks. If you are using a laptop trackpad, then this process can be very slow.
So I quickly started adding buttons to Tab Hound to automate these processes.
I added buttons to:
- Hide or Unhide multiple sheets at the same time.
- Copy & rename sheets.
- Copy sheets to a new workbook.
- Jump to the first or last sheet.
- Move sheets up, down, first, or last.
- Delete sheets.
- Protect and Unprotect sheets.
- Flip Back and forth between two sheets.
I also added a Stats Bar and Filters to help answer questions about my workbooks:
- How many worksheets are in this workbook?
- How many hidden sheets?
- How many sheets with a specific tab color?
- Show me all my sheets that have a specific tab color.
- Show me all my hidden sheets that have the word “jan” in the sheet name.
All these simple requests became possible with Tab Hound.
Tab Hound Saves You Time and is VERY EASY to Use
The next thing I focused on was making Tab Hound easy to use.
Tab Hound will change how you work with the worksheets in your workbooks. It will save you a lot of time. And it does so by being very easy to use.
It makes these processes faster and easier to perform than doing them the way you normally would in Excel.
Copying and Renaming Sheets Becomes a Simple Task
For example, imagine if you had to teach a new co-worker how to copy and rename a sheet. You would instruct them to do something like the following:
- Right click the tab name.
- Select Move or Copy… from the list.
- Select the sheet you want to place the copy before from the list.
- Click the create a copy check box.
- Click Ok.
- Double-click on the tab name
- Type a new name for the sheet and press enter.
That's a lot of steps to learn and remember for a newbie.
With Tab Hound, here is how you would instruct your co-worker to copy and rename a sheet.
- Right-click the Tab.
- Select Copy and Rename.
- Type a new name in the box that automatically appears and press Enter.
As you can see there are half as many steps with Tab Hound. All steps can be done with keyboard shortcuts or the mouse. And you can copy & rename multiple sheets with the help of Tab Hounds filters to make this process even faster.
The point is that Tab Hound will not only save you time, but it is also very easy and intuitive.
Your workbooks will become more organized, easier to manage, and easier for others to use and understand.
Add a Table of Contents to Your Workbooks
Speaking of making it easier for the readers or consumers of your workbooks… Tab Hound also includes a Table of Contents feature.
With a click of a button, you can quickly add a Table of Contents sheet to the front of your workbook that contains links to each sheet.
This makes it very easy for the users of your file to see all the sheets in the workbook, and quickly navigate to them. The Table of Contents also contains options that allow you to display the tab color in the list. This makes it easy to distinguish different groups of tabs, and keeps the list organized.
You can also add this Table of Contents Gallery sheet that contains clickable image thumbnails of all the sheets in the workbook. It's a great way for your users to preview all sheets in the workbook, and quickly navigate to the sheet they are looking for.
A Quick Shortcut to Flip Between Two Sheets
Do you ever spend time working between two different worksheets?
Maybe you are copying and pasting data or formulas between sheets. Maybe you are checking the results of a few formulas, and you need to jump back to the sheet that contains the source data.
Whatever it is, this process can take a lot of time if the worksheets are not located next to each other in the workbook.
Tab Hound has a button called Flip Back that will save you a ton of time when working between two sheets.
Simply press the Flip Back button on the ribbon to go to the last sheet you were on. You can also use a keyboard shortcut to press this button. So flipping between two sheets becomes lightning fast. You can repeatedly press the Flip Back button to jump back and forth between two sheets.
Flip Back is also great if you forget what sheet you were just looking at. I hate when this happens and now I can just press the Flip Back button to go back to the last sheet I was on.
Change How You Work With Excel
Well, what do you think? Do you want to dramatically increase your productivity and save a ton of time with your everyday tasks? Tab Hound will change how you work with your workbooks and help you get your work done in a fraction of the time. You will be able to spend more time on important (and fun) work that helps you make a bigger impact. No one is ever judged by how many sheets they could unhide in a minute… 🙂 So why waste time doing it?
The goal of Tab Hound is to help you navigate through your workbooks and get your job done faster.
What Others are Saying…
I routinely work with very large workbooks with 90 or more worksheets in each workbook. Tab Hound and Tab Control are great! They have made navigating, organizing, and working with large workbooks much easier and incredibly faster. Anyone who has to switch back and forth between worksheets when building complex formulas will love the Flip Back feature! This is one of my favorite uses for Tab Hound. Thank you Jon for making such a useful and time saving Add-In!Peter R., Logistics Engineer
Unhide multiple sheets – awesome because one by one unhiding is a pain.
Color sheet and alpha filter – very nice and useful feature. Like it.
Copy sheet to new book – another time saver, having to go through multiple clicks and to do it in couple of clicks, this is very useful.
Tab control – renaming, moving, this is great. One thing I might recommend is to add another column, an original sort column, that will allow resorting the tab list in a different manner and/or, put it back the way it was.
Other than that, and other than I hate crazy long spreadsheets, these are 2 great tools.Don H., VP Financial Planning & Analysis
I'm sure that this will help heaps of people using Excel.”John M., Chief Inspirational Officer at MyExcelOnline.com
Tab Hound Features Overview
Here's Exactly What You Get with Tab Hound
The Tab Hound Add-in that will help you fly through your workbooks and perform everyday tasks with ease.
- Quickly search and jump to the worksheets in your workbooks with Search.
- Hide and Unhide multiple sheets at the same time.
- Copy & rename sheets with the click of a button.
- Copy sheets to a new book in one step, instead of six.
- Move sheets with-in the workbook.
- Protect/Unprotect multiple sheets at the same time.
- Add a Table of Contents to your workbook.
- Flip back and forth between two sheets.
- And much more!
The Tab Control Add-in
Learn more about Tab Control…
Get these free bonuses with along with Tab Hound for a limited time.
Free Bonus #1: Navigate Excel with the Keyboard eBook – Intro to Becoming a Keyboard Ninja
Tab Hound & Tab Control are now a part of our Hero Tools Suite
The Hero Tools Suite combines all of our add-ins into one Excel add-in with over 100 features that will save you time with your everday Excel tasks.