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.

Excellent! Glad you got it fixed.
Related Conversations
Version 2001 Excel 365 and no Dynamic Arrays
MilesWilliams in Excel on
5 Replies
$ symbol changes format of cells automatically
gbetar01 in Excel on
2 Replies
Excel table formatting best practices question
Jerry1385 in Excel on
2 Replies
If/Then Formula Not Drawing Across Sheets
Matt010614 in Excel on
2 Replies
FREQUENCY
enaugle in Excel on
3 Replies
how to calculate sum of the previous months by company
gorandimeski in Excel on
1 Replies