Lost Scroll Bars

[AnnHaney]

I am using Versions 2002 and 2003 on a Network. When I pull up my worksheet on another machine, I have no scroll bars on the left, right and bottom, which means I have no Sheets listed on the bottom.

I am trying to print out a worksheet that has about 30 sheets on it on our color printer which is hooked to this computer. But I can't navigate around to find the particular sheets I want to print out (only the ones I have sections marked in color).

I know it has got to be something silly -- I have checked "View" and it appears to have the same things checked as the other machines do. Any suggestions?

 

[Datsmart]

Specifically, are "vertical and horizontal scroll bars", and "sheet tabs", checked in the View tab of the "Tools" | "Options"?

 

[AnnHaney]

Lost Scrollbars

Yes, they are all checked.

 

[Oaktree]

Are you in full screen view (view --> full screen)?

 

[AnnHaney]

No, I am not.

 

[Datsmart]

Are both Windows and the worksheet "Maximized"?
Are all sheets of the workbook the same?
(Ctrl-PageUp to get to the previous worksheet if necessary, Ctrl-Page-Down to go back).

 

[AnnHaney]

I'm OK now - it was something in the windows minimize/maximize - there was a double box in the corner. When I made it a single box, I got the scroll bars and the tabs at the bottom back, but the worksheet was very tiny. Then I just grabbed the corners and made it big again.

I am very knowledgeable in some Excel things, but don't know some Window basics. Can anyone explain to me what just happened?

 

[Datsmart]

If you pause your cursor over the _ doublebox and X in the upper right corner of the window, it will tell you the name of each selector.
If you are not maximized, you may not see all of the workbook or window you are viewing. Clicking the item changes the selection of course.

 

[AnnHaney]

Thank you! Your board was very helpful.

 

[Greg Truby]

John beat me to the punch on this one. Even better than your situation, I have had open workbooks where the window was totally hidden (not all that hard to do when you run two screens, like I do). You can use the Window | Arrange... command to fix this kinda thing or hit Alt+- (dash) to pull up the window menu for that document-window and pick maximize from the popup.