Missing sheets

C

cmar

In my Excel 2000, when I open a workbook, only one spreadsheet appears. All
the other sheets in the workbook have disappeared.
Any suggestions would be welcome.

Thanks, CMA
 
D

Doug Kanter

Are you referring to a brand new workbook, or one you created and saved
before?
 
D

Dave Peterson

If you rightclick on those VCR like controls at the bottom left (near the
worksheet tabs), do you see all the sheet names?

If yes, then try using those "fast forward/Fast reverse" buttons to move through
the worksheets.

If that didn't help, is your scrollbar (to the right of the worksheet tabs)
hiding the worksheet tabs?

If that didn't help, maybe you're not showing the worksheet tabs at all:
tools|options|View tab
check the "sheet Tabs" checkbox.
 
C

cmar

Thanks to Frank, Doug and Dave. I was not hiding the sheets. The solution
turned out to be a variant of
Dave's second idea. Unintentionally I was hiding the scrollbar, which I made
visible again by clicking on the restore button in the upper right hand
corner of the window.
Thanks, guys, for the help.
Cheers, CMA
 
Top