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:

  1. Create a New Window.
  2. Open another workbook window if required.
  3. Use Arrange All.
  4. Compare the worksheets.