Forum Discussion

LorraineLorraine2110's avatar
LorraineLorraine2110
Copper Contributor
Apr 09, 2022
Solved

Excel 365 - View side-by-side

I am unable to find View side-by-side on my toolbar.  My understanding is that it should be next to Split on the View tab.  However on my toolbar the icon next to Split is Switch windows and I am unable to find View side-by-side (and synchronous scrolling) anywhere.

Please could someone advise me? I am assuming the option is still available.  I am using a Mac.  Thanks in advance.  

  • wigglemylegs's avatar
    wigglemylegs
    Apr 10, 2022

    LorraineLorraine2110 

    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.

     

     

     

     

     

6 Replies

    • wigglemylegs's avatar
      wigglemylegs
      Copper Contributor

      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

      • LorraineLorraine2110's avatar
        LorraineLorraine2110
        Copper Contributor
        Thanks 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.

Resources