Grouping excel worksheets windows in Excel 2010 way

%3CLINGO-SUB%20id%3D%22lingo-sub-1604136%22%20slang%3D%22en-US%22%3EGrouping%20excel%20worksheets%20windows%20in%20Excel%202010%20way%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604136%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20an%20Excel%202010%20workbook%20with%20worksheets%2C%20each%20worksheet%20was%20opened%20in%20a%20separated%20windows%2C%20which%20was%20then%20resized%2C%20positioned%20within%20the%20workbook%2C%20then%20saved.%20So%20that%20when%20the%20workbook%20is%20open%2C%20all%20the%20positions%20of%20the%20sheets'%20window%20are%20in%20the%20right%20place%20and%20right%20size%20(including%20sheet%20zooming)%2C%20so%20that%20gives%20a%20whole%20view%20of%20multiple%20worksheets%20in%20the%20wished%20size.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20with%20new%20version%20of%20Excel%2C%20this%20seems%20no%20more%20possible.%20Each%20time%20the%20workbook%20is%20open%2C%20the%20window%20sheets%20are%20effectively%20open%2C%20but%20with%20a%20standard%20size%20and%20in%20cascade%20mode%2C%20all%20resizing%20and%20position%20are%20lost%2C%20so%20no%20more%20wished%20%22view%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20a%20solution%20for%20that%3F%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3CP%3EDiDi%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1605845%22%20slang%3D%22en-US%22%3ERe%3A%20Grouping%20excel%20worksheets%20windows%20in%20Excel%202010%20way%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1605845%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767128%22%20target%3D%22_blank%22%3E%40David575%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20is%20so%20called%20Multi-Dimensional%20Interface%20(MDI)%20which%20is%20not%20available%20in%20recent%20versions%20of%20Excel.%20You%20may%20vote%20for%20returning%20it%20back%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F11706627-restore-mdi-file-handling-open-all-files-in-one-w%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F11706627-restore-mdi-file-handling-open-all-files-in-one-w%3C%2FA%3E%26nbsp%3Band%20check%20comments%20for%20more%20details.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi all,

 

For an Excel 2010 workbook with worksheets, each worksheet was opened in a separated windows, which was then resized, positioned within the workbook, then saved. So that when the workbook is open, all the positions of the sheets' window are in the right place and right size (including sheet zooming), so that gives a whole view of multiple worksheets in the wished size.

 

Now with new version of Excel, this seems no more possible. Each time the workbook is open, the window sheets are effectively open, but with a standard size and in cascade mode, all resizing and position are lost, so no more wished "view".

 

Does anyone have a solution for that?

Many thanks

DiDi

1 Reply
Highlighted

@David575 

That is so called Multi-Dimensional Interface (MDI) which is not available in recent versions of Excel. You may vote for returning it back here https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/11706627... and check comments for more details.