Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I found Row 14 in wksh 2, can I get the value of J14 into wksh 1? | Excel Worksheet Functions | |||
Pull cell contents from one wksh to another if condition is met | Excel Worksheet Functions | |||
How do I calculate how many instances of a number appear in a wksh | Excel Discussion (Misc queries) | |||
How to make a key float in an excel wksh when a person scrolls. | Excel Worksheet Functions | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions |