Explanation

These tools help you navigate large worksheets without losing track of important information.

Freeze Panes

Keeps selected rows or columns visible while scrolling.

Common options:

  • Freeze Top Row
  • Freeze First Column
  • Freeze Panes

Split Window

Divides the worksheet into separate panes so different areas can be viewed simultaneously.

Example

In a student marks sheet with 500 students, use Freeze Top Row to keep column headings visible while scrolling.

Practice

Create a 50-row data table and:

  1. Freeze the top row.
  2. Freeze the first column.
  3. Use Split to view different sections simultaneously.
PreviousNext