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: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-07-04T11:32:53+00:00

    Adapting Marc's code a bit further, this works for me:

    1. Use the below code to create an XLA (Excel add-in) somewhere on your PC;
    2. Edit the code according to your visual preferences; and
    3. Enable it like any other Excel add-in.

    It will allow you to set an application level keyboard shortcut that resizes the current Excel workbook to a position you want.

    The code:

    For “This Workbook” VBA Workbook Object

    Private Sub Workbook_Open()

    With Application

    .OnKey Key:="^+%R", Procedure:="mWindow_Resize"

    End With

    End Sub

    In normal speak: runs on open and creates a shortcut that runs the procedure “mWindow_Resize” (below) when “Ctrl-Shift-Alt-R” are pressed.

    Module – “mod_Window_Resize”

    Sub mWindow_Resize()

        Application.WindowState = xlNormal

        Application.Top = 0

        Application.Left = 960

        Application.Width = 1920

        Application.Height = 768

    End Sub

    In normal speak: for my setup (three monitors at 1280x1024) this sets Excel to fill the two right most monitors leaving the left one clear.  Note, numbers are in points not pixels.

    Hope it helps.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2013-11-27T20:02:32+00:00

    Dan,

    I replied some time ago and provided you a screen shot but have never heard back. I still have the problem as it appears many other do. So let's try to state this problem simply.

    I am running Excel 2013 on Windows 7. When I open a sheet I want it to open the same size I saved it as. It doesn't. It opens offset from the left and top and it opens smaller. No matter how I resize it and move it the next sheet I open does the same thing. When I shut down and restart Excel remembers nothing.

    Why? How do I fix this?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2013-08-02T14:15:11+00:00

    Hi,

    Thank you for choosing Microsoft Office Community.

    There is no *.ini file which saves the last opened window setting.

    I would require additional information for better assistance:

    1. Are you experiencing this issue in other Office/non-Office applications (Notepad or Internet Explorer)?
    2. Did you perform any customization in Excel?

    Let's delete files from the following locations and verify the result:

    Program Files\Microsoft Office 15\Root\Templates

    Users\user_name\Appdata\Roaming\Microsoft\Templates

    Program Files\Microsoft Office 15\Root\Office15\XLSTART

    Users\user_name\Appdata\Roaming\Microsoft\Excel\XLSTART

    Program Files\Microsoft Office 15\Root\Office15\STARTUP

    Note: If you're not able to find file in any of the folders, you may proceed with the next folder. Enable show hidden folders to view the App data folder.

    http://windows.microsoft.com/en-US/windows7/Show-hidden-filesReply with necessary information and the result for further assistance.

    Thank You.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments