Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I cannot review my named sheet tabs on my spreadsheet
I have an excel spreadsheet w/named sheet tabs. I am not able to view them. i
have done something to the spreadsheet. There is nothing to unhide and i have checked the TOOLS, OPTIONS, VIEW and the appropriate boxes are checked. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I cannot review my named sheet tabs on my spreadsheet
Make sure the horizontal scroll bar has not been overly lengthened.
-- Gary's Student "ctaylor" wrote: I have an excel spreadsheet w/named sheet tabs. I am not able to view them. i have done something to the spreadsheet. There is nothing to unhide and i have checked the TOOLS, OPTIONS, VIEW and the appropriate boxes are checked. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I cannot review my named sheet tabs on my spreadsheet
How do I check that?
"Gary''s Student" wrote: Make sure the horizontal scroll bar has not been overly lengthened. -- Gary's Student "ctaylor" wrote: I have an excel spreadsheet w/named sheet tabs. I am not able to view them. i have done something to the spreadsheet. There is nothing to unhide and i have checked the TOOLS, OPTIONS, VIEW and the appropriate boxes are checked. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I cannot review my named sheet tabs on my spreadsheet
Sheet tabs disappear if you click View-Full Screen; but, other stuff
disappears and you initially get a command bar with a "close full screen" button on it. View then Full Screen will return it to normal if that is what happened though. Good luck. Ken ctaylor wrote: I have an excel spreadsheet w/named sheet tabs. I am not able to view them. i have done something to the spreadsheet. There is nothing to unhide and i have checked the TOOLS, OPTIONS, VIEW and the appropriate boxes are checked. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I cannot review my named sheet tabs on my spreadsheet
Just to verify, the Sheet Tabs check box in ToolsOptionsViewWindow
Options section is checked? "ctaylor" wrote in message ... I have an excel spreadsheet w/named sheet tabs. I am not able to view them. i have done something to the spreadsheet. There is nothing to unhide and i have checked the TOOLS, OPTIONS, VIEW and the appropriate boxes are checked. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I cannot review my named sheet tabs on my spreadsheet
If you right-click where the tabs used to be and you see a bunch of scroll
and page options, that's it. You can un-do it by carefully grabbing the end of the scroll bar and manually shortening it or by running this one-line macro: Sub get_those_tabs_back() ActiveWindow.TabRatio = 0.75 End Sub -- Gary's Student "ctaylor" wrote: How do I check that? "Gary''s Student" wrote: Make sure the horizontal scroll bar has not been overly lengthened. -- Gary's Student "ctaylor" wrote: I have an excel spreadsheet w/named sheet tabs. I am not able to view them. i have done something to the spreadsheet. There is nothing to unhide and i have checked the TOOLS, OPTIONS, VIEW and the appropriate boxes are checked. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I cannot review my named sheet tabs on my spreadsheet
Yes. I had a co-worker look at it and she clicked on the maximize screen and
drug the file and the tabs reappeared. Thanks for your respomse "Conan Kelly" wrote: Just to verify, the Sheet Tabs check box in ToolsOptionsViewWindow Options section is checked? "ctaylor" wrote in message ... I have an excel spreadsheet w/named sheet tabs. I am not able to view them. i have done something to the spreadsheet. There is nothing to unhide and i have checked the TOOLS, OPTIONS, VIEW and the appropriate boxes are checked. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I cannot review my named sheet tabs on my spreadsheet
I had a co-worker look at it and she fixed it, she's not quite sure what she
did. " wrote: Sheet tabs disappear if you click View-Full Screen; but, other stuff disappears and you initially get a command bar with a "close full screen" button on it. View then Full Screen will return it to normal if that is what happened though. Good luck. Ken ctaylor wrote: I have an excel spreadsheet w/named sheet tabs. I am not able to view them. i have done something to the spreadsheet. There is nothing to unhide and i have checked the TOOLS, OPTIONS, VIEW and the appropriate boxes are checked. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I cannot review my named sheet tabs on my spreadsheet
A co-worker fixed it.
"Gary''s Student" wrote: If you right-click where the tabs used to be and you see a bunch of scroll and page options, that's it. You can un-do it by carefully grabbing the end of the scroll bar and manually shortening it or by running this one-line macro: Sub get_those_tabs_back() ActiveWindow.TabRatio = 0.75 End Sub -- Gary's Student "ctaylor" wrote: How do I check that? "Gary''s Student" wrote: Make sure the horizontal scroll bar has not been overly lengthened. -- Gary's Student "ctaylor" wrote: I have an excel spreadsheet w/named sheet tabs. I am not able to view them. i have done something to the spreadsheet. There is nothing to unhide and i have checked the TOOLS, OPTIONS, VIEW and the appropriate boxes are checked. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named Ranges | Excel Worksheet Functions | |||
How to open a spreadsheet on a named sheet from a hyperlink? | Links and Linking in Excel | |||
Sheet Tabs | Excel Discussion (Misc queries) | |||
Tabs accross of bottom of sheet are not showing | Excel Discussion (Misc queries) | |||
Sheet tabs disappear sometimes in Internet Explorer | Excel Discussion (Misc queries) |