Excel 2016 viewing multiple sheets without Excel headings

[DougP]

In prior versions of Excel you could see multiple sheets without the entire program, its using the Windows OS Show side by side. Is the anyway to show just the Excel sheets in one Excel program? like the old days. It wastes so much screen real-estate it is completely worthless, even hiding the ribbon does not reduce it enough. This is in Windows 7 so maybe that's why it does not work like it used to?

DougP

 

[SkipVought]

HI,

Could you post a screen shot?

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[xwb]

Do you mean opening multiple sheets from the same book or sheets from different books?

 

[DougP]

Skip, here are two screen captures, one is 2010 > Excel_2010_1_program.JPG: the other is 2016 >Excel_2016_2_programs.JPG.
clicking the "View" menu then "New Window" then "Arrange all" does two different things in the two versions as shown in the screen captures.

Xwb, two sheets in the same workbook. So now the question is: in 2016 did doing want I want to do get moved to some other place in the menu and called something different or is this the way it is now.

http://files.engineering.com/getfil...4-31cb1893b331&file=Excel_2016_2_programs.JPG

http://files.engineering.com/getfil...4d-9e7faf6ac81f&file=Excel_2010_1_program.JPG

I guess you can't attach two images to a post so I had to paste the URL's in the post.

DougP

 

[SkipVought]

If you double-click any tab in the ribbon it will TOGGLE between the states of Opened and Collapsed.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[DougP]

I mentioned that at the top, it's not the same. it still wasted valuable screen space. AND... then you have to do more actions to view a less than ideal solution.

DougP

 

[SkipVought]

WYSIWYG

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[combo]

Nope. Upgrade enhancement:

https://msdn.microsoft.com/en-us/library/office/dn251093.aspx

combo