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.

 

graphic3

 

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...

 

 
View -> Window-> Split
graphic2
 
graphic1

Exam 77-420 Microsoft Excel 2013
1. Create and Manage Worksheets and Workbooks
1.4 Customize Options and Views for Worksheets and Workbooks: Split Screen