A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
I couldn't get it to work when holding Ctrl when closing - BUT, I did try this and it worked: hold down Ctrl key when maximizing. Good luck!
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Tried setting the starup icon properties to start maximised. Tried setting registry entry HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options\Maximized to 0x00000003
All to no avail. I've sen the prob reported on lots fo other forums but it's always the solutions noted aboive that are suggested, and jsut as reported on those forums, they don't resolve the issue with Excel 2010.
sh
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
I couldn't get it to work when holding Ctrl when closing - BUT, I did try this and it worked: hold down Ctrl key when maximizing. Good luck!
Set HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options\Maximized to 0x00000000. It worked for me. It worked after I reset the Registry Key till I Shut Down my computer. When I restarted it, the registry entry changed back to "0x00000003" and Excel opened Minimized.
I have found that whenever I opened an excel file, it never opened maximised no matter which method I chose to close it.
So I went to the excel program shortcut on the start menu and changed the Normal window setting to Maximised. Now all my excel files open maximised.
It seems program shortcuts and file shortcuts behave differently. I haven't figured this out yet, but I have got what I wanted.
It works! Thanks!
Here's my weird scenario. I have 2 PCs on my desk at work. They both load the same exact personal file (which is an Excel 97-style add-in). It is password protected (not sure if that matters), and since it's an add-in, I can't actually show the file in Excel (maybe possible, but I don't know how). On my main desktop PC, Excel opens maximized all the time. On my secondary PC, which is a laptop, Excel NEVER opens up maximized. Excel will remember the window placement if I move it, but not if I just maximize it. And it does not auto-maximize if I make the window as big as the screen. So as an add-on question to the OP's question, why would my 2 PCs behave differently in this case?