How To Freeze A Row In Excel

When working with large spreadsheets, it's easy to lose track of which column is which as you scroll down. Freezing a row in Excel locks it in place, so your column headers remain visible no matter how far you navigate through your data. This simple but powerful feature makes your spreadsheets much easier to read and manage. This guide will walk you through exactly how to freeze the top row, multiple rows, and even columns, ensuring your important headers are always in sight.

Fast Answer

To freeze the top row: Go to the View tab, click Freeze Panes, and select Freeze Top Row.
To freeze multiple rows: Select the single row below the last row you want to freeze, then go to View > Freeze Panes > Freeze Panes.

Less than 1 minute Time needed

Beginner Difficulty

Selecting the wrong cell Watch out for

Before You Start

Microsoft Excel: You will need any modern version of Microsoft Excel installed on your computer (for Windows or macOS). The steps are very similar across recent versions like Excel 2016, 2019, 2021, and Microsoft 365.
An open spreadsheet: Have the Excel file you want to work with open. It is most helpful if this sheet has a header row or multiple rows at the top that you wish to keep visible.
Normal View Mode: Ensure you are in 'Normal' view. The Freeze Panes option is not available in 'Page Layout' or 'Page Break Preview' modes. You can check this at the bottom-right of the Excel window or in the 'View' tab.

Check first: The most common mistake is selecting the wrong place before freezing. To freeze rows, you must select the row *below* the rows you want to lock. If you want to freeze the top two rows, you must click to select all of row 3 first.

Step-by-Step Instructions

Open Your Excel Spreadsheet

First, launch Microsoft Excel and open the workbook containing the data you want to work with. Navigate to the specific worksheet where you need to freeze a row. For this guide, we'll assume you have a sheet with column titles in the first row, like "Date," "Product," "Region," and "Sales." As you scroll down to see more sales data, these titles disappear, making it hard to read.

Method 1: Freeze Only the Top Row

This is the simplest method and is perfect if your column headers are all contained within row 1. You don't need to select any specific cells for this action.

Simply navigate to the Excel ribbon at the top of the screen. Click on the View tab. In the 'Window' group of commands, you will see an icon labelled Freeze Panes. Click this icon to reveal a dropdown menu. From the menu, select Freeze Top Row. A thin grey line will appear below row 1, indicating it is now locked. You can now scroll down your sheet, and row 1 will remain visible at all times.

Method 2: Freeze Multiple Rows

Sometimes your headers might span across several rows. For example, you might have main titles in row 1 and sub-titles in row 2. In this case, you need to freeze both rows. The key is to tell Excel where the frozen section should end.

To do this, you must select the entire row immediately below the last row you want to freeze. For example, to freeze rows 1 and 2, click on the number 3 in the row header on the far left side of the screen. This will highlight all of row 3. With row 3 selected, go to the View tab, click the Freeze Panes dropdown, and this time select the first option, also called Freeze Panes. Excel will now freeze all rows above your selection (rows 1 and 2).

Tip: You don't have to select the entire row. Simply selecting the first cell in that row (e.g., cell A3 to freeze rows 1 and 2) also works perfectly fine.

Method 3: Freeze Rows and a Column Simultaneously

What if you want to keep both the top header row and the first column (e.g., containing product names) visible as you scroll? This is also done with the 'Freeze Panes' command, but your initial cell selection is even more important.

You need to select the single cell that is just below your target rows and just to the right of your target columns. For example, to freeze row 1 and column A, you would click to select cell B2. Cell B2 is below row 1 and to the right of column A. Once you've selected this cell, go to View > Freeze Panes > Freeze Panes. Now when you scroll down, row 1 will stay put. When you scroll to the right, column A will stay put. This is incredibly useful for navigating large, complex tables of data.

Verify That the Rows are Frozen

Once you've applied the freeze, it's a good idea to check that it worked as expected. Look for a thin, solid line that appears below the last frozen row and/or to the right of the last frozen column. This line is the visual indicator of the "frozen" boundary.

The best way to test it is to simply use your mouse wheel or the scroll bar. Scroll down your sheet. The frozen rows at the top should remain fixed in place while the rest of the data scrolls underneath them. If you also froze columns, scroll to the right to see them remain locked as well.

How to Unfreeze Rows

Removing the freeze is even simpler than applying it. At any time, you can go back to the View tab and click on the Freeze Panes dropdown menu. If any panes are currently frozen, the top option will now read Unfreeze Panes.

Click Unfreeze Panes to remove all locks on your rows and columns. The sheet will return to its normal scrolling behaviour. You only need to click this one command; you do not need to select any specific cells or rows beforehand. It's an all-or-nothing action.

Quick Reference

Situation	Use this	Why
You need to lock just the very top row (Row 1).	View > Freeze Panes > Freeze Top Row	This is a dedicated, one-click command that doesn't require any cell selection.
You need to lock the top three rows (Rows 1-3).	Select Row 4, then View > Freeze Panes > Freeze Panes.	This command freezes everything above your current selection.
You need to lock Row 1 and Column A.	Select cell B2, then View > Freeze Panes > Freeze Panes.	This freezes everything above and to the left of the selected cell.
You want to remove all frozen rows and columns.	View > Freeze Panes > Unfreeze Panes	This is the universal command to unlock all panes on the current sheet.

Common Problems When You Freeze a Row in Excel

While freezing rows is usually straightforward, a few common issues can trip you up. Here’s how to solve them.

The Wrong Rows or Columns are Frozen

This is the most frequent problem and it almost always comes down to selecting the wrong cell before applying the freeze. Remember the golden rule: Excel freezes everything above and to the left of your active cell. If you accidentally froze rows 1-5 when you only wanted to freeze row 1, it means you likely had row 6 selected.

The Fix: First, unfreeze everything by going to View > Freeze Panes > Unfreeze Panes. Then, carefully click on the correct starting cell or row. For freezing just row 1, the easiest way is to use the dedicated 'Freeze Top Row' command. For freezing multiple rows (e.g., 1 and 2), make sure you select row 3 before freezing.

The 'Freeze Panes' Option is Greyed Out

If you navigate to the View tab and find that the Freeze Panes button is disabled and you can't click it, you are likely in one of two modes.

Cell Editing Mode: If your cursor is blinking inside a cell because you are typing or editing a formula, Excel locks many commands, including Freeze Panes. Simply press the Esc key on your keyboard or click another cell to exit editing mode. The button should become active again.
Page Layout View: Excel has different viewing modes. Freeze Panes only works in the 'Normal' view. If you are in 'Page Layout' or 'Page Break Preview' (often used for preparing to print), the option will be unavailable. To fix this, go to the View tab and, in the 'Workbook Views' group, click on Normal.

I Can See Two Copies of My Header Row

This happens if you scroll down your sheet *before* freezing the panes. For example, if you scroll down so that row 1 is no longer visible and then select row 20 and click 'Freeze Panes', Excel will freeze everything visible at the top of your screen (e.g., rows 19 and above). When you scroll back to the top, you'll see your original header in row 1 and the frozen copy, which can be very confusing.

The Fix: Always scroll back to the very top of your worksheet (so that row 1 is visible) before you apply any freeze. A quick way to get to the top is to press Ctrl + Home on your keyboard. Then, apply the freeze as normal.

Advanced Tips for Freezing Rows in Excel

Once you've mastered the basics, these advanced techniques can give you even more control over how you view your data.

Use Keyboard Shortcuts

For those who prefer using the keyboard, Excel has quick shortcuts for freezing panes. These use the 'Alt' key to access the ribbon commands.

Freeze/Unfreeze Panes: Press Alt + W, F, F. This is a toggle. If nothing is frozen, it will freeze based on your selection. If panes are already frozen, it will unfreeze them.
Freeze Top Row: Press Alt + W, F, R.
Freeze First Column: Press Alt + W, F, C.

Use the 'Split' Feature as an Alternative

Sometimes, you need to compare two sections of a large sheet that are far apart, for instance, sales figures from January (at the top) and December (at the bottom). Freezing only helps with headers. In this case, the 'Split' feature is more useful.

Go to the View tab and click Split. This will divide your worksheet into two or four separate scrollable panes. You can drag the split bars to resize the panes. This allows you to scroll independently in one pane while the other stays put, making it easy to compare distant rows or columns without affecting the entire sheet's layout.

Freezing Rows in an Excel Table

If you have formatted your data as an official Excel Table (using Insert > Table or Ctrl + T), Excel has a handy built-in feature. When you create a Table, the header row will automatically replace the column letters (A, B, C...) as you scroll down. The headers become locked into the top of the frame without you needing to use the Freeze Panes command at all. This is one of the many benefits of using the formal Table feature for organising data.

How To Freeze A Row In Excel FAQ

Can I freeze a row in the middle of a spreadsheet?

No, Excel's Freeze Panes feature is designed to lock only the top-most rows and left-most columns. You cannot freeze a row, such as row 50, while allowing rows 1-49 to scroll freely. If you need to compare a middle row with other data, the 'Split' view is the best alternative.

How many rows can I freeze in Excel?

You can freeze as many rows as you like, as long as they are contiguous and at the top of the sheet. To freeze the top 20 rows, simply select row 21 and then use the 'Freeze Panes' command. Excel will lock rows 1 through 20.

Why does a thin line appear on my sheet after freezing?

The thin, solid grey line is Excel's visual indicator showing you where the frozen boundary is. A horizontal line appears below the last frozen row, and a vertical line appears to the right of the last frozen column. This line does not print and is only visible on your screen.

Does freezing a row affect my formulas or printing?

No, freezing a row is purely a display feature. It does not change your data, formulas, cell references, or how the sheet prints. It only affects how you view and scroll through the data on your screen.

Can I freeze rows in Excel for the web or on mobile?

Yes, the functionality is available in Excel for the web and the mobile apps, though the interface is slightly different. In Excel for the web, the 'Freeze Panes' option is also located on the 'View' tab and works in the same way. On the mobile app, you can usually find it under the View menu as well.

Final Checklist for Freezing a Row in Excel

Before you finish, run through this quick checklist to ensure your spreadsheet is set up perfectly for easy viewing.

Goal Identified: You know exactly which rows (and possibly columns) you need to keep visible.
Correct Starting Position: You have scrolled to the top of the worksheet so that row 1 is visible.
Correct Selection Made: You have selected the single cell or row *below and to the right* of the area you want to freeze.
Correct Command Used: You have navigated to View > Freeze Panes and chosen the appropriate option ('Freeze Panes' for a custom selection or 'Freeze Top Row' for the simplest case).
Freeze Verified: You have scrolled down and/or right to confirm that the correct headers are locked in place and the boundary line is where you expect it.
Unfreeze Know-How: You know that you can easily remove the lock at any time by going to View > Freeze Panes > Unfreeze Panes.