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
    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
  2. Anonymous
    2017-03-19T14:20:28+00:00

    I have Excel version 15.32 on my Mac and when I open a file there are no x(close) and _(minimize) buttons on either the Excel menu bar or the file menu bar. In the upper right corner I have a smile face, "Help improve Office?" button with a "Share this workbook" button below it with a "Collapse ribbon" button to the right.

    Can you help as I can't get past #1 of your "fix"?

    Thanks, Don

    Was this answer helpful?

    0 comments
  3. Anonymous
    2017-02-17T15:39:30+00:00

    Do you have instructions for how to fix this on a Mac?

    Was this answer helpful?

    0 comments