How to Freeze Rows And Columns In Excel

H

Wondering how to freeze rows and columns in Excel? Well, this is how easy it is.

Microsoft Excel is used for big and complex tasks that includes data filtering, analyzing and calculating data of companies of all sizes. It is challenging to keep track of everything while you are working on data this gigantic.

You can compare one or two rows of information but when you have to do the same with dozens of rows, it becomes a very complex and confusing task that can easily make you do several mistakes without you knowing. And this is just about rows, when it comes to columns, the task is even more difficult.

But thanks to MS Excel as it gives us one of the best features that let you do this complex and unmanageable task in a simple way: freeing the rows and columns. 

Freezing columns and rows makes navigation much easier and the work process faster. By using this feature, you can choose panes and lock them which means only those specific rows and columns will be visible. The best part is that Excel does not limit the number of rows and columns that can be frozen. You can freeze as many as you want as you work on a big spreadsheet. 

Let us now learn how you can freeze rows and columns and everything around this amazing feature of MS Excel.

How To Freeze Rows or Columns In Excel

Freeze the First Column

  1. Select View. Choose Freeze Panes and Freeze First Column.
  2. The faint line that appears between Columns A and B shows that the first column is frozen.

Freeze the First two Columns

  1. Select the third column.
  2. Select View, Freeze Panes and then select Freeze Panes.

Freeze Columns and Rows

  1. Select the cell below the rows and to the right of the columns, you want to keep visible when you scroll.
  2. Select View > Freeze Panes > Freeze Panes.

How To Freeze Top Row In Excel

To freeze or lock the top row in Excel, go to the View tab, select Window Group and then click Freeze Panes followed by Freeze Top Row.

This is how you can easily lock the first row in any worksheet to make it visible throughout the navigation on the rest of the worksheet.

Freeze top row in Excel

The grey line below the selected frozen cell determines whether it is frozen or blocked. Refer to the picture below:

Top row is frozen.

How To Freeze Multiple Rows In Excel

In the case of big data and you want to freeze multiple rows in Excel, you can follow these steps:

  1. Select the row (or the first cell in the row) right below the last row you want to freeze.
  2. On the View tab, click Freeze Panes > Freeze Panes.

For instance, if you want to freeze the top two rows in Excel, select cell A3 or the entire row 3, and click Freeze Panes:

Freezing multiple rows in Excel

Now you’ll be able to view the frozen cells in the first two rows while you scroll through the sheet content.

The first two rows are frozen.

Notes:

  • You cannot lock or freeze rows that are in the middle of the worksheet. You can only freeze rows at the top of the spreadsheet. 
  • While blocking the rows, make sure all of them are visible. In case some of them are not, those rows will be hidden after freezing. 

How To Freeze Columns In Excel

You can freeze columns in Microsoft Excel in a similar way by using the Freeze pans commands. 

How To Lock The First Column In Excel

To freeze the first column in a sheet, click on the View tab > Select Freeze Panes > Click on Freeze First Column.

With these steps, you can make the left-most column visible at all times as you scroll to the right.

Freeze the first column in Excel.

Also Read
How to add row and column in Excel
How to compare two columns in Excel

How To Freeze Multiple Columns In Excel

If you want to freeze more than one column, here are the steps for the same:

  1. Select the column (or the first cell in the column) to the right of the last column you want to lock.
  2. Go to the View tab, click Freeze Panes, and select freezer Panes.

For instance, to freeze the first two columns, select the whole column C or cell C1, and click Freeze Panes:

Freezing multiple columns in Excel

This way you will lock the first two columns which will be indicated by the darker and thicker border which would also enable you to see the cells in frozen columns.

The first two columns are frozen.

Notes:

Columns in the middle of the excel sheet cannot be frozen. You can only freeze columns on the left side of the sheet. 

All the columns to be locked should be visible, any columns that are out of view will be hidden after freezing.

How To Freeze Rows And Columns In Excel Together

Not just freezing rows and columns separately, you can also freeze them at the same time and here is how you can do it:

  1. Select a cell below the last row and to the right of the last column, you’d like to freeze.
  2. On the View tab, click Freeze Panes and then click Freeze Panes.

And it is done! Yes, it is this simple.

Let us look at an example, to freeze the first column and top row in a single step, select cell B2 and select Freeze Panes:

Freezing top row and first column in Excel.

By doing this, your leftmost column and header row will always be viewable as you scroll on the worksheet. 

Top row and first column are locked.

Similarly, you can freeze as many rows and columns as you want. You just have to start with the top row and leftmost column. 

Let us take a look at another example: to lock the top row and the first 2 columns, you select cell C2; to freeze the first two rows and the first two columns, you select C3, and so on.

Also Read

How to split cells in Excel

How to protect cells in Excel

How To Unlock Rows And Columns In Excel

We have learnt to freeze rows and columns. Now let us learn how to unlock frozen rows and/or columns, go to the View tab, Window group, click Freeze Panes and select Unfreeze Panes.

Unlock frozen rows and columns in Excel.

Freeze Panes Not Working

In case your Freeze Panes button is not working or is disabled (greyed out) in the worksheet it can be because of the following reasons:

  • Check if you are in cell editing mode. To exit the editing mode, press Enter or Esc key.
  • Or
  • Your worksheet is protected. You must remove the workbook protection and start freezing columns and rows. 

How To Unfreeze Rows or Columns

On the View tab,> Click Window > Select Unfreeze Panes.

Unfreeze Panes

Other Ways To Lock Columns And Rows In Excel

You can also lock certain areas in a sheet apart from freezing panes. 

Split panes instead of freezing panes

You can split a worksheet area into several parts. The difference between the two is:

Freezing panes let you keep certain rows or/and columns visible when scrolling across the worksheet.

Splitting panes divide the Excel window into two or four areas that you can scroll separately. As you scroll within one area, the cells in the other area(s) remain fixed.

Splitting panes in Excel

To split Excel’s window, select a cell below the row or to the right of the column, click the Split button on the View tab > and then select Window group. To undo a split, click the Split button again.

Use Tables To Lock The Top Row In Excel

To permanently make the header row fixed at the top, convert a range to a fully-functional Excel table. 

You can do so by pressing the Ctrl + T shortcut. 

Create a table to lock top row in Excel.

conclusion

MS Excel is a Microsoft software program that uses spreadsheets to organize numbers and data using formulas and functions. MS Excel can be used by ordinary people for simple tasks such as average determination and pivot table use, as well as more complex ones such as the VLOOKUP function and concatenation in Excel.

EasySheet is a tech blog that features incredible Excel hacks, tips, and tricks. Our goal with the EasySheet is to help beginners learn Excel and find answers to all of their questions.

We are the best place to go for anyone who needs assistance with Microsoft Office applications such as Excel, Word, PowerPoint, Publisher, and more!

About the author

Gaurav Singh Rawat

Add comment