Google Answers Logo
View Question
Q: Excel Question ( Answered 5 out of 5 stars,   3 Comments )
Subject: Excel Question
Category: Computers > Software
Asked by: regino-ga
List Price: $5.00
Posted: 27 Nov 2006 04:32 PST
Expires: 27 Dec 2006 04:32 PST
Question ID: 785891
Is there a way to tell which worksheet you are looking at in a
workbook when you are looking at the sheet?  In other words, if you
have fifty worksheets in a workbook, how do you know which one you are
looking at?
Subject: Re: Excel Question
Answered By: hummer-ga on 27 Nov 2006 07:12 PST
Rated:5 out of 5 stars
Hi again, regino! I hope all is going well for you.

You have the option of listing "sheet tabs" along the bottom of each
workbook. If you can't see your tabs, perhaps you have them "hidden".

Go to Tools / Options / View
Under "Windows Options" make sure "Sheet Tabs" is clicked. Click Ok.
You will now have sheet tabs at the bottom of your workbook.

To can pick and choose which sheets to hide:

Select the sheets you want to hide.
Go to Format / Sheet / select Hide.

To unhide a sheet:

Select Format / Sheet / Unhide
In the next window that appears, select the sheet that you'd like to unhide.

Navigating Excel's sheets [besides a great tip, you can see what the
tabs look like here]
"Here's a little-known trick that will allow you to bypass repeated
scrolling or typing: Display a pop-up list of sheet names by
right-clicking one of the arrows to the left of the sheet tabs that
are located at the bottom of the worksheet window (see the figure
below). Select a sheet from the list, and you're there in a flash."

Excel - Sheet Tabs Missing

Resize Excel's sheet tabs

Excel 2002 Tips and Tricks

As always, if you have any questions, please post a clarification
request and I'll be happy to respond.

Thank you,

Google Search Terms Used: excel sheets tabs unhide

Clarification of Answer by hummer-ga on 27 Nov 2006 16:58 PST
Hi regino,

I'm so sorry for misunderstanding your question! Also, I'm afraid I
can't help you on how to display the number of sheets, beyond the
handy little pop-up list. I'm sure someone could write a little macro
(sheetcount) for you but unfortunately that's not my expertise.

regino-ga rated this answer:5 out of 5 stars and gave an additional tip of: $2.00
Good work, thanks.

Subject: Re: Excel Question
From: barneca-ga on 27 Nov 2006 14:03 PST
i had no idea the sheet tabs were even optional.  regino, how in the
world do you nevigate between sheets without the tabs?  i turned them
off just to see what would happen, and could not find a way to get
from one sheet to the other.

Subject: Re: Excel Question
From: regino-ga on 27 Nov 2006 14:25 PST
Great job as usual.  I'm sorry that I did not make myself clear.  I
have several workbooks that contain several sheets each and while I do
have tabs at the bottom, I wanted to see a number perhaphs at the
bottom representing how many sheets the workbook had upon opening it. 
If that's not possible, that's okay.  I really appreciate the
shortcut.  It's going to come in very handy. Thanks
Subject: Re: Excel Question
From: hummer-ga on 28 Nov 2006 13:26 PST
Dear regino,

You are too kind - hopefully I will get it right next time! 

Thank you for the tip :)
Take care,

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy