How To View Multiple Worksheets Simultaneously In Excel

To view multiple worksheets simultaneously in Excel, you can follow the below steps introduced in this article.

1. How To View Multiple Worksheets Simultaneously In Excel Steps.

1. Open the Excel workbook that contains the worksheets you want to view.
2. Click on the “View” tab in the Excel ribbon.
3. Click on the “New Window” button in the Window group.
4. This will open a new instance of the workbook.
5. Click on the worksheet tab in the new instance that you want to view.
6. Arrange the windows side-by-side on your screen as desired.
7. Now you can view and edit multiple worksheets simultaneously in separate windows.

2. How To Arrange Multiple Worksheets Window.

1. Now you have separate the multiple worksheets into different window, you can arrange the windows easily in excel.
2. If you want to arrange the windows of multiple workbooks that are open in Excel, you can use the “Arrange All” feature under the “View” tab in the Excel ribbon.
3. This will arrange all open windows in the same way, regardless of which workbook they belong to.
4. Click on the “View” tab in the Excel ribbon.
5. Click on the “Arrange All” button in the Window group.
6. In the “Arrange Windows” dialog box, select the desired arrangement option from the list (e.g. “Horizontal,” “Vertical,” “Cascade,” etc.).
7. Click “OK” to apply the selected arrangement option.
8. Adjust the size of each window by clicking and dragging the borders.
9. Now you can compare and edit the worksheets simultaneously by typing into any of the selected windows.