Only one worksheet in a workbook is available for viewing.

[Guest]

My workbook had 5 tabs for worksheets. Now only one worksheet is available
for viewing or selecting, and it does not have a tab at the bottom. What
could have happened to the tabs and additional worksheets?

 

[Sandy Mann]

Try:

Tools > Options > View and see if the check mark is still in "Sheet tabs"

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Guest]

There are a series of left and right arrows just to the left of your
worksheet tabs. Make sure it hasn't simply scrolled over...

 

[Chip Pearson]

Go to the Tools menu, choose Options, then the View tab. There, make sure
that the "Sheet Tabs" checkbox (in the lower right) is checked.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[Guest]

No, that is not it. The tabs do not show, at all. Also, the down arrow on
the right side of the page has disapppeared as well and I have to repeatedly
press the enter key in order for the bottom of the page to come into view.

 

[Dave Peterson]

Maybe those tabs and scrollbar are just outside the visible screen.

Window|arrange|tiled
(and manually resize the way you want)

 

[Guest]

That worked! Thank You sooo much!

Go to the Tools menu, choose Options, then the View tab. There, make sure
that the "Sheet Tabs" checkbox (in the lower right) is checked.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[Guest]

That worked! Thank you sooo much!

Try:

Tools > Options > View and see if the check mark is still in "Sheet tabs"

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk