One of the most frustrating problems for Excel users is viewing all the information they need, especially because it often lives in different worksheets. Here you can know about this simple way to view multiple sheets, and you will love forever.
1. Click on the tab of the worksheet you want to view.
2. Choose New Window from the Window menu.
3. Repeat this process for each of the worksheets you want to display. (Excel opens each sheet in a window that sits on top of the previous one.)
4. To see them all at one time, choose Arrange from the Window menu.
5. Select Tiled, Horizontal, or Vertical.
6. Select the Windows Of Active Workbook check box.
7. Click OK.
