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: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2015-03-26T23:32:10+00:00

    I do all that and it still doesn't open where I want.  It seems that ALL half screens want to open or shrink to exactly the same place.  I have a couple hundred spreadsheets I work on, many at the same time every day and I want them all in precise locations without having to KEEP changing them.

    Also, I can't seem to pull one spreadsheet out of a workbook and drop it just on the desktop.  I have to do 2 steps to open anew blank workbook and pull it into it.  Ugh.

    and how about correcting all workbooks with a 1904 calculation system as they change if I pull them into a new workbook.

    Hate this wonderful upgrade!!!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2015-03-26T23:44:58+00:00

    me too!  I don't have time for this.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2015-07-27T12:37:22+00:00

    I found this thread while seeking answers to a similar situation.  As a project manager, I manage 20+ projects daily and I have the need to copy data from a time report spreadsheet into a master time report for each of my projects.  Since I like to be as efficient as possible, I would like my Excel windows to be as wide as the screen and approximately half the height so I can easily locate data and copy it.

    Rather than trying to get Excel to "remember" the size of an Excel instance as discussed in this email thread, I found this simple macro which automatically resizes the window to a specific dimension.  By assigning the macro a hot key, within a single keystroke, i.e. one second, I've got my Excel windows set to the correct size and I can move them into the correct position very easily.  

    One could take my simple macro and get more creative if desired.  For example, if you work with 3 spreadsheets consistently, one could create three macros to resize each spreadsheet to your desired placement.  Anyways, listed below is my VBA code which I found from Allen Wyatt's Excel Tips.  If you need assistance in creating Macros, please search for instructions.  The purpose of my post is to give other folks an idea of a different approach to the problem which was very successful for me.  

    Sub SetWindowSize1()

        Application.WindowState = xlNormal

        Application.Top = 3

        Application.Left = 3

        Application.Width = 1430

        Application.Height = 370

    End Sub

    Was this answer helpful?

    0 comments