Viewing more sheet tabs

H

Hywel

It would be nice if I could do this. I work with books that have man
worksheets. However, i find them disappearing and I can only see
few. Is there a way to display them on top of each other - for exampl
the Options menu shows two layers of tabs. Can Excel do this with th
sheets?
Many thanks
Hywel

Manchester, U
 
K

kkknie

Don't think that is an option. The only thing you can do is decreas
the size of the horizontal scroll bar at the bottom to as small a
possible (drag it to resize it). That will give you a bit more roo
for tabs.
 
G

Gord Dibben

Hywel

Can have one row of sheet tabs only.

Work-around...........

Right-click on one of the sheet navigation arrows(left side bottom).

You will get a list of 15 sheets to select from.

If have more than 15 sheets click on "More Sheets".

Gord Dibben Excel MVP
 
Top