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
Highlighted
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
Highlighted
What menu option did you use or which mouse or keyboard action did you use please?
Highlighted

@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

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

Unfortunately nothing

 

Highlighted
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.
Highlighted

@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….

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

@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.

Highlighted
Excellent! Glad you got it fixed.
Related Conversations
Can anyone make this dependent?
novakdz in Excel on
6 Replies
'If' statement help needed
Ollie1785 in Excel on
3 Replies
additionner grille de commande
Gaetan205 in Excel on
0 Replies
calculate points for irregular dates
chaehyun in Excel on
5 Replies