Hello,

Every time I open Microsoft Excel 2000, the workbook inside the main
Excel window opens in the 'restore window' position (not maximized),
and the top of the workbook with all the menus and such are off the
top of the screen.  Can you please tell me:

1) How to move the workbook down (not just minimize).  I can't see the
top of the workbook to click and drag.

2) How to restore the default workbook window sizing/placement in
excel so when I open it, it either opens maximized or with the window
centered.

Thank you!
Ed

Hi Ed,

Here you go...

1) How to move the workbook down (not just minimize).  I can't see the
top of the workbook to click and drag.

1. Hold down Alt + Spacebar.
2. Press the M key.
3. Press the DOWN arrow.
4. Now move the mouse WITHOUT clicking anything. You should see the
outline of the page moving around. When the outline is where you want
it, press ENTER.

2) How to restore the default workbook window sizing/placement in
excel so when I open it, it either opens maximized or with the window
centered.

Open your workbook.
Right click on the little workbook icon which is to the left of the
File Menu at the top of the page.
Choose "View Code".
You should see the following in one of the windows:

Private Sub Workbook_Open()
End Sub

Make it look like this and then close the whole code section:
Private Sub Workbook_Open()
Application.WindowState =xlMaximized
End Sub

Additional Links of Interest:

Microsoft Excel Tips by Categories
http://www.exceltip.com/

Mr. Excel 
http://www.mrexcel.com/articles.shtml

Hopefully you'll be all set now. If you have any questions, please
post a clarification request *before* closing/rating my answer and
I'll be happy to reply.

Thank you,
hummer

---

Request for Answer Clarification by esarkissian-ga on 28 Mar 2005 15:07 PST

Hummer,

Thanks for your answers.  I haven't tried solution #2 yet, but #1
isn't quite working.  It only works for the main Excel window, not the
"nested" workbook inside, which is the one that I can't access.  Make
sense?

Ed

---

Request for Answer Clarification by esarkissian-ga on 28 Mar 2005 15:33 PST

Hummer,

For solution #2, it seems to be only for that particular
workbook/file.  I'm looking for something generically for ALL excel
files I open.  Can you help?

Thanks.
Ed

---

Clarification of Answer by hummer-ga on 28 Mar 2005 17:25 PST

Hi Ed,

Problem # 1:

1) View / Click "Full Screen" to see if that is the culprit (click
again to revert back to the way it was).

2) Try this (read also what the webpage says about screen resolution
if you have changed it lately):

Seeing Excel's Program Window:
  "1. Press Alt+Spacebar. This displays the Control menu (even if you
cannot see it).
   2. Press the letter R; the Excel window is restored to its "in between" size.
   3. Press Alt+Spacebar to again display the Control menu.
   4. Press the letter X; the Excel window is maximized.

You might think that the last two steps would revert Excel back to its
oversized condition. Instead, it forces Excel to calculate the correct
size of the desktop and to set the maximum window size accordingly. If
you would rather use the mouse than the keyboard, you can follow these
steps:

   1. Right-click on the Excel task on the task bar. Windows displays
a Context menu.
   2. Choose Restore from the Context menu. The Excel window is
restored to its "in between" size.
   3. Again right-click on the Excel task on the task bar. Windows
again displays a Context menu.
   4. Choose Maximize from the Context menu."
http://exceltips.vitalnews.com/Pages/T0159_Seeing_Excel's_Program_Window.html

I'll have a look at Problem # 2 while you try those out.
hummer

---

Request for Answer Clarification by esarkissian-ga on 28 Mar 2005 18:06 PST

Thanks for the suggestion, Hummer, but once again it applies to the
main Excel page/window rather than the current worksheet.  For
instance, if you just open Excel by itself (Start > Program Files >
Excel) it opens up blank - THIS is the main Excel page that your
solutions refer to.  My problem is when you open an Excel file - the
worksheet window that nests inside the main Excel window is the
problem.

Ed

---

Clarification of Answer by hummer-ga on 28 Mar 2005 18:34 PST

Hi Ed,

Problem # 1:

The problem I am having is you seem to be describing two different
issues. The first is...

"...the top of the workbook with all the menus and such are off the
top of the screen.

...and the second is...

"...I can't see the top of the workbook to click and drag."

The menus are attached to the main page only, that is why I've given
you instructions for the main page. When you can't see the top of the
workbook (title bar), it is as if it has slid under the toolbars of
the main page. Please try to point your cursor arrow to just under the
toolbars and try to move the workbook down. Keep trying over and over
again, each time in a slightly different spot. Even though you can't
see any portion of the red title bar, you should be able to hit it
just right and drag it down. The sweet spot is just a hair above the
top line of the workbook but still under the bottom line of the
toolbar.

hummer

---

Clarification of Answer by hummer-ga on 28 Mar 2005 19:01 PST

Problem # 2:

"How to restore the default workbook window sizing/placement in
excel so when I open it, it either opens maximized or with the window
centered."

Ed, Excel will remember how your workbook was when you last closed it
so that if you close it maximized it will open maximized. Once you
drag it down from under the toolbars, maximize it and then close the
workbook. It should open up maximized. That would be true with all of
your workbooks.

hummer

---

Clarification of Answer by hummer-ga on 28 Mar 2005 19:08 PST

Ed, I'll respond to any further clarifications in the morning, I'm off
to bed. I hope we are making some headway at least!  Goodnight, hummer

---

Request for Answer Clarification by esarkissian-ga on 28 Mar 2005 20:00 PST

Hummer, I'm sorry about the confusion!  Yes you are correct, it has
"slid under the toolbars of the main page."

I've tried pointing the arrow as you suggested for 15 minutes trying
to find the sweet spot between the workbook and toolbar - it's just
not there!  You mention "red title bar"... I assume you're speaking of
Excel 2003 or something, because I have Excel 2000 and it's not red...
dunno, maybe that's the problem? (newer feature or something)

Ed

---

Clarification of Answer by hummer-ga on 29 Mar 2005 04:43 PST

Good morning, Ed,

Yes, Alt + Dash is the one that alluded me last night (thank you,
smokingmonkey!). Pressing Alt + Dash, then the DOWN arrow, then M,
will let you move your workbook around, as I described in my very
first answer. In that case, Alt + Spacebar was for your main page, in
this case Alt + Dash is for your workbook.

Horray! I'm sure we finally have it solved.
hummer
p.s. Sorry for my colour blindness - the title bar is blue, not red
(thank you, dreamboat).

Hummer, thanks for your persistence in solving this!  Special thanks
to Smokingmonkey and Dreamboat as well!

Best,
Ed

Ed: From what I can see, you're still having a problem.

Open the workbook.
Hit Window-->Arrange. (no need to choose)
Hit OK.
NOW, you'll see the top of the worksheet (blue bar, just like the one
at the top of the application window, only this is at the top of your
worksheet and below your toolbars--INSIDE the application window).
Double-click the blue bar. This will place it BACK into the
application window so both your "sets of Exes" (and I'm not talking
about ex-girlfriends) are at the far, top-right of your window again.

Hope it helps!

The comment from 'dreamboat-ga' should work for you, however, to
access the context menu of any nested window inside an application the
correct key combination is "ALT-DASH".   In this case, hitting
ALT-DASH then the letter X should maxmize the current workbook window
in the application, even though it's out of sight.  If the workbook
opens again out of sight the next time you use Excel, use hummer-ga's
first suggestion (involving 'moving' the window), but instead of
ALT-SPACEBAR, use ALT-DASH.  Good luck!

Terrific, Ed, thank you for your kindness. Good group effort. Take care, hummer

You're welcome, Ed!