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