ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how come some excel files have no worksheet tab to go to some wksh (https://www.excelbanter.com/excel-discussion-misc-queries/239617-how-come-some-excel-files-have-no-worksheet-tab-go-some-wksh.html)

Boku

how come some excel files have no worksheet tab to go to some wksh
 
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!


Vijay Chary

how come some excel files have no worksheet tab to go to some wksh
 
Dear Boku !! If you can't see the worksheet tabs at the bottom of the screen,
Excel 2003 - Go to ToolsOptionsView. 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 ! :)

"Boku" wrote:

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!


Jacob Skaria

how come some excel files have no worksheet tab to go to some wksh
 
Open the workbook. Check out ToolsOptionsView tab 'Sheet tabs'. check that
and save the workbook and try re-opening..

If this post helps click Yes
---------------
Jacob Skaria


"Boku" wrote:

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!



All times are GMT +1. The time now is 03:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com