View two worksheets Side-by-Side in Excel lets you view multiple worksheets at once in layouts like vertical, horizontal, tiled, or cascade, so you don’t have to keep switching between sheets. You can also split a single worksheet into separate panes by going to the View tab and selecting Split, making it easier to see different parts of your data at the same time.

Method 1:- Split and View Two worksheets Side by Side in Excel of the Same Workbook

  • First, go to the View tab and click on New Window in the Window group on the ribbon.
Β 
28.1 view side by side
  • Each click creates a new copy of your open workbook, with numbers like 1, 2, 3, etc., added to the workbook’s name.
28.2 view side by side
  • Next, click Arrange All in the Window group, choose your preferred view (Tiled, Horizontal, Vertical, or Cascade), and click OK. Make sure Windows of active workbook is checked.
View Two Worksheets Side by Side in Excel - 2 Easy Methods
  • Your workbook will now be split into multiple views. To display different sheets in each view, just click on the sheet tab you want in each window.
28.4 view side by side
  • You can split into more than two views by clicking New Window as many times as needed.

Method 2:- View Two Worksheets Side by Side in Excel of the Different Workbooks

  1. Open the workbooks you want to compare.

  2. Go to the View tab and click Arrange All in the Window group.

28.6 view side by side
  • Choose your preferred split view (Tiled, Horizontal, Vertical, or Cascade) from the list.

  • Uncheck the Windows of active workbook option, then click OK.

Now this will view two worksheets side by side in excel making it easy to compare them.

28.5 view side by side

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *