Explanation
Excel can open multiple windows of the same workbook, allowing you to view different parts of a workbook at the same time.
Key Concepts
- New Window: Opens another view of the current workbook.
- Arrange All: Arranges multiple workbook windows on the screen.
Example
You can use New Window to view:
- Sheet1 in one window
- Sheet2 in another window
Then use Arrange All to organize the windows.
Practice
Open a workbook with three worksheets and:
- Create a New Window.
- Open another workbook window if required.
- Use Arrange All.
- Compare the worksheets.