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

2015-10-29T14:46:07+00:00

This method keeps the file the size I want, but now I have 2 copies of the file open on my desktop. How is this possible?
Was this answer helpful?

0 comments No comments
Anonymous

2015-10-29T14:42:50+00:00

These steps did not solve the issue. The file remains shrunk to just the title bar.
Was this answer helpful?

0 comments No comments
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 No comments