23. Freezing panes to lock headers

Freezing Panes to Lock Headers

Freezing panes in Excel allows you to lock specific rows or columns so they remain visible while you scroll. This is especially useful for locking headers. Let’s learn how:

Steps to Freeze Panes

1. Step 1: Select the cell below the row or to the right of the column you want to freeze.
2. Step 2: Go to the View tab in the toolbar.
3. Step 3: Click the Freeze Panes option and choose the desired freezing type.

Interactive Example

#	A	B	C
1	Data 1A	Data 1B	Data 1C
2	Data 2A	Data 2B	Data 2C
3	Data 3A	Data 3B	Data 3C
4	Data 4A	Data 4B	Data 4C
5	Data 5A	Data 5B	Data 5C

Click "Freeze Panes" to lock the header row so it stays visible while you scroll.