How to Freeze Multiple Rows in Excel 2007 and 2010

How to Freeze Multiple Rows in Excel?

In Excel, it often requires you to freeze certain rows or columns while you are working on large data sets. If you are one of those who want to learn how to freeze multiple rows in Excel then you are on the right platform.

In this guide, you will find various ways to lock rows. Along with that, you will learn to freeze columns so that when you scroll the Excel sheet, you can still view the locked content at its place. The rows and columns can be locked with the help of the Freeze Panes feature provided by Excel.

Therefore, in this guide, you are going to learn different methods on how to freeze multiple rows and columns in Excel. Apart from this, you will learn to freeze the top row, multiple rows, first column, multiple columns, and freeze both rows and columns in Excel at the same time.

Here, you will find the methods for the following versions of Excel. If you use any of these versions, you can implement the solutions mentioned in this guide.

  • How to freeze multiple rows in Excel 2007?
  • How to freeze multiple rows in Excel 2010?

How to Freeze Multiple Rows in Excel 2007 and 2010?

Excel allows you to freeze a single or multiple rows. In the following two solutions, you can learn how to freeze multiple top rows in Excel as well as the top single row. Without any delay, let jump to the solutions.

Fix 1: Freeze the Top Row in Excel

  • To lock the top row in Excel, you can go to the View tab located on the top left (menubar) of the Excel sheet.
View Tab - How to Freeze Multiple Rows in Excel
  • Next to this, you can click on the Windows group.
  • Then, you can select the Freeze Panes option.
  • Under the Freeze Panes, you can select the Freeze Top Row option.

Once you apply these actions, you will find the top low locked even when you scroll down the sheet. You can also determine that the row has been frozen as it shows a grey line below the top row.

Fix 2: Freeze Multiple Rows in Excel

  • First of all, select the row that you wish to lock. Or, you can select the first cell of the row and take it to the last row that you want to lock.
  • Then, you can click on the View option located on the top menu bar.
  • After this, you can choose the Freeze Panes option.
  • Under the Freeze Panes, you can select the Freeze Panes.

For instance, to lock the top two rows, you can select the entire row 3 or cell A3 and hit the Freeze Panes option to lock the top two rows. This will freeze the two or multiple rows in Excel even when you scroll down.

Note: In Microsoft Excel, you can only freeze the rows on the top of the sheet. It may be multiple top rows. However, you cannot freeze the row which is present in the middle of the spreadsheet.

How to Freeze Multiple Columns in Excel 2007 and 2010?

If you want to free one column or the multiple columns in the Excel sheet, you can go through the two solutions which are as follows.

Fix 1: Freeze the First Column in Excel

  • To lock the very first column, you can click on the View tab located on the top menu bar.
  • Then, you can go to Freeze Panes.
You can go to Freeze Panes - Excel How to Freeze Multiple Rows
  • Under the Freeze Panes, you can select the Freeze First Column option.

This will lock the first column of your sheet. Now whenever you scroll the sheet to the right, your first column will remain intact.

Fix 2: Freeze Multiple Columns in Excel

  • To freeze multiple columns, you need to select the columns to the right that you wish to lock. You can also select the first cell of the column and go to the last cell on the right.
  • Next to this, you can click on the View tab.
  • Then, you can select the Freeze Panes option.
  • Under the Freeze Panes, you need to select again the Freeze Pane option.

For instance, to lock the first two columns, you can select the cell C1 OR the entire column C and then click on Freeze Panes to freeze the multiple columns.

Once you apply the aforementioned actions, you will find the columns locked. With the thick line, the sheet indicates that the columns have been locked.

Note: Microsoft Excel only allows to freeze columns from the left. It can be multiple columns but not the column available in the middle of the sheet.

How to Freeze Multiple Rows and Columns in Excel 2007, 2010?

Though you have learned that in Excel, how to freeze multiple rows and columns separately. But if you want to know how to freeze multiple rows and columns in Excel at the same time, do the following.

  • To do so, select the cell till the last row and then keep on selecting the columns by going to the right. You can use the Shift key on your keyboard to select the cell in the row and then keep pressing the Shift then go to the last cell of the row. Then, keep pressing the Shift and go to the last column that you want to freeze.
  • Now, click on the View tab located on the top menu bar.
  • After this, you can click on the Free Panes.
  • Under the Freeze Panes, click on the Freeze Panes option again.

This will freeze the selected area of the row as well as the column. To make it quick, you can use this idea. For instance, to lock the top row with the first column, you can select the cell B2 and click on the Freeze Panes option.

How Can I Unlock Rows and Columns in Excel?

Besides learning how to freeze multiple rows in Excel and columns, you should also learn to unlock these frozen rows and columns. Below are the following steps that you can follow.

  • To unlock rows and columns, you can go to the View tab located on the top menu bar.
  • Then you can click on the Window group.
  • Next to this, click on the Freeze Panes.
  • As the last step, you can hit the Unfreeze Panes option.

This will unlock the frozen columns and rows in Excel.

Since all these rows and columns can be frozen by using the Freeze Panes feature by Microsoft Excel. In case, this Freeze Panes does not work or stop working, it is because of the reasons mentioned below.

  • You are probably in the cell editing mode. To exit this cell editing mode, you can use Esc or Enter key on your Keyboard.
  • Another reason could be when your sheet is protected so you need to remove the workbook protection so that you can freeze the rows and columns.

In Excel, How to Freeze Multiple Rows using Split Panes?

Freezing Panes is the convenient feature to lock rows and columns. Interestingly, Microsoft Excel provides other ways to freeze the rows and columns such as Split Panes.

Split Pane feature divides your sheet into parts that can be scrolled down separately. In other words, when you scroll down the one area the other area will remain intact. To use this feature, you can go through the following steps mentioned below.

  • First of all, select a cell to the right or below the same row where you wish to split.
  • Then, you can click on the View tab located in the top menu bar.
  • After this, you can go to select the Window group and choose the Split option.
  • You can use the Split button again if you wish to undo.
Conclusion

Freezing the rows and columns helps a lot as it keeps the content visible even when you move the sheet. If you want to learn how to freeze multiple rows in Excel, the aforementioned solutions are easy to use. This guide also covers the way to lock the multiple columns.

Apart from that, you can learn to lock both rows and columns at the same time. By unlocking the Freeze Panes, you can make your sheet normal as before.

To know more about Excel, learn with this guide on how to count characters in Excel. Besides that, you can find this curated guide with easy solutions on how to collapse rows in Excel.

0 0 vote
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments