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.


Download Practice Workbook

Download the following workbook to practice by yourself.


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

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.

Read More: How to View Excel Sheets in Separate Windows (4 Methods)


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.


Similar Readings


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.

Read More: How to Open Multiple Excel Files in One Workbook (4 Easy Ways)


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.

Read More: How to Open Two Excel Files Separately (5 Easy Methods)


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 for opening another new Excel window.
  • Then, select File Open and select the desired Excel file.
  • Finally, press View Window View Side by Side.

Read More: [Fix:] Excel View Side by Side Not Working


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.

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. Follow the ExcelDemy website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Aung Shine
Aung Shine

My name is Aung. I have my B.Sc. degree in EEE. From now on, I will be working with Microsoft Excel and other useful software, and I’ll upload articles related to them. My current goal is to write technical contents for anybody and everybody that will make the learning process of new software and features a happy journey.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo