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.

 

4. Try This: Use Split Screen

Open a sample Excel file, first.

The workbook is in Normal View.

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.

 

Exam 77-882: Microsoft Excel 2010 Core

4. Managing Worksheets and Workbooks

4.2. Manipulate Window views: View Split

 
View -> Window-> Split