How do I get all the tabs and pages of the worksheets to appear?

[coolbeans]

All of my workbooks are missing the tabs and their pages. I went to unhide
tabs and that didn't work. I've done this before and I thought it had
something to do with the view but I can't figure it out. Can anyone help me?

 

[David Biddulph]

Tools/ Options/ View/ Sheet tabs

 

[EJ]

I am new to office 2007. I miss the "tools" area. How do you find it? I've
been looking and looking. If I choose full page view, I can see the tabs,
but not the top ribbons. This is awful. I have several sheets and I have
data for my students and the grades are due, and I can't switch sheets. I
must have done something last night, but I can't find it today.
EJ

 

[EJ]

Ok, I've been looking all over - I found the new options area and checked to
view the ribbon, scroll, tabs, etc. I still can't see the tabs for the other
worksheets.
This is a really hard learning curve.

 

[David Biddulph]

I wonder whether you've got a window which is positioned so that the tabs
are off the screen? In Excel 2003 I would use Window/ Arrange, so in 2007
it would be View/ Window/ Arrange All. After you've arranged the window so
that you can see it all, you can maximise the window if you want to.

If you are still struggling with conversion from Excel 2003 to 2007
commands, try
http://office.microsoft.com/en-us/excel/HA101491511033.aspx or
http://www.rondebruin.nl/0307commands.htm or
http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=9028218

 

[EJ]

Wow! David! Thank you so much. I found that arrange all icon, clicked it,
and presto! I'm back in business! This is so counter-intuitive! There's no
way I would have figured it out on my own. I'm so thankful. Have a wonderful
2009. You deserve it!
EJ

 

[David Biddulph]

Glad to hear that it did the trick.