Sidney is working in a workbook that contains three worksheets. she would like to view the worksheets side by side. to do so, first she must open each worksheet in a worksheet tab new window new file dialog box

Compare side by side

Explanation:

If you keep more than two 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 active worksheet, and then click OK.

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

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 Side by Side is turned on.

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-right corner of the workbook window.