How do i split a worksheet into separate files?

In Excel for Mac, you can split a sheet into panes or use windows to view multiple sheets or multiple workbooks.

Split a sheet into panes

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

1. Select below the row where you want the split, or the column to the right of where you want the split.

2. On the View tab, in the Window group, click Split.

   1. To remove the split panes, click Split again.

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		Tiled
   Horizontally from top to bottom		Horizontal
   Vertically from right to left		Vertical
   In an overlapping cascade from top to bottom		Cascade

6. 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		Tiled
   Horizontally from top to bottom		Horizontal
   Vertically from right to left		Vertical
   In an overlapping cascade from top to bottom		Cascade

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

See also

Freeze panes to lock the first row or column