Question

we can the worksheet window into separate panes​

Answer 1

Answer:

Split a sheet into panes

When you split a sheet into separate panes, you can scroll in both panes independently. Select below the row where you want the split, or the column to the right of where you want the split. On the View tab, in the Window group, click Split. To remove the split panes, click Split again.

Answer 2

Answer:

Split a sheet into panes

Select below the row where you want the split, or the column to the right of where you want the split.

Select below the row where you want the split, or the column to the right of where you want the split.On the View tab, in the Window group, click Split. To remove the split panes, click Split again.