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?

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."
http://j-walk.com/ss/excel/usertips/tip049.htm

Excel - Sheet Tabs Missing
http://domino.lancs.ac.uk/pub/usghelpdesk.nsf/aff64e3ca4d862fd80256801006e0a22/1369A9AAB3E5EBD78025698A0041FD1F?OpenDocument

Resize Excel's sheet tabs
http://j-walk.com/ss/excel/usertips/tip021.htm

Excel 2002 Tips and Tricks
http://www.microsoft.com/office/previous/xp/tips/Excel.asp

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

Thank you,
hummer

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.

Sincerely,
hummer

Good work, thanks.

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.

-cab

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

Dear regino,

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

Thank you for the tip :)
Take care,
H