Freezing Panes and View Options
Learn how to freeze rows and columns, split worksheets, and open multiple windows to compare data more effectively.
Video
Watch the lesson video, then complete the reading and challenge.
Lesson Notes
Read through the key concepts before you try the challenge.
Why Freeze Panes and View Tools Matter
As spreadsheets grow larger, important information like headers and identifiers can disappear when scrolling. Excel provides Freeze Panes, Split, and New Window tools to improve navigation and comparison.
Freeze the Top Row
If your headers are in Row 1, use Freeze Top Row to keep them visible while scrolling.
Row 1 remains visible even as you scroll down.
Freeze Multiple Rows
To freeze more than one row, select the row below the rows you want frozen, then choose Freeze Panes.
.png)
Freeze Columns
To freeze columns, select the column to the right of the columns you want frozen.
The first column stays visible while scrolling horizontally.
Unfreeze Panes
To remove any freeze settings, go to View → Freeze Panes → Unfreeze Panes.
Open a New Window
Excel allows you to open a second window of the same workbook for comparison.
Arrange All Windows
Use Arrange All to automatically tile workbook windows for comparison.
Split a Worksheet
The Split command divides your worksheet into panes that scroll independently.
Each pane scrolls independently for comparison.
Knowledge Check
What does freezing the top row in Excel do?
Practice File
Download this file and follow along with the lesson.
Challenge
Apply what you've learned in this lesson.
Within our example file, there is a LOT of sales data. For this challenge, we want to compare data for different years side by side. To do this:
- Download our practice workbook.
- Open a new window for your workbook.
- Freeze First Column and use the horizontal scroll bar to look at sales from 2015.
- Unfreeze the first column.
- Select cell G17 and click Split to split the worksheet into multiple panes. Hint: This should split the worksheet between rows 16 and 17 and columns F and G.
- Use the horizontal scroll bar in the bottom-right of the window to move the worksheet so Column N, which contains data for January 2015, is next to Column F.
- Open a new window for your workbook and select the 2012-2013 Sales tab.
- Move your windows so they are side by side. Now you’re able to compare data for similar months from several different years. Your screen should look something like this: