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

2013-08-04T18:46:05+00:00

Daniel,

Here's a screenshot. If I were to have it now open a saved sheet it too would open the same size. I have to drag the sheet to the left pane to get it to open full height and half screen.

Mike
Was this answer helpful?

0 comments No comments
Anonymous

2013-11-04T16:23:58+00:00

Hi Daniel -

I have an Excel sheet open, and any other Excel sheet I open in addition to the original one re-sizes the window to be the same as the original. How can I save a document to be the size I re-size it to before closing, so that when I open it I can see all the data in that particular sheet rather than being the same size as any other open sheets or the most recent sheet I had open? When I re-size my sheets, the size is specific to the data in each; it's not "one size fits all."

Thanks,

Jessica
Was this answer helpful?

4 people found this answer helpful.

0 comments No comments
Anonymous

2013-11-27T19:44:41+00:00

I thought that Excel was not remembering the size of the window. I like to have the windows at full screen height and half (or variable) width. I think Windows treats this as a form of "Maximize" and doesn't remember it. Excel was opening at whatever arbitrary size of the window before I dragged it to full height. When I carefully sized the window to be as close to full height as possible without actually being full height, that solved the problem. HOWEVER, the offset behavior is driving me crazy. At nearly full height, when the next window opens, with the offset, it puts the worksheet tabs below my taskbar. I am obliged to either drag the Excel window up or resize it each and every time in order to access the worksheet tabs. Is there anyway to turn off the offset? I just want my windows to open in the same location and the same size each and every time.
Was this answer helpful?

4 people found this answer helpful.

0 comments No comments