There are many times when you need to compare two workbooks in Excel. Hemm ħafna drabi meta għandek bżonn biex tqabbel żewġ kotba fl-Excel. Flipping back and forth between the two is a major pain. Flipping quddiem u lura bejn it-tnejn huwa uġigħ kbir. Here is how to view two workbooks side-by-side in Excel 2007. Hawnhekk huwa kif fehma żewġ kotba ġenb ma 'ġenb fl-Excel 2007.
- Open the two workbooks you want to compare Iftaħ il-kotba żewġ inti tixtieq li tqabbel
- Click on the View tab at the top of the page Ikklikkja fuq il-tab View fil-quċċata tal-paġna
- On the Window group under the View tab click the View Side by Side button. Fuq il-grupp Tieqa taħt il-tab View ikklikkja l-ġenb Ara billi buttuna ġenb. If you only have two workbooks open, Excel will automatically choose these two workbooks. Jekk inti biss għandek żewġ kotba miftuħa, Excel awtomatikament se jagħżlu dawn kotba tnejn. If you have more than two workbooks open, a dialog box will open so that you can choose which two workbooks to compare. Jekk għandek aktar minn żewġ kotba miftuħa, kaxxa dialog se tiftaħ sabiex inti tista 'tagħżel li żewġ kotba li jqabblu.
Side by Side button Side mill Side buttuna
From here you have some more options: Minn hawn għandek għażliet ftit aktar:
You can click Arrange All to view the two workbooks horizontally or vertically. Tista 'tikklikkja Irranġa kollha biex tara l-kotba żewġ b'mod orizzontali jew vertikali.
Arrange All button Tirranġa All buttuna
You can also turn Synchronous Scrolling on or off. Tista 'wkoll dawran Scrolling Synchronous fuq jew barra.
Synchronous Scrolling button Buttuna Synchronous Scrolling
