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?