Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Viewing separate worksheets in a workbook on 2 different monitors | Setting up and Configuration of Excel | |||
Dual Monitors: Viewing different tabs in same workbook? | Excel Discussion (Misc queries) | |||
Viewing multiple rows of worksheets in a workbook | Excel Discussion (Misc queries) | |||
Viewing worksheet tabs | Excel Discussion (Misc queries) | |||
Viewing Worksheets withing One Workbook | New Users to Excel |