How Many Worksheets Display In The Excel Window

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 each workbook window, click the sheet that you want to compare.

4. To scroll both worksheets at the aforementioned time, click Synchronous Scrolling in the Window group on the View tab.

   Annotation:This selection is available only when View Side by Side is turned on.

Tips:

• If yous 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.

1. Open up both of the workbooks that contain the worksheets that you want to compare.

2. On the View tab, in the Window grouping, click View Side by side .

   

   If yous have more than ii workbooks open, Excel displays the Compare Next dialog box. In this dialog box, under Compare Next with, click the workbook that contains the worksheet that you want to compare with your active worksheet, and then click OK.

3. In each workbook window, click the sheet that you want to compare.

4. To scroll both worksheets at the same fourth dimension, click Synchronous Scrolling in the Window group on the View tab.

   Note:This selection is available only when View Side by side is turned on.

Tips:

• Showtime with Excel 2013, workbooks that you open in Excel are no longer displayed as multiple workbook windows inside a unmarried Excel window. Instead, they are shown equally separate Excel windows. Because workbooks don't share the same Excel window, they are displayed with their own ribbon, and y'all can view the open workbooks on unlike monitors.

• If you lot 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.

1. Open up ane or more workbooks that contain the worksheets that y'all want to view at the same time.

2. Do one of the following:

   • If the worksheets that you want to view are in the aforementioned workbook, do the following:

     1. Click a worksheet that you want to view.

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

        

     3. Repeat steps 1 and two for each canvass that y'all want to view.

   • If the worksheets that you want to view are in dissimilar workbooks, keep with step 3.

3. On the View tab, in the Window group, click Arrange All.

4. Under Arrange, click the pick that you desire.

5. If the sheets that you desire to view are all located in the active workbook, select the Windows of active workbook check box.

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

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

   

2. In each workbook window, click the sail that you want to compare.

Source: https://support.microsoft.com/en-au/office/compare-two-or-more-worksheets-at-the-same-time-1deed3da-a297-4260-98aa-a7b2d90c81ab

Posted by: dillwhount.blogspot.com

Share this post