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

Embed the same Excel multiple times 0
Merging from an Excel file with graphics 1
Update several ppt documents from a single excel file 0
Default local file location - folder redirection slowness 0
Calculate the median value before a specified list 0
Text in note pane of "normal" display suddenly much larger 1
Word 2016 - Difficulties Learning Style Creation/Application 0
Cannot copy worksheet to another file 2

Top