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
    2017-09-23T16:00:33+00:00

    window for the worksheet is still about halfsize

    can't click on corners to stretch

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-07-06T19:34:23+00:00

    Also, what about new spreadsheet windows that open when downloading content from the web. These windows open all over the place. if I am using two screens, the new windows always opens across both screens. this is very annoying. all I want to do is cut and paste out some of this data and I have to resize the screen every time.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2017-03-20T03:04:10+00:00

    Hi Donald,

    We understand how important it is for you to resolve this issue. To better assist you with your concern, we need the following information:

    • Have you made changes on your device prior to the issue?
    • What is the extension of the file you are having an issue with?
    • Does the issue happen only on an Excel file?

    We will be waiting for your response on this matter.

    Regards.

    Was this answer helpful?

    0 comments