To view multiple sheets in the active workbook, click New Window on the Window menu. Switch to the new window, and then click a sheet you want to view. Repeat for each sheet you want to view.
To view sheets in only the active workbook, select the Windows of active workbook check box.
To restore a workbook window to full size, click Maximize at the upper-right corner of the workbook window.