Only one worksheet in a workbook is available for viewing.
 

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?

Only one worksheet in a workbook is available for viewing.
 

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


Replace @mailinator.com with @tiscali.co.uk


"missleigh" wrote in message
...
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?

Only one worksheet in a workbook is available for viewing.
 

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...

"missleigh" wrote:

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?

Only one worksheet in a workbook is available for viewing.
 

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)


"missleigh" wrote in message
...
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?

Only one worksheet in a workbook is available for viewing.
 

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.

"RayportingMonkey" wrote:

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...

"missleigh" wrote:

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?

Only one worksheet in a workbook is available for viewing.
 

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

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

missleigh wrote:

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?

--

Dave Peterson

Only one worksheet in a workbook is available for viewing.
 

That worked! Thank you sooo much!

"Sandy Mann" wrote:

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


Replace @mailinator.com with @tiscali.co.uk


"missleigh" wrote in message
...
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?

Only one worksheet in a workbook is available for viewing.
 

That worked! Thank You sooo much!

"Chip Pearson" wrote:

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)


"missleigh" wrote in message
...
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?