How To Open Excel In Two Separate Windows

View two worksheets in the same workbook next in Excel 2007, 2010, 2013 & 2016

1. On the View tab, in the Window group, click New Window.

2. On the View tab, in the Window group, click View Adjacent .
3. In the workbook window, click the worksheets that you want to compare.
4. To scroll both worksheets at the same time, click Synchronous Scrolling in the Window group on the View tab.

 Note  This option is available only when View Next is turned on.

Tips

• If you resize the workbook windows for optimal viewing, you lot can click Reset Window Position to return to the original settings.
• To restore a workbook window to full size, click Maximize at the upper-right corner of the workbook window.

View two worksheets of dissimilar workbooks side by side

1. Open both of the workbooks that comprise the worksheets that y'all desire to compare.
2. On the View tab, in the Window group, click View Side by side.

 Note  If you keep more than 2 workbooks open, Excel displays the Compare Side by Side dialog box. In this dialog box, under Compare Side by Side with, click the workbook that contains the worksheet that you want to compare with your agile worksheet, and and then click OK.

3. In each workbook window, click the sheet that you want to compare.
4. To roll both worksheets at the same time, click Synchronous Scrolling in the Window group on the View tab.

 Note  This option is bachelor simply when View Side past Side is turned on.

Tips

• If you resize the workbook windows for optimal viewing, you can click Reset Window Position to return to the original settings.
• To restore a workbook window to full size, click Maximize at the upper-correct corner of the workbook window.

View multiple worksheets at the same time

1. Open the workbook or workbooks that contain the worksheets that you want to view at the same fourth dimension.
2. Do 1 of the following:
   • If the worksheets that you want to view are in the same workbook, do the post-obit:
     1. Click a worksheet that y'all want to view.
     2. On the View tab, in the Window group, click New Window.
     3. Echo steps 1 and 2 for each sheet that yous want to view.
   • If the worksheets that you desire to view are in dissimilar workbooks, keep with step 3.
3. On the View tab, in the Window group, click Adjust All.
4. Under Arrange, click the option that you want.
5. To view sheets only in the active workbook, select the Windows of active workbook check box.

 Tip  To restore a workbook window to total size, click Maximize at the upper-right corner of the workbook window.

Source: https://libanswers.walsh.edu/faq/147936

Posted by: belfordblince.blogspot.com

Share this post