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: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-03-26T19:39:06+00:00

    Try moving the bottom border slightly and see if the rest of the window doesn't fill in.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-03-26T16:12:36+00:00

    For me, it has nothing to do with the size of the window when I saved and closed it. It always opens full width, half length.  See below: 

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-02-19T02:55:02+00:00

    I believe the issue is saving each excel file with the window size it had when closed.  If you open a different excel file with a different window size and then close that file, the previous file will only open in the latest saved excel window size.  I would prefer the window size to be saved with each individual file when closed and not applied to other files that may be opened next or later.  Is that possible?

    By-the-way if you have several excel windows open and click the view, new, then save all the excel work, does that save all the different window sizes for each individual file?  Please note that this is a different issue than that mentioned above.

    Is this supposed to be an answer?

    I have read it a dozen times, and I do not see a useful answer.

    To answer the secondary question about "a different issue":  NO.

    This whole thing is so bizarre. Microsoft answers seem to forget that this was not a problem in earlier versions of Office, and was introduced only with the current Office.  It seems that the current office has been developed by people so young that they have no memory of when Office used to be efficient, and not burdened by nonsense.

    Was this answer helpful?

    0 comments