Freezing Panes and View Options

In Excel freeze panes to compare information, and use view options in Excel to more easily read Excel spreadsheets.

Challenge!

  1. Open an existing Excel workbook. If you want, you can use our practice workbook.
  2. Try freezing a row or column in place. If you are using the example, freeze the top two rows (rows 1 and 2).
  3. Try opening a new window for your workbook.
  4. Use the Split command to split your worksheet into multiple panes.