Excel for Microsoft 365 for Mac Excel 2021 for Mac Excel 2019 for Mac More...Less
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.
-
Select below the row where you want the split, or the column to the right of where you want the split.
-
On the View tab, in the Window group, click Split.
-
To remove the split panes, click Split again.
-
View multiple sheets in one workbook
-
Open the workbook that you want to view.
-
On the Window menu, click New Window.
-
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.
-
On the Window menu, click Arrange.
-
Do one of the following:
See AlsoGet more done with multitasking in WindowsBest Monitors for Traders – A Complete Guide in 2023 - ViewSonic LibraryHow to maximize a chart in multichart layout — TradingViewHow to Overlay Charts in Excel | MyExcelOnlineTo 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
-
Select the Windows of active workbook check box.
View multiple workbooks
-
Open all the workbooks that you want to view.
-
On the Window menu, click Arrange.
-
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
Need more help?
Want more options?
Discover Community
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.