Forum Discussion
Excel 365 - View side-by-side
- Apr 10, 2022
It is definitely working on the Mac. Mac up to 2019 does not have synchronous scrolling however. Here below are the screen grabs for different window layouts where previously I had only posted the text.
Works on Mac here. So there you have it. Also, here below is a video showing how easy it is.
https://www.youtube.com/watch?v=zQlJvq1cr5s
Great computing to you.
LorraineLorraine2110 You can arrange windows, but you can't view side-by-side on Excel for the Mac. At least, I haven't been able to locate it.
See if this is it. If you search for "tile or cascade windows in Excel for Mac" in the Help search, you'll get the little graphics also, and it will be even more clear.
View multiple panes, sheets, or workbooks
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.
a. 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.
Chris
wigglemylegs
- LorraineLorraine2110Apr 09, 2022Copper ContributorThanks Chris. Am thinking that view side-by-side doesn’t exist on mac. I wanted it for multiple workbooks. Arrange windows sounds good. Will take a look at that. Many thanks.
- wigglemylegsApr 10, 2022Copper Contributor
It is definitely working on the Mac. Mac up to 2019 does not have synchronous scrolling however. Here below are the screen grabs for different window layouts where previously I had only posted the text.
Works on Mac here. So there you have it. Also, here below is a video showing how easy it is.
https://www.youtube.com/watch?v=zQlJvq1cr5s
Great computing to you.
- Riny_van_EekelenApr 09, 2022Platinum Contributor
wigglemylegs Don't believe this is "Side-by-side" view like on Excel for Windows though. Not really my problem.
- LorraineLorraine2110Apr 09, 2022Copper ContributorThanks Riny. That’s what I think too.