This is a translated page. The original can be found here: http://www.thehelptech.com/excel-2007-how-to-view-two-worksheets-side-by-side/

Excel 2007: How to view two worksheets side-by-side Excel 2007: Sådan får du vist to regneark side-by-side

There are many times when you need to compare two workbooks in Excel. Der er mange gange, når du skal sammenligne to projektmapper i Excel. Flipping back and forth between the two is a major pain. Vending frem og tilbage mellem de to er en stor smerte. Here is how to view two workbooks side-by-side in Excel 2007. Her er hvordan man kan se to projektmapper side-by-side i Excel 2007.

  1. Open the two workbooks you want to compare Åbn de to projektmapper du ønsker at sammenligne
  2. Click on the View tab at the top of the page Klik på fanen Vis øverst på siden
  3. On the Window group under the View tab click the View Side by Side button. På gruppen Vindue under fanen Vis skal du klikke på Vis side om side knappen. If you only have two workbooks open, Excel will automatically choose these two workbooks. Hvis du kun har to projektmapper åbne, vil Excel automatisk vælge disse to projektmapper. If you have more than two workbooks open, a dialog box will open so that you can choose which two workbooks to compare. Hvis du har mere end to projektmapper åbne, vil en dialogboks åbnes, så du kan vælge, hvilke to projektmapper at sammenligne.
Side by Side button

Side by Side button Side by Side knappen

From here you have some more options: Herfra har du nogle flere muligheder:

You can click Arrange All to view the two workbooks horizontally or vertically. Du kan klikke på Arranger alle at se de to projektmapper vandret eller lodret.

Arrange All button

Arrange All button Arranger alle knap

You can also turn Synchronous Scrolling on or off. Du kan også slå Synkronrulning til eller fra.

Synchronous Scrolling button

Synchronous Scrolling button Synkronrulning knap

VN:F [1.9.6_1107] VN: F [1.9.6_1107]
Rate this Post Bedøm dette indlæg
Rating: 5.0/ 5 (1 vote cast) Rating: 5.0 / 5 (1 stemme afgivet)
Excel 2007: How to view two worksheets side-by-side , 5.0 out of 5 based on 1 rating Excel 2007: Sådan får du vist to regneark side-by-side, 5,0 ud af 5 baseret på 1 rating
Del
Translate this post Oversæt dette indlæg





Comments are closed. Kommentarer er lukket.