Changing the size of sheetname tabs
Related to this, is there a quick way to move a sheet when you have a
lot of sheets in a file?
I was working on a file yesterday where I have about 30 sheets, one for
each location, where I record electricity usage information. Every
quarter I produce a summary sheet from these 30 and I want to move the
previous quarter's sheet to be beyond the 30 site sheets (i.e. so that
it is in front of the summary sheet from 2 quarters ago etc). As the
sheet tabs contain the name of the location, I can only see about 5 or
6 of them on screen, so dragging the previous summary sheet to position
31 had to be done in several stages. Any tips on improving this?
Pete
RagDyer wrote:
No you can't!
BUT ... you can right click on the small directional arrows to the left of
the sheet tabs, and get an XL built-in table of contents.
This lists the first 15 tabs, and can be expanded into an infinitely
scrolling list, where a single click on any sheet name will put you
immediately into that sheet, much as a hyperlink.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Edward" wrote in message
oups.com...
Can the size of sheetname tabs be changed, so that if you have say 30
of them you don't have to scroll a country mile to find the correct
sheet?
Ed
|