How to Freeze a Row in Excel

Key Takeaways:

• Freezing rows in Excel keeps headers and key data visible while you scroll through large spreadsheets.
• Use View > Freeze Panes to freeze the top row, the first column or multiple rows and columns at once.
• The cell you select before clicking Freeze Panes determines which rows and columns stay locked in place.
• You can unfreeze panes at any time from the same Freeze Panes dropdown on the View tab.

Freezing a row in Excel locks it in place so it stays visible as you scroll through your spreadsheet. This is essential when you are working with large datasets - Excel supports over 1 million rows and more than 16,000 columns of data. Without frozen rows, you would have to scroll back to the top every time you need to check a column header. Freezing rows and columns helps keep the information you need in view on the Excel window, and pairing this with hyperlinks in Excel can further streamline navigation in complex workbooks.

How to Use Freeze Panes in Excel

Excel's Freeze Panes feature, found on the View tab, offers three options: Freeze Top Row, Freeze First Column and Freeze Panes. Here are the steps for each method.

Freeze the Top Row

1. Scroll until the row you want to remain "on top" is the very first row in the window.
2. Click the View tab.
3. Click the Freeze Panes dropdown.
4. Click Freeze Top Row.

Now when you scroll up and down through your spreadsheet, the top row stays in place and the other rows pass under it.

Important Tip! Excel will freeze any row that is at the top of the window using this method. It is a common misunderstanding that only Row 1 freezes. If the row that is frozen is not Row 1, you will not be able to scroll higher than the frozen row! For example, if you freeze Row 21 as your top row, then you will not be able to see Rows 1-20 until you unfreeze it.

Freeze the First Column

1. Scroll until the column you want to remain "on the left" is the very first column in the window.
2. Click the View tab.
3. Click the Freeze Panes dropdown.
4. Click Freeze First Column.

Now when you scroll left and right through your spreadsheet, the left column stays in place and the others pass under it.

Important Tip! Excel will freeze any column that is leftmost in the window using this method. If the column that is frozen is not Column A, you will not be able to scroll past the frozen one! For example, if you freeze Column D as your first column, then you will not be able to see Column A-C until you unfreeze it.

Note that these two commands can not be used together. Clicking Freeze First Column will cancel a freeze on the first row, for example. So that leads us to the next question:

Freeze Multiple Rows and Columns

You can freeze multiple rows and columns at the same time, but it does take a little thinking to get your head around how it works. Here are the steps:

1. Place your cursor in the cell to the right and/or below where you want the freezing lines to be drawn. Here are several examples of how to choose which cell you need:

• Click cell A2 to freeze the top row.
• Click cell B1 to freeze the first column.
• Click cell B2 to freeze the top row and the left column. (See Image)
• Click cell C3 to freeze the top two rows and the left two columns.

1. Click the View tab.
2. Click the Freeze Panes dropdown.
3. Click Freeze Panes.

Now when you scroll, any row above where your cursor was placed will remain in place and any column to the left of your cursor will be frozen. At first it can be tricky to figure out which cell to click to freeze the correct rows and columns, especially if you are still building your Excel basics. Try it a few times, freezing and unfreezing, until you get the hang of it.

The table below provides a quick reference for common freeze scenarios using Excel freeze panes.