Excel doesn't open window in size last closed

Anonymous

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.

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

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

Open Excel and click on restore button which appears upper right corner of the screen between x(close) and _ (minimize) buttons.
Now drag the double ended arrow which appears in the corner and re-size accordingly.
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.

0 comments

Answer accepted by question author

Anonymous

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.

0 comments

69 additional answers

Anonymous

2014-11-18T15:06:50+00:00
To disable the annoying SNAP feature in Windows 7:
1. Open Control Panel
2. Select "Ease of Access Center"
3. Select "Make Mouse Easier to Use"
4. Check box "Prevent Windows from being automatically arranged..."
This turns off the SNAP function for all Windows applications, including Internet Explorer. Windows will reopen in the size last saved.

Rgds,

Jeff
Was this answer helpful?

4 people found this answer helpful.

0 comments No comments
Anonymous

2014-05-12T23:01:34+00:00

Same problem here. I read the thread and it's clear that the MS people who answer these are looking for expected behaviour from their apps. If that was the case they should just refer people to the manual. These are programming glitches that no one at MS wants to admit. FIX IT AND STOP FOBBING US OFF WITH BS RESPONSES OR NONE AT ALL!!!!!
Was this answer helpful?

3 people found this answer helpful.

0 comments No comments
Anonymous

2013-04-04T12:55:30+00:00

I am amazed as I thought I had tried the same steps many times and it didn't work. But, it appears to be working now. Thank you.

Just one other item. A minor one is that each new window that opens is offset a bit from the prior window. I guess this is done so you can see the title bars of each of the lets say 5 windows. But the fact is that if you focus on the first one opened it will overlay the title of the others. In my case I depend on the task bar to change focus and having the windows open offset to the right means they take over more screen space so I have to move them all to the left (I work in half-screen mode most of the time on sheets so I can watch another program that operates in real-time). Even after I've moved 5 sheets to the left when I open the 6th one Excel remembers where the 5th was positioned and places the new 6th one to the right of that. Annoying. I'd like all sheets to open left aligned.
Was this answer helpful?

3 people found this answer helpful.

0 comments No comments