Viewing multiple sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-2892364%22%20slang%3D%22en-US%22%3EViewing%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2892364%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20issues%20formatting%20the%20view%20%26gt%3B%20arrange%20all%20function%20in%20Excel.%20My%20organization%20just%20upgraded%20from%20Office%202010%20so%20this%20is%20all%20new%20to%20me.%20When%20utilizing%20view%20%26gt%3B%20arrange%20all%20in%202010%2C%20it%20would%20allow%20for%20multiple%20sheets%20to%20be%20viewed%20at%20once.%20Now%20in%20the%20new%20version%20we%20have%20moved%20to%2C%20the%20top%20part%20of%20the%20window%20takes%20up%20the%20whole%20screen.%20See%20attached%20screenshot.%20Is%20there%20any%20way%20to%20view%20the%20data%20on%20all%204%20sheets%20at%20one%20time%20like%20in%20the%20previous%20excel%20versions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2892364%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2905322%22%20slang%3D%22en-US%22%3ERe%3A%20Viewing%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2905322%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3Ethere%20is%20no%20functionality%20in%20the%20new%20office%20versions%20to%20get%20the%20same%20view%20as%20in%202010.%20You%20can%20get%20only%20some%20additional%20space%20in%20the%20separate%20windows%20if%20you%20collapse%2Fminimize%20the%20ribbon%20where%20you%20do%20not%20need%20them%3A%3CBR%20%2F%3EClick%20on%20the%20little%20up-arrow-symbol%20on%20the%20far%20right%20corner%20of%20the%20ribbon%20(or%20hit%20Ctrl%2BF1)%3CBR%20%2F%3E%3CBR%20%2F%3EKind%20regards%2C%3CBR%20%2F%3EMartin%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

 

I am having issues formatting the view > arrange all function in Excel. My organization just upgraded from Office 2010 so this is all new to me. When utilizing view > arrange all in 2010, it would allow for multiple sheets to be viewed at once. Now in the new version we have moved to, the top part of the window takes up the whole screen. See attached screenshot. Is there any way to view the data on all 4 sheets at one time like in the previous excel versions?

2 Replies
Hi,

there is no functionality in the new office versions to get the same view as in 2010. You can get only some additional space in the separate windows if you collapse/minimize the ribbon where you do not need them:
Click on the little up-arrow-symbol on the far right corner of the ribbon (or hit Ctrl+F1)

Kind regards,
Martin

@JonahMcMasters 

In addition, with Office 365 Microsoft shifted from Multiple Display Interface as it was before to Single Display Interface. That is fundamental change and such behavior can't be changed by settings. SDI is not always suitable, but we have what we have.