Excel won't open maximized

My issue was similar:

* Date: December 2017

* Excel 2016

* The first spreadsheet opens in a maximized window

* Every next spreadsheet opens almost maximized, but

   - the top edge of the spreadsheet was ~2 cm below the upper edge of the screen;

   - the bottom edge of the spreadsheet was aligned with the bottom edge of the screen, RATHER THAN THE TASKBAR as it should be!

   - The 2 sides (right and left) were aligned with the edges of the screen (ok).

* This was frustrating as **** (had to maximize every spreadsheet that I open before using it).

Solution that worked for me:

* It seems to have been linked to the Taskbar (wrong alignment of the bottom spreadsheet border suggested that).

* I checked Taskbar (right mouse click): "Lock Taskbar" was off, i.e. I could manually change its width.

* I changed Taskbar width to the max making it take up about 40% of my screen.

* Opened the Excel spreadsheet - this time it opened better. Its bottom edge was finally aligned with the Taskbar (and was NOT aligned with the bottom edge of the screen, sort of extending behind the taskbar all the way down).

* Closed Excel (maybe I saved it, maybe not, can't remember now).

* Resized Taskbar again, back to the standard 1-row Taskbar.

* Opened the Excel spreadsheet again - and voila!

It was finally maximized, just like every other spreadsheet that I open in addition to it.

You are welcome.

zheka160,

Thanks for your help. But it did not work on a password protected Excel document.

Tim

Grasping at straws here since I don't have 2010, but one thing that works in some applications is to:

• open,
• maximize,
• then hold the Shift key down while clicking the close button.

Works (usually) for IE (XP and Vista), and has worked for XL2007 on Vista for me

Worked for me in Windows 10, Office 365

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.