![]() ![]() In each workbook window, click the tab you want to compare.To view two sheets in different workbooks side by side, this is what you need to do: To arrange the tabs vertically, use the Arrange All feature. The image below shows the default horizontal arrangement. In each window, click the desired sheet tab.On the View tab, in the Window group, click View Side by Side.This will open another window of the same workbook. On the View tab, in the Window group, click New Window. ![]() If the sheets you want to compare are in the same workbook, here are the steps to place them side by side: How to view two Excel sheets side by side View two sheets of the same workbook side by side.Luckily, it's as easy as it appears to be :) Just choose the technique that fits your situation: When it comes to comparing worksheets in Excel, the most obvious solution is to place tabs next to each other. In this article, you will learn how to open two or more windows side by side in Excel 365, 2021, 2019, 2016, 20.
0 Comments
Leave a Reply. |