View multiple panes, sheets, or workbooks – Excel for Mac
Posted by jpluimers on 2022/03/31
Usually, I work in a single worsheet and workbook at a time.
Sometimes I use multiple worksheets or workbooks, and I never knew about the below feature.
The really cool aspect which is not in the below documentation: if you re-open a worksheet, it remembers the views and positions!
Learned a new thing and discovered a new thing (:
[WayBack] View multiple panes, sheets, or workbooks – Excel for Mac:
In Excel for Mac, you can split a sheet in to panes, view multiple sheets in one workbook, or view multiple workbooks at a time.
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:
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 - 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
–jeroen
The Wiert Corner - irregular stream of stuff 
Leave a Reply