Missing sheets

  • Thread starter Thread starter cmar
  • Start date Start date
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
 
Hi
any chance you have hidden these sheets (Format - sheet - unhide)?
 
Are you referring to a brand new workbook, or one you created and saved
before?
 
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top