As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Freeze a Row in Excel: Step-by-Step Guide

It can be immensely helpful to have the top row of your Excel document always visible as you scroll down, especially if your worksheet is very long. This ensures that you can always see what each column represents, no matter where you are in the document. Fortunately, Excel makes it very easy to freeze a row (or multiple rows), so that they remain visible at the top of your spreadsheet, even as you scroll down.

How to Freeze a Row in Excel:

Step 1: Open Your Excel Worksheet

The first step is to open your Excel worksheet. If you don't have a worksheet open already, launch Excel and then open the document you want to work with. You can do this by double-clicking the file on your computer or by opening it from within Excel.

Step 2: Select the Row(s) You Want to Freeze

Now you need to select the row (or rows) that you want to freeze. To do this, click on the row header of the first row you want to freeze. For example, if you wanted to freeze row 3, you would click on the "3" row header. If you want to select multiple rows, hold down the Shift key on your keyboard and click on the row header of the last row you want to select. This will select all of the rows in between the first and last row you clicked on.

Step 3: Freeze the Row

With your row(s) selected, go up to the View tab on the Ribbon and click on the Freeze Panes button. This will open a drop-down menu. Click on the Freeze Top Row option from this menu.

Your row(s) should now be frozen! To test this out, scroll down in your spreadsheet. You should be able to see your frozen row(s) at the top, even as you scroll.

How to Unfreeze a Row in Excel:

Step 1: Open Your Excel Worksheet

The first step is to open your Excel worksheet. If you don't have a worksheet open already, launch Excel and then open the document you want to work with. You can do this by double-clicking the file on your computer or by opening it from within Excel.

Step 2: Unfreeze the Row

With your worksheet open, go up to the View tab on the Ribbon and click on the Freeze Panes button. This will open a drop-down menu. Click on the Unfreeze Panes option from this menu.

Your row(s) should now be unfrozen, and you should be able to scroll freely around your spreadsheet!

Tips for Using Freeze Panes in Excel:

Freezing Multiple Rows:

If you want to freeze more than one row at the top of your spreadsheet, select all of the rows you want to freeze before going to the View tab and clicking on the Freeze Panes button. You can select multiple rows by holding down the Shift key and clicking on the row header of the first and last row you want to select. Then, when you click on the Freeze Panes button, click on the Freeze Panes option instead of the Freeze Top Row option.

Freezing Multiple Columns:

You can also freeze multiple columns in addition to (or instead of) freezing rows. To do this, select all of the columns you want to freeze before going to the View tab and clicking on the Freeze Panes button. You can select multiple columns by holding down the Shift key and clicking on the column header of the first and last column you want to select. Then, when you click on the Freeze Panes button, click on the Freeze First Column option instead of the Freeze Top Row option.

Freezing Both Rows and Columns:

If you want to freeze both rows and columns in your spreadsheet, you can do this by selecting both the rows and columns you want to freeze before going to the View tab and clicking on the Freeze Panes button. To select both rows and columns, hold down the Shift key and click on the row header of the first row you want to select, then click on the column header of the first column you want to select. Then, when you click on the Freeze Panes button, click on the Freeze Panes option instead of the Freeze Top Row or Freeze First Column options.