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.
And another dataset that we want to view side-by-side is given below.
Therefore, follow the procedure to perform the task.
- First, open the Excel file.
- Then, select the View tab from the ribbon.
- Choose the New Window option from the Window drop-down.
- 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.
Another worksheet of the different workbooks is given below.
So, learn the below steps to carry out the operation.
- Firstly, open the workbooks which have our desired worksheets.
- Next, click View ➤ Window ➤ View Side by Side.
- Consequently, it’ll return the sheets side-by-side in a vertical position.
- How to Split Screen in Excel (3 Ways)
- Separate Sheets in Excel (6 Effective Ways)
- How to Split Excel Sheet into Multiple Files (3 Quick Methods)
- Split Sheets into Separate Workbooks in Excel (4 Methods)
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.
- First of all, open the workbook and click the desired sheet.
- Then, select New Window under the View tab in the Window group.
- 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.
- In the beginning, open the workbooks.
- Next, click View ➤ Window ➤ Arrange All.
- Consequently, in the pop-out dialog box, select Vertical.
- Press OK.
- Finally, it’ll return the multiple sheets of different workbooks side-by-side.
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.
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
- 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.
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.
- How to Split a Workbook to Separate Excel Files with VBA Code
- Excel VBA: Split Sheet into Multiple Sheets Based on Rows
- How to Split Excel Sheet into Multiple Worksheets (3 Methods)
- Split Excel Sheet into Multiple Sheets Based on Rows
- How to Split Excel Sheet into Multiple Sheets Based on Column Value