How to Enable Side-by-Side View with Vertical Alignments in Excel

Get FREE Advanced Excel Exercises with Solutions!

Often, it’s necessary for us to view different Excel worksheets side by side vertically. It helps us to compare data in separate sheets or to analyze the data. The worksheets can be in the same workbook or different workbooks. In this article, we’ll show you the simple yet effective ways to enable side-by-side view with vertical alignments in Excel.


Side-by-Side View with Vertical Alignments in Excel: 4 Quick Ways

1. Enable Side-by-Side View with Vertical Alignments of 2 Worksheets in Same Excel Workbook

In our first method, we’ll show the steps to view 2 vertical side-by-side Excel worksheets in the same workbook.

The following dataset is our first worksheet.

View 2 Excel Worksheets in Same Workbook Side by Side Vertically

And another dataset that we want to view side-by-side is given below.

View 2 Excel Worksheets in Same Workbook Side by Side Vertically

Therefore, follow the procedure to perform the task.

STEPS:

  • First, open the Excel file.
  • Then, select the View tab from the ribbon.
  • Choose the New Window option from the Window drop-down.

View 2 Excel Worksheets in Same Workbook Side by Side Vertically

  • After that, again select the View tab.
  • From the Window drop-down, select the Arrange All option.

  • As a result, the Arrange Windows dialog box will pop out.
  • There, check the circle for Vertical.
  • Subsequently, press OK.

  • Lastly, you’ll get to see the sheets side-by-side vertically.


2. Allow Vertical Arrangement to See 2 Worksheets of Different Workbooks Side-by-Side

Now, we’ll show the procedure to arrange 2 worksheets of different workbooks.

The following dataset is our first worksheet of the first workbook.

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

Another worksheet of the different workbooks is given below.

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

So, learn the below steps to carry out the operation.

STEPS:

  • Firstly, open the workbooks which have our desired worksheets.
  • Next, click View ➤ Window ➤ View Side by Side.

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

  • Consequently, it’ll return the sheets side-by-side in a vertical position.


3. Side-by-Side Display of Multiple Worksheets in Same Workbook in Excel

So far, we’ve covered 2 worksheets. But, we may also want to display more than 2 worksheets. Hence, follow the below process to view multiple worksheets in the same workbook side by side vertically in Excel.

STEPS:

  • First of all, open the workbook and click the desired sheet.
  • Then, select New Window under the View tab in the Window group.

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

  • Afterward, repeat the above step for each worksheet.
  • Select View ➤ Window ➤ Arrange All.
  • As a result, the Arrange Windows dialog box will appear.
  • Check the Vertical and press OK.

  • At last, you’ll get the expected outcome.


4. View Multiple Excel Worksheets of Different Workbooks Side-by-Side Vertically

Additionally, we’ll also cover the process for displaying multiple Excel worksheets of different workbooks side by side. Therefore, learn the steps.

STEPS:

  • In the beginning, open the workbooks.
  • Next, click View ➤ Window ➤ Arrange All.
  • Consequently, in the pop-out dialog box, select Vertical.
  • Press OK.

View Multiple Excel Worksheets of Different Workbooks Side by Side Vertically

  • Finally, it’ll return the multiple sheets of different workbooks 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 you have only one worksheet open, the View Side by Side button will be in Grey color (Not Activated). Just open another worksheet to activate it.
  • Select the View ➤ Window ➤ Reset Window Position if the above point didn’t work out.

Note:

However, if the resetting didn’t work out as well, try the following:

  • Normally open the first Excel worksheet.
  • Press the keys Ctrl and N simultaneously to open another new Excel window.
  • Then, select File ➤ Open and select the desired Excel file.
  • Finally, press View ➤ Window ➤ View Side by Side.


Important Tips

  • Press the Maximize button (upper-right side) for restoring a workbook window to its full size.
  • Select the View ➤ Window ➤ Reset Window Position for going back to the default view after changing the arrangement of the windows.

Download Practice Workbook

Download the following workbook to practice by yourself.


Conclusion

Henceforth, you can enable side-by-side view with vertical alignments in Excel following the above-described methods. Keep using them and let us know if you have any more ways to do the task. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles


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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
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