• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Automatically Resizing Windows

I'm not even sure if I'm describing this right because I've never been able to find a solution.

Ever since I got Excel 2013, which opens each spreadsheet in a new window, any subsequent spreadsheet that I open is not positioned the same way as the original spreadsheet that was opened. Meaning the second spreadsheet will be further down from the top by an inch, and then the next one, down an inch from that (and when they move down too low, they move below the taskbar and I can't get to the tabs). Or alternatively, the spreadsheet will open on my second monitor. I choose to have Excel span both monitors instead of displaying on only one monitor, so when it opens on the second monitor, it still opens at the width of two monitors and I can't see the status bar at the bottom right to see if something is calculating. So I am constantly moving the spreadsheets to fill the same space. Also, sometimes due to inactivity, my spreadsheets will shrink to the size of one monitor instead of maintaining the size of two monitors.

Our IT guy did write me a script and assign a shortcut that will position any window (not limited to Excel) to the size of both monitors - so it does help when I need to resize them, but I wanted to see if anyone else had this issue and see if there were any other options for fixing that.

Sorry for the long email - I hope that all made sense.
 
This issue isn't Excel issue. However, it's Windows issue. Unfortunately, there isn't native control within Windows to allow, new window to open at exact position of previous window. Likely this is intentional, for ease of repositioning windows.

Workaround is as your IT did, through script (for an example, window.open method in Java Script, etc).
 
Back
Top