Aligning Sheet Tabs in Excel

[NealUK]

I have a spreadsheet at work, that has about 30-40 different sheets, and a
main suppliers sheet.
When i click on a supplier, it takes me to the first Sheet of that supplier
(there are about 5 sheets per supplier).
To get to the next sheet, i have to scroll the whole document left to reveal
the tabs.
This is because, when i clicked on the link to the first sheet of that
supplier, it aligns the tab to the right, rather than the left.
Is there a setting that i can change that will align the current tab to the
left of the screen, and not the right?

Many thanks for any help
regards
Neal


--

 

[Dave Peterson]

Not that I'm aware.

But you could shiftclick on the inside arrows (in the VCR like controls) and
have the worksheets shown move right/left a page at a time.

Or you could rightclick on those vcr controls and see a list (which could
include an option to see more sheets--if they didn't all fit).

and you may want to skinny up the scrollbar for the activeworksheet. You can
make it take less screen realestate and have the tabs take more--just drag that
separator to the right/left to move it.