Office Settings & Configuration

How to Freeze Header Rows in Excel While Scrolling

Muhammad Talha Sep 30, 2026 869 views

Question details

The user wants to keep worksheet header rows visible while scrolling through large datasets.

Product: Excel
Device & OS: not provided
Scenario: Navigating through extensive spreadsheets where data labels disappear when scrolling down.
Observed behavior: To lock specific rows or columns in place so they remain permanently anchored to the screen during vertical or horizontal scrolling.

Before you start

Ensure you have selected the correct worksheet and exited any active cell editing mode by pressing the Esc key, as editing a cell temporarily disables the Freeze Panes feature.

Solution 1Recommended

Use Freeze Panes to Lock Multiple Rows or Columns

This flexible method allows you to freeze multiple rows, or both rows and columns simultaneously, to keep complex headers visible.

By selecting a specific anchor cell, you tell Excel exactly where to split the screen and freeze the content above and to the left of your selection.

Select the anchor cell

Click the first cell immediately below the rows and to the right of the columns you want to freeze. For example, select A3 to freeze rows 1 and 2, or B3 to freeze rows 1 and 2 as well as column A.

Navigate to the View tab

Click on the 'View' tab located in the top ribbon menu.

Apply Freeze Panes

Click on 'Freeze Panes', then choose 'Freeze Panes' from the drop-down menu.

Successfully Frozen: A thin dark line will appear indicating the locked areas. Your headers will now remain visible as you scroll through the data.

Solution 2

Quickly Freeze the Top Row

Use this built-in shortcut if your headers are located exclusively in the very first row of your worksheet.

WPS Spreadsheet Solutions

Easily Lock Header Rows and Columns in WPS Spreadsheet

WPS Office provides a highly intuitive interface for handling large datasets. You can quickly freeze header rows and columns to make navigating massive spreadsheets completely effortless.

1. Open your spreadsheet: Launch WPS Spreadsheet and open the file containing your data.
2. Select the target cell: Click the cell directly below the row or rows you want to keep visible.
3. Apply Freeze Panes: Navigate to the 'View' tab, then click on 'Freeze Panes' to lock your headers in place.

Instantly freeze multiple rows and columns for better data visibility.Fully compatible with Microsoft Excel (.xlsx, .xls) file formats.Lightweight, fast, and completely free to use for your daily office tasks.

microsoft office alternative - wps office

Frequently Asked Questions

How do I unfreeze panes in Excel?

To unlock your rows and columns, go to the 'View' tab on the ribbon menu, click on 'Freeze Panes', and select 'Unfreeze Panes' from the dropdown list. This instantly removes all locked areas on the sheet.

Why is the Freeze Panes option greyed out or disabled?

The Freeze Panes option may become inactive if you are currently editing inside a cell or formula bar. Press the 'Esc' key on your keyboard to exit cell editing. It may also be greyed out if your worksheet is protected or using Page Layout view.

Can I freeze rows in the middle of my worksheet?

Excel only allows you to freeze rows at the top of the worksheet and columns on the far left. You cannot isolate and freeze rows located strictly in the middle without also freezing every row above them.

Office App Problems