Too Many Tabs

lpaulg3

New Member
Joined
Feb 9, 2014
Messages
26
I have kept a spreadsheet for years that contains tons of lists that I may need on a moment's notice. The problem is I have to slowly pick my way through all the tabs at the bottom to find the one I'm looking for.
Is there a way to group several workbooks together under one tab?
e.g. rather than having tabs at the bottom like this:
Paul Mary Jim Nancy 10-12-13 Mike Sally Equipment Sizes Scores Travel 10-14-13 9-05-13
I'd rather see:
Men Women Dates Stats Equipment
Under the "Men" tab I would see the following tabs: Paul Jim Mike
Under the "Women" tab I would see the following tabs: Mary Nancy Sally
etc.

Or, is the only way to sort the spreadsheet quickly -a table of contents with hyperlinks? (not preferred)
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,770
Office Version
  1. 2010
Platform
  1. Windows
There's no way to have hierarchical tabs.
 

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,779
If you right click on the tab arrows at the bottom of the sheet, a list of all the sheets will appear, allowing you to click straight to your sheet.
 

ttdk1

Board Regular
Joined
May 21, 2014
Messages
189
you can make a macro that list all your tabs by name on a worksheet column with checkbox next to them. toggling the checkbox to hide or unhide tabs.. less visible tabs are more manageable
 

Watch MrExcel Video

Forum statistics

Threads
1,108,986
Messages
5,526,065
Members
409,685
Latest member
Davetom

This Week's Hot Topics

Top