View: Split Screen
Say you had a
complex spreadsheet with a lot of information. You can Split the
spreadsheet into four different Views. Each split has its own set
of scroll bars so each split can have a different View of your data.
6. Try This: Use Split Screen
The sample Excel spreadsheet is still open.
Select Cell A1.
Go to
View->Window->
Split.

What Do You See? The default split is in quarters.
You can drag the splits to the Rows and Columns that make sense.
Keep going...