Excel 2016 Files Always Open Full Screen/Maximized

Question

Every time I open a file in Excel (for Mac), the file opens maximised. On my 27" this is rarely what I want. I've scoured the web to find a solution, to no avail. 

When I create a new file, the window is a reasonable side (about 60% of my screen). When I save this file and reopen it, it fills the entire screen. In other words, Excel does not remember the window size at all. 

Please help!

Answer 1

Okay When first open an Excel you roughly see this view

Shows at the top left of the screen this is 100%. Most People resize and shift the position on the screen and save this view, so it close to be centered on the screen.

To set this Position, you option Click on the Green stop light button This will expand or contract to previous position and size, Repeat. Doing this set as default size and position for this document.

Now Save document with the correct name (even if you haven't filled out anything in sheet yet). From now on everytime you open the document and option click the green button will return to your preset.  (Notice the + sign in the green button.)

Any Modern Mac OS there is a setting called full which expand the item to fill up the entire screen. To get to it simply click on the green button. The Buttons look like this when you hover over then without holding the option key down:

Notice the two arrows at 45º angle. In this mode, even the menubar is hidden and only shows if you move the mouse to the top of the screen.

NOTE: if you set up the document and save that document, it will always open to that size and position. Occasionally it will revert to covering 1/3 the top left of the screen just click on option Green button will shift back in righ size and position.

Opening a new blank document will always show 1/3 of the top left of the screen.

Hope this helps. 

_________

Disclaimer:

The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone and do not reflect upon my position as a Community Moderator.

Answer 2

Yay! Never knew about the option-green button, and certainly wasn't aware that this would permanently set the default size. Must be an "unadvertised feature" :-)

Thanks so much, you're a savior!

Answer 3

All excel files started opening full screen for me a few weeks ago. New files or old ones. I've searched around and tried most of the suggested fixes with no luck.

Just now I discovered a fix (at least for me) by resizing my window as I want it, then twice using the window zoom option from the top mac control bar. The first zoom takes the window to full screen and the second zoom brings it back to resized. After that double zoom the setting was then remembered from then on. I have had to do this once for each workbook, as the affect seems to be local.

I had tried the green zoom bullet but that didn't work. Using "Window" "zoom" twice did it for me, at least for today.

Hope this helps someone else.