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

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
Automatic Selling price calculator
nic140274 in Excel on
2 Replies
Search fuction
Alvaro1990 in Excel on
1 Replies
UNIQUE, FILTER function no more available
Fabien_M in Excel on
7 Replies
Pulling specific data from multiple worksheets into one
AmberDDowney in Excel on
1 Replies
Excel
Svein Tore Kristensen in Excel on
1 Replies