Only one worksheet in a workbook is available for viewing.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
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...
 
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)
 
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.
 
Maybe those tabs and scrollbar are just outside the visible screen.

Window|arrange|tiled
(and manually resize the way you want)
 
That worked! Thank You sooo much!

Chip Pearson said:
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)
Click to expand...
 
That worked! Thank you sooo much!

Sandy Mann said:
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
Click to expand...
 
Back
Top