View multiple panes, sheets, or workbooks

Do any of the following:

Split a sheet into panes

You can view two areas of a sheet by splitting it into rude. When you split a sheet into separate panes, you can scroll in both panes independently.

  1. Point to the split bar at the top of the vertical scroll bar or at the right end of the horizontal scroll bar.

    The split pointer appears when you rest the pointer over the split bar

    Delelinje og opdelingsmarkør

  2. When the pointer becomes a Vandret delt pil , drag the split bar down or left to the position that you want.

    Tip!: 

    • To remove the panes, on the Window menu, click Remove Split, or drag the split bar back to the edge of the window.

    • You cannot split a sheet and freeze parts of that sheet at the same time.

View multiple sheets in one workbook

  1. Open the workbook that you want to view.

  2. On the Window menu, click New Window.

  3. Switch to the new window, and then click the tab for the sheet that you want to view.

    Repeat steps 2 and 3 for each sheet that you want to view.

  4. On the Window menu, click Arrange.

  5. Do one of the following:

To arrange windows

So that they appear like this

Click

As equally sized, tiled squares

Vinduer i felter

Tiled

Horizontally from top to bottom

Vandrette vinduer

Horizontal

Vertically from right to left

Lodrette vinduer

Vertical

In an overlapping cascade from top to bottom

Overlappende vinduer

Cascade

  1. Select the Windows of active workbook check box.

View multiple workbooks

  1. Open all the workbooks that you want to view.

  2. On the Window menu, click Arrange.

  3. Do one of the following:

To arrange windows

So that they appear like this

Click

As equally sized, tiled squares

Vinduer i felter

Tiled

Horizontally from top to bottom

Vandrette vinduer

Horizontal

Vertically from right to left

Lodrette vinduer

Vertical

In an overlapping cascade from top to bottom

Overlappende vinduer

Cascade

Tip: To restore a workbook window to full size, select the workbook, and then on the Window menu, click Zoom Window.

See also

Freeze rows and columns

Del Facebook Facebook Twitter Twitter Mail Mail

Var disse oplysninger nyttige?

Fantastisk! Har du mere feedback?

Hvordan kan vi forbedre det?

Tak for din feedback!

×