Excel doesn't open window in size last closed

Anonymous
2013-04-03T14:19:47+00:00

In Excel 2007 when I opened a new sheet it opened in a window that was the same size and in same position as the last window I closed. In Excel 2013 every time each new sheet is opened in a small window positioned in the lower left quadrant. I open multiple windows a day and having to resize each one is very time consuming.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2013-04-04T05:54:22+00:00

Hello Mike,

Welcome to Microsoft Community and thank you for posting the question.

Excel usually remembers the size and the position of the last opened Excel file.

Let’s re-size the Excel window and verify the result

  1. Open Excel and click on restore button which appears upper right corner of the screen between x(close) and _ (minimize) buttons.
  2. Now drag the double ended arrow which appears in the corner and re-size accordingly.
  3. You may also move it by dragging it by the title bar, now close and re-open Excel and verify the result.

Hope it helps. Reply with the result for further assistance.

Thank You.

Was this answer helpful?

100+ people found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2014-06-08T01:29:20+00:00

I just switched to MS Office 2013 (forced to because of a new work laptop that had MS Office 2013 installed).

I had this issue (Excel file opening in a half window) with some, but not all of my existing files.

I was able to fix this for all of my windows that opened in a "half window", by clicking on "New Window" in the "View" tab, and then saving the workbook.    When I re-opened, the issue was gone.  I have no idea why this works, and it seems counter-intuitive to click "New Window" to get an existing window out of a "half-window" display.  All I know is that it fixed my problem files (about a dozen).  I hope this works for others as well.

Was this answer helpful?

100+ people found this answer helpful.
0 comments

69 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2014-05-13T00:57:32+00:00

    Hello Martin,

    I know how this concerns you and will assist you to resolve this issue.

    I'd like to ask a question before we proceed:

    Does this issue with other Office applications as well?

    Let's start Excel in safe mode following instructions mentioned below and verify whether issue re-occurs:

    * Hold Windows key + R.

    * Copy and paste, or type the following command in the Open box, and then press Enter

    Excel /safe

    Note: * There is a space between Excel and '/'. * Add-ins will be disabled in Excel safe mode.

    If Excel works as expected in safe mode, disable the add-ins by following steps mentioned below and determine the problem causing add-in:

    a) Click on File menu, click Options, Add-ins, Go button besides Manage: Com-in Add.

    b) Check if there are add-ins listed, clear the checkbox.

    c) Close the Office program and restart it.

    d) Disable each add-in one at a time, restart the Excel, and repeat the above procedure. If the issue reappears again, it will help you to determine which add-in is causing this issue.

    Reply with necessary information and the result for help you further.

    Thank you.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2014-05-12T23:01:34+00:00

    Same problem here.  I read the thread and it's clear that the MS people who answer these are looking for expected behaviour from their apps.  If that was the case they should just refer people to the manual.  These are programming glitches that no one at MS wants to admit.   FIX IT AND STOP FOBBING US OFF WITH BS RESPONSES OR NONE AT ALL!!!!!

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  3. Anonymous
    2014-05-07T09:00:09+00:00

    It doesn't work when you opened more than one excel window. The first window is opened well on the same position as leaved, but the second is opened always cca 40px below. It is similar as cascade opening in Windows 3.1. This is unpleasant because I am used to close window by clicking to the close button in the most righ-up corner on the screen. I always close the unwanted window.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments