Inner window frozen

  • Thread starter Thread starter BobB
  • Start date Start date
B

BobB

I used to be able to move the spreadsheet within the overall Excel window.
Somehow I have lost this ability and the spreadsheet is now fixed. There
use to be a blue title bar that I could use to move the spreadsheet around.
What did I do? and how do I undo it?

Bob
 
Click on the "Restore" Icon.

Sounds like you have the window maximized.


Gord Dibben MS Excel MVP
 
If Excel and the workbook windows are maximized.............

At top right of window you will have 3 icons on each of two bars.

A minis sign for minimizing, a double box for restoring or a single box for
maximizing and an "x" for closing

Click on the lower of the two double boxes to restore the workbook window.


Gord
 
Bob,

Your workbook is Protected.

Go to "review"

"unprotect workbook"

Then you should be sweet

Have a good one
 
Hi,

This question is not clear, however, assuming you have a sheet protection
problem, if you are using 2003 or earlier, choose Tools, Protection,
Unprotect Worksheet. If you need a password I can't help.
 
Hello, I?m having a similar issue. I?m trying to open a work sheet in excel 2007 on windows vista, I know the passwords for the workbook and work sheets. When opening the file it shows up as a resorted window in excel and the menu bar to minimise/maximise seems to be disabled. Within the tiny window that has opened i can still use the scroll bars and access the sheets and cells. if i open another excel workbook and arrange by tiled, only the one arranges to the full workbook. I have other work books that open just fine. Can anyone help me figure out what is going on here? Please and thanks.
 
Instead of using the menutems under the 'Window' menu, just click the
middle form control button to change the window from full sheet view
(not blue title bar, not moveable/sizeable) to normal window view (blue
title bar, moveable/sizeable). That's the button immediately left of
the 'X' (Close) button on the right side of the toolbar (if full window
view) or the title bar (if normal window view).
 
Back
Top