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 No 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 No 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 No comments

69 additional answers

Sort by: Oldest
  1. Anonymous
    2014-09-20T13:53:27+00:00

    UPDATE**  I found that if I opened additional spreadsheets from within the Excel application they opened at the same size I closed them.  It's only when I open additional spreadsheets directly from a folder that the spreadsheets open at the small size.  Is this a glitch?

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2014-09-23T21:17:21+00:00

    I tried this fix, eagerly -- it appeared to be a small glimmer of hope.

    Sometimes it seemed to work, other times not.  I could not predict the outcome.

    In one instance, the newly opened SS did in fact open to its previously closed size,

    BUT

    the other SS, already opened, simultaneously changed itself to the same size as the new SS !!!!

    Not to mention, of course, that the dialogue box that opens with the FILE command, ALSO opens as a square, meaning that you cannot see all three columns of information without the nuisance of scrolling, or maximizing, at which point the kb shortcuts disappear.

    There is no winning with this thing.  Why did they not leave well-enough alone?

    Compared to earlier versions, this thing seems to have been created by interns who dropped in over the summer, and certainly not by anyone who actually USES Excel to do real work.

    Piece of junk.  Microsoft should be embarrassed by what they have done here.  The shark has been jumped.  It's downhill for them.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2014-10-03T14:04:35+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.

    I've only ever found one way that works forever to fix this.  So my Excel like everyone's opens in a half window at the top of my monitor viewing area.  I can try to expand the size, but once i get near bottom of monitor 'screen', if you pay close attention you'll see it sort of auto 'fills' to the very top/bottom lines of monitor screen.  You can do whatever you want at that point and it ain't gonna reopen in the desired size, the damage is done.

    So for example, I like my Excel to be top-to-bottom but about 1/3 of monitor width real estate.  So first I open any Excel file to the stupid half window.  Then I resize it to maybe 3/4 of the length of the screen up/down.  Now Stop!  Now hold down SHIFT and use the File - Save - Exit commands to close it.

    Reopen it.  It should now be in that 3/4 size.  Now resize to the final limit you want.  Make sure to be real careful if/once you get it near bottom so it does not 'auto-fill' (you'll see it maybe slightly resize/shudder a bit if it's doing it).  I'd recommend going with like 95% top-to-bottom size to avoid that, but it can be done to full with a steady hand.  

    It's a stupid thing to have to do to an expensive piece of software for something so simple, but that's the ONLY way i've ever found to fix it permanently.

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments No comments