How to Freeze a Row in Excel

Last updated: November 7, 2019

Learning how to freeze a row in Excel is a great way to ensure that your important information, such as your column headings or titles, remain visible. Large spreadsheets can be difficult to manage in Microsoft Excel 2013, whether they are being printed or shown on the screen. One of the most troubling parts of editing a large spreadsheet is making sure that data you enter is being placed into the correct column. This can lead to a lot of scrolling up and down through the worksheet as you check your column headings to make sure you are entering data into the correct cell.

One way to simplify this process is to freeze some rows in your spreadsheet. That way they remain visible at the top of your worksheet while you scroll down to the rows that you are editing. Our tutorial below will show you how to freeze and unfreeze rows in your worksheet.

How to Freeze a Row in Excel – Quick Summary

  1. Click the row number below the last row you wish to freeze.
  2. Select the View tab at the top of the window.
  3. Click the Freeze Panes button.
  4. Select the Freeze Panes option from the dropdown menu.

You can continue below for more information on how to freeze a row in Excel, including how to freeze multiple rows, as well as how to unfreeze a row or rows that you have previously frozen.

How to Freeze One or More Rows in an Excel 2013 Spreadsheet

The steps in this article were performed in Microsoft Excel 2013, but will also work in other Excel products that use the ribbon navigation system, such as Excel 2007 and Excel 2010.
Step 1: Open your spreadsheet in Excel 2013.

Step 2: Click the row below the rows that you want to freeze. I am clicking row 7 in the picture below, as I want to freeze the top 6 rows.

select the row below the ones to freeze

Step 3: Click the View tab at the top of the window.

click the view tab

Step 4: Click the Freeze Panes button in the Window section of the ribbon, then click the Freeze Panes button. Note that you also have the choice of clicking the Freeze Top Row option as well, if you are only looking to freeze the first row of your worksheet.

click the freeze panes button

You can now scroll down your spreadsheet to view additional rows, while the frozen rows will remain visible at the top of the sheet. Once you have finished with the need to have the rows frozen, you can click the Freeze Panes button again, then click the Unfreeze Panes button.

click the unfreeze panes button

How to Unfreeze a Row in Excel

The method for unfreezing rows in Excel is very similar to how we were able to freeze a row in the guide above.

  1. Click the View tab.
  2. Choose the Freeze Panes button again.
  3. Click the Unfreeze Panes option.

This will remove any frozen panes in the worksheet, allowing you to work without them, or to elect to freeze a different row or rows in Excel.

You can use a similar method to the one described in this article to freeze the top row of an Excel spreadsheet. This is helpful if you are using a common Excel layout that uses the first row of the worksheet to label the data that will appear in the columns underneath it. Additionally, if you need to print your spreadsheet, then you can also print the top row on every page so that your readers won’t get lost as they read pages beyond the first one of the spreadsheet. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.