Home | Site Map | Cisco How ToNet How To | Wireless |Search | Forums | Services | Donations | Careers | About Us | Contact Us|

Excel doesn't open window in size last closed

Network Sharing , TCP/IP, Internet, Wireless, Exchange, IIS, ISA and Print

Excel doesn't open window in size last closed

Postby chicagotech » Wed Apr 26, 2017 12:23 pm

In my old Excel whenever 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 2016 every time each new sheet is opened in a small window positioned in the lower left quadrant. Even I have enlarged the Excel window, but it open small size next time when I open the Excel. How to fix it?
Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on http://www.HowToNetworking.com
chicagotech
Site Admin
 
Posts: 6753
Joined: Mon Nov 27, 2006 1:24 pm
Location: Chicago USA

Re: Excel doesn't open window in size last closed

Postby chicagotech » Wed Apr 26, 2017 12:23 pm

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.
Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on http://www.HowToNetworking.com
chicagotech
Site Admin
 
Posts: 6753
Joined: Mon Nov 27, 2006 1:24 pm
Location: Chicago USA

Re: Excel doesn't open window in size last closed

Postby chicagotech » Wed Apr 26, 2017 12:24 pm

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.
Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on http://www.HowToNetworking.com
chicagotech
Site Admin
 
Posts: 6753
Joined: Mon Nov 27, 2006 1:24 pm
Location: Chicago USA


Return to Networking

Your Ad Here

Who is online

Users browsing this forum: No registered users and 5 guests