I use Excel 2000 and have a workbook with dozens of worksheets. To search
across all worksheets I select them all (Select All Sheets). The found cell
is bolded as well as the tab at the bottom, however, when you have dozens of
worksheets, most tabs are not visible. How do I know which worksheet I am on?

The way I do it is by scrolling to the left (using the arrows at the left of
the tabs at the bottom) until I find the highlighted tab. Of course that
takes a long time and is not very practical. What is the proper way to find
the highlighted tab?

What you describe is probably an un-intended unfortunate user experience
based on a unique need. The problem has actually been fixed - if you
upgrade to Excel 2003 you will be able to clearly see which sheet you
are on.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=553918

You may want to try Jan Karel Pieterse's FlexFind:
http://www.oaltd.co.uk/MVP/

Talar wrote:

I use Excel 2000 and have a workbook with dozens of worksheets. To search
across all worksheets I select them all (Select All Sheets). The found cell
is bolded as well as the tab at the bottom, however, when you have dozens of
worksheets, most tabs are not visible. How do I know which worksheet I am on?

The way I do it is by scrolling to the left (using the arrows at the left of
the tabs at the bottom) until I find the highlighted tab. Of course that
takes a long time and is not very practical. What is the proper way to find
the highlighted tab?

--

Dave Peterson