Home

Excel Splitting 2 workbooks horizontally

%3CLINGO-SUB%20id%3D%22lingo-sub-455292%22%20slang%3D%22en-US%22%3EExcel%20Splitting%202%20workbooks%20horizontally%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-455292%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20view%20two%20different%20Excel%20workbooks%20horizontally%2C%20but%20for%20some%20odd%20reason%20I%20am%20not%20able%20to.%26nbsp%3B%3C%2FP%3E%3CP%3EBoth%20workbooks%20split%2C%20but%20I%20cant%20not%20view%20them%20at%20the%20same%20time.%20I%20have%20tried%20closing%20both%20workbooks%2C%20and%20reopen%20them%20and%20follow%20the%20same%20step%2C%20but%20it%20is%20not%20working.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%20or%20assit%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-455292%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-455712%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Splitting%202%20workbooks%20horizontally%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-455712%22%20slang%3D%22en-US%22%3EWhat%20menu%20option%20did%20you%20use%20or%20which%20mouse%20or%20keyboard%20action%20did%20you%20use%20please%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826458%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Splitting%202%20workbooks%20horizontally%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826458%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20same%20problem.%20I%20looked%20up%20what%20to%20do%20in%20the%20help%20section%2C%20but%20when%20I%20follow%20the%20steps%20I%20still%20don't%20get%20to%20view%20both%20screens%20in%20one%20view.%20Furthermore%20I%20also%20can't%20minimize%20the%20excel%20screens.%20Maybe%20that%20has%20something%20to%20do%20with%20it%3F%20Maybe%20it's%20a%20general%20setting%20instead%20of%20an%20excel%20setting%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20someone%20can%20help.%20It%20takes%20a%20lot%20of%20time%20when%20you%20have%20to%20compare%202%20documents%20like%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3EAnnemarie%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826464%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Splitting%202%20workbooks%20horizontally%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826464%22%20slang%3D%22en-US%22%3EWhat%20happens%20if%20you%20activate%20either%20window%20and%20then%20hit%20this%20key%20combination%3A%20Windows%20key%20%2B%20Left%20(or%20Right)%20arrow%20key%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826469%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Splitting%202%20workbooks%20horizontally%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826469%22%20slang%3D%22en-US%22%3E%3CP%3EUnfortunately%20nothing%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826478%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Splitting%202%20workbooks%20horizontally%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826478%22%20slang%3D%22en-US%22%3EPerhaps%20the%20workbook%20is%20protected%20using%20Excel%202010%20or%20older%20with%20the%20Windows%20option%20checked.%20This%20protection%20disables%20changing%20the%20size%20of%20the%20workbook%20windows.%20In%20older%20incarnations%20of%20Excel%202016%2C%20this%20protection%20cannot%20be%20undone.%20In%20the%20more%20recent%20builds%20of%20Office%20365%20this%20type%20of%20protection%20is%20ignored%20and%20windows%20can%20be%20resized.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826495%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Splitting%202%20workbooks%20horizontally%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826495%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20copying%20the%20content%20to%20a%20new%20document%20using%20my%20current%20version%20of%20Excel%202016%2C%20and%20tried%20to%20resize%20the%20window%20after%2C%20but%20still%20no%20luck%E2%80%A6.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826532%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Splitting%202%20workbooks%20horizontally%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826532%22%20slang%3D%22en-US%22%3EIf%20you%20start%20Excel%20in%20safe%20mode%20(press%20and%20hold%20control%20key%20while%20you%20launch%20Excel)%2C%20does%20it%20work%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-833511%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Splitting%202%20workbooks%20horizontally%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-833511%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20suggestions.%20Turns%20out%20I%20had%202%20versions%20of%20Office%20365%20on%20my%20computer%2C%20which%20caused%20it%20to%20malfunction.%20Their%20helpdesk%20finally%20fixed%20it%20for%20me.%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-834112%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Splitting%202%20workbooks%20horizontally%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-834112%22%20slang%3D%22en-US%22%3EExcellent!%20Glad%20you%20got%20it%20fixed.%3C%2FLINGO-BODY%3E
allen79
Occasional Visitor

Hello,

 

I am trying to view two different Excel workbooks horizontally, but for some odd reason I am not able to. 

Both workbooks split, but I cant not view them at the same time. I have tried closing both workbooks, and reopen them and follow the same step, but it is not working.

 

Please help or assit

9 Replies
What menu option did you use or which mouse or keyboard action did you use please?

@Jan Karel Pieterse 

I have the same problem. I looked up what to do in the help section, but when I follow the steps I still don't get to view both screens in one view. Furthermore I also can't minimize the excel screens. Maybe that has something to do with it? Maybe it's a general setting instead of an excel setting?

 

Hope someone can help. It takes a lot of time when you have to compare 2 documents like this.

 

Best regards,

Annemarie

What happens if you activate either window and then hit this key combination: Windows key + Left (or Right) arrow key?

Unfortunately nothing

 

Perhaps the workbook is protected using Excel 2010 or older with the Windows option checked. This protection disables changing the size of the workbook windows. In older incarnations of Excel 2016, this protection cannot be undone. In the more recent builds of Office 365 this type of protection is ignored and windows can be resized.

@Jan Karel Pieterse 

I tried copying the content to a new document using my current version of Excel 2016, and tried to resize the window after, but still no luck….

If you start Excel in safe mode (press and hold control key while you launch Excel), does it work?

@Jan Karel Pieterse 

Thanks for your suggestions. Turns out I had 2 versions of Office 365 on my computer, which caused it to malfunction. Their helpdesk finally fixed it for me.

Excellent! Glad you got it fixed.
Related Conversations