There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
Business Applications
Tag Cloud
access acer asus bios bsod computer crash drive driver drivers error ethernet excel freeze games gaming graphics hard drive hardware hdmi internet laptop malware memory monitor motherboard netgear network printer problem ram random registry router slow software sound trojan usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless xbox
Search
Search for:
Tech Support Guy Forums > Software & Hardware > Business Applications >
Excel - Automatic Table of Contents?

Reply  
Thread Tools
Peacock's Avatar
Member with 48 posts.
 
Join Date: Oct 2003
Location: Baltimore, MD
Experience: Advanced
10-Jun-2009, 05:00 PM #1
Excel - Automatic Table of Contents?
Does anyone know if Excel 2007 will generate a table of contents listing each sheet in the workbook? Like how Word can create a table of contents for a document?

A Google search reveals how to manually create a clickable list of tabs, but I have a big workbook and I'm hoping to avoid that.

Thanks,
Lisa
slurpee55's Avatar
Computer Specs
Distinguished Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
10-Jun-2009, 05:23 PM #2
If you download and install the free add-in for Excel, ASAP Utilities, you will find it has a sweet little tool to do that built in - the listings are links that will take you to each page.
slurpee55's Avatar
Computer Specs
Distinguished Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
10-Jun-2009, 05:26 PM #3
Here is some more info on that specific tool.
Reply

Tags
"table of contents", excel 2007, microsoft

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.
Thread Tools



Facebook Facebook Twitter Twitter TechGuy.tv TechGuy.tv Mobile TSG Mobile
You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 03:00 PM.
Copyright © 1996 - 2011 TechGuy, Inc. All rights reserved.

Powered by Cermak Technologies, Inc.