How do I know on which worksheet an item is found?

G

Guest

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?
 
M

Mallycat

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Only one worksheet in a workbook is available for viewing. 7
Worksheet tabs at top 2
How do I print a specific worksheet everytime? 1
How do I find a worksheet tab in a spreadsheet with multiple tabs? 4
Partial printing of entire worksheet (1st or 2nd pages only) 4
Copy worksheet to new doc w/formulas not referencing previous doc 4
disappearing tab 5
Manage a high number of worksheets in one workbook (Excel 2007) 4

Top