How to Enable Vertical Side-by-Side View in Excel – 4 Methods

Method 1 – Enable Vertical Side-by-Side View of 2 Worksheets in the Same Excel Workbook

This is the first sample dataset.

View 2 Excel Worksheets in Same Workbook Side by Side Vertically

This is the dataset you want to view side-by-side with the first one.

View 2 Excel Worksheets in Same Workbook Side by Side Vertically

STEPS:

  • Open the Excel file.
  • Select the View tab.
  • Choose New Window in Window.

View 2 Excel Worksheets in Same Workbook Side by Side Vertically

  • Select the View tab.
  • In Window, select Arrange All.

  • In Arrange Windows, select Vertical.
  • Click OK.

  • You’ll see the sheets side-by-side vertically.


Method 2 – Selecting Vertical Arrangement to view 2 Worksheets of Different Workbooks Side-by-Side

The following dataset is the first worksheet in the first workbook.

Vertical Arrangement to See 2 Worksheets of Different Workbooks Side by Side

This worksheet is in a different workbook.

Vertical Arrangement to See 2 Worksheets of Different Workbooks Side by Side

STEPS:

  • Open the two workbooks.
  • Select View Window View Side by Side.

Vertical Arrangement to See 2 Worksheets of Different Workbooks Side by Side

  • You’ll see the sheets side-by-side in vertical position.


Method 3 –  Displaying Multiple Worksheets in the Same Workbook Side-by-Side in Excel

STEPS:

  • Open the workbook and select the sheet.
  • Select New Window in the View tab (Window).

Side by Side Vertical Display of Multiple Worksheets in Same Workbook in Excel

  • Repeat the above step for each worksheet.
  • Select View Window Arrange All.
  • In the Arrange Windows dialog box, select Vertical.
  • Click OK.

  • This is the output.


Method 4 – Viewing Multiple Excel Worksheets of Different Workbooks Side-by-Side

STEPS:

  • Open the workbooks.
  • Click View Window Arrange All.
  • Select Vertical.
  • Click OK.

View Multiple Excel Worksheets of Different Workbooks Side by Side Vertically

  • Multiple sheets of different workbooks are displayed side-by-side.

Related Article: How to Split Screen in Excel


What to Do If ‘View Side by Side’ Is Not Functioning in Excel?

  • If only one worksheet is open, the View Side by Side button will be gray (Not Activated). Open another worksheet to activate it.
  • Select View Window Reset Window Position if the above solution doesn’t work.

Note:

If resetting The window position doesn’t work:

  • Open the first Excel worksheet.
  • Press Ctrl + N  to open a new Excel window.
  • Select File Open and select the Excel file.
  • Click View Window View Side by Side.


Important Tips

  • Click Maximize to restore a workbook window to its full size.
  • Select View Window Reset Window Position to go back to the default view.

Download Practice Workbook

Download the following workbook.


Related Articles


<< Go Back to Split Excel Cell | Excel Worksheets | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Aung Shine
Aung Shine

Aung Shine completed his bachelor’s in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. It has been almost 2 years since he joined SOFTEKO and actively working on the ExcelDemy project. Currently he works as a Team Leader where he guides his team members to create technical content. He has published 150+ articles and reviewed 50+ articles. He has also solved various user problems before. He has interests in Data Analysis, Power Query, Advanced Excel,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo