By - - 0 Comments

Working with a large set of data in Microsoft Excel can be tricky. It is particularly aggravating when several columns or rows of data are similar, so you have to keep jumping back to the header to remember what you are viewing. A good solution to this is to freeze columns, rows, or both so that they stay displayed on your screen while you scroll through the rest of your data.

Big spreadsheets can easily become unwieldy, especially if the data you’re looking at is miles away from your header rows. The good news is it’s easy to freeze rows and freeze columns so that they follow you around the spreadsheet.

1. Freeze a row or column in Excel

Step 1: Open your spreadsheet in Excel.

How to Freeze and Unfreeze Rows and Columns in Excel

Step 2: Now, you have to select the row(s) or column(s) you want to freeze and make sure that you select the entire line of cells by clicking on the column or row name at the side of the spreadsheet.

How to Freeze and Unfreeze Rows and Columns in Excel

How to Freeze and Unfreeze Rows and Columns in Excel

Step 3: After selecting the row or column, you have to click on the View tab and tap on Freeze Panes option.

How to Freeze and Unfreeze Rows and Columns in Excel

Step 4: Lastly, you have to click on Freeze Panes option. If the row or column you want to freeze is the first in the spreadsheet you can alternatively choose Freeze Top Row or Freeze First Column.

How to Freeze and Unfreeze Rows and Columns in Excel

Note: To unfreeze the rows or columns, you just simply have to go to View option and then click on “Freeze Panes” button and tap on “unfreeze panes”. 

How to Freeze and Unfreeze Rows and Columns in Excel

2. Freeze both rows and columns

Step 1: Open your spreadsheet in Excel.

Step 2: Now, you have to select both the row(s) and column(s) you want to freeze by pressing Ctrl button and then click the row and column you want to freeze in the spreadsheet.

How to Freeze and Unfreeze Rows and Columns in Excel

Step 3: After you are done with selecting both the rows and columns, you simply have to click on the View tab and tap on Freeze Panes option.

How to Freeze and Unfreeze Rows and Columns in Excel

Step 4: Lastly, you have to click on Freeze Panes option. If the row and column you want to freeze are the first in the spreadsheet you can alternatively choose Freeze Top Row or Freeze First Column.

How to Freeze and Unfreeze Rows and Columns in Excel

That’s it! This is how you are going to Freeze and Unfreeze Rows and Columns in Excel. In case of any queries or doubts, kindly comment down below and we’ll get back to you asap.