Skip to content

How to freeze multiple rows in Excel?

  • by
  • 6 min read

Excel is a widely used program that helps professionals, students, and individuals to organise data, perform complex calculations, and create informative visuals. As your spreadsheets get bigger and more complicated, knowing how to manage them well is important, especially if you’re working with long datasets is important.

One such technique is freezing rows, ensuring key information remains visible as you scroll through your spreadsheet.

In this article, we have discussed how to freeze the top and multiple rows and columns and how to unfreeze them in Excel.

Below we have discussed.

Also read: How to remove a table from Excel?


How to freeze the top row in Excel?

If you want to freeze the top row in Excel, follow the steps below.

Step 1: Click on the View tab in the toolbar ribbon and then click on the Freeze Panes option in the Window section.

Step 2: Click on the Freeze Top Row option in the dropdown menu.

Step 3: You can tell that the top row is frozen by a grey line that appeared below, and you can scroll down to check that.


How to freeze multiple rows?

To freeze multiple rows in Excel, follow the steps below.

Step 1: Select the whole row or select the first cell of the row right below the last row that you want to freeze. For instance, we want to freeze the top three rows, so we will select the A4 cell.

Step 2: Click on the View tab in the toolbar ribbon and then click on the Freeze Panes option in the Window section.

Step 3: Click on the Freeze Panes option in the dropdown menu.

Step 4: The rows above the fourth row will be frozen. You can check that by the grey line that appeared below the third row, and you can also scroll down to check.

Also read: How to insert multiple rows in Excel?


How to freeze the first column in Excel?

To freeze the first column in Excel, follow the steps below.

Step 1: Click on the View tab in the toolbar ribbon and then click on the Freeze Panes option in the Window section.

Step 2: Click on the Freeze First Column option in the dropdown menu.

Step 3: You can tell that the first column is frozen by a grey line that appeared beside it and you can scroll right to check that.

Also read: How to copy and paste on a Mac?


How to freeze multiple columns?

To freeze multiple columns in Excel, follow the steps below.

Step 1: Select the whole column or select the first cell of the column on the right of the last column that you want to freeze. For instance, we want to freeze the first two columns, so we will select the C1 cell.

Step 2: Click on the View tab in the toolbar ribbon and then click on the Freeze Panes option in the Window section.

Step 3: Click on the Freeze Panes option in the dropdown menu.

Step 4: The columns on the left side of column C will be frozen. You can check that by the grey line that appeared beside the second column, and you can also scroll right to check.

Also read: How to set directions to work and back?


How to freeze rows and columns together in Excel?

If you want to freeze the rows and columns in Excel, follow the steps below.

Step 1: Select the cell below the last row and the right to the last column you want to freeze. For instance, we want to freeze the top two rows and the first two columns to select the C3 cell.

Step 2: Click on the View tab in the toolbar ribbon and then click on the Freeze Panes option in the Window section.

Step 3: Click on the Freeze Panes option in the dropdown menu.

Step 4: The row above the third row and the columns on the left side of column C will be frozen.

Also read: How to add fonts to Canva?


How to unfreeze rows and columns in Excel?

To unfreeze the rows or columns, follow the steps below.

Step 1: Click on the View tab in the toolbar ribbon and then click on the Freeze Panes option in the Window section.

Step 2: Click on the Unfreeze Panes option in the dropdown menu.

All the frozen rows and/or columns will be unlocked.

Also read: How to group on Canva?

Akash Singh

Akash Singh

Akash is a law graduate who likes to go for bike rides on the weekends soul-searching for answers to his many existential questions. You can contact him here: singhakash95@pm.me

>