how come some excel files have no worksheet tab to go to some wksh

B

Boku

Dear all,
I have one excel file and when i open it, I don't see the worksheet tab in
the bottom of the excel window.
How is such file made? And how can I change back to some normal sheet.

Thank you!
 
V

Vijay Chary

Dear Boku !! If you can't see the worksheet tabs at the bottom of the screen,
Excel 2003 - Go to Tools>Options>View. Find 'Display sheet tabs' check box
and check it. In Excel 2007 - Click on the icon at the top left corner of the
screen. Click on Excel Options tab at the bottom and do as you would for
Excel 2003.
Good Luck ! :)
 
J

Jacob Skaria

Open the workbook. Check out Tools>Options>View tab 'Sheet tabs'. check that
and save the workbook and try re-opening..

If this post helps click Yes
 

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

Similar Threads

Cannot copy worksheet to another file 2
Protected Worksheet Tab Order 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
E-mailing worksheet from Excel -- only one tab 1
'Cannot insert object' message when I try to put a button on a worksheet 7
Excel 2007 crashes on copying worksheet to new workbook 0
worksheet renames - specific 0
Tab worksheet 2

Top