While working with larger spreadsheets, you will need to know how to freeze cells in Excel. You do not need to scroll up and down repeatedly, instead just freeze the cells to compare the header information with the rest of the rows quickly. So, here, we explain you the technique to freeze cells in Excel.

Note: In this guide, we have utilized Microsoft Office Professional Plus 2016 edition. The steps to freeze the cells would remain the same dated back to Excel’s 2010 version.

1. The Top Row – Freeze Cells In Excel

If you are sure that you want to freeze the topmost row in the spreadsheet, here’s what you need to do:

Steps To Freeze Top Row In Excel

  1. Open the desired spreadsheet in Excel.
  2. Simply, navigate to the “View” tab on the menu bar.
    freeze cells in excel
  3. Now, you will observe an option which says – “Freeze Panes” on it. Simply, click on it to view more options.
    freeze cells in excel
  4. Finally, from the options listed, you need to select “Freeze Top Row” in order to freeze the topmost row of your excel sheet.

2. The First Column – Freeze Cells In Excel

Similar to the previous procedure, if you need to freeze the first colum of the excel sheet, you need to follow the steps mentioned below.

Steps To Freeze The First Column In Excel

  1. Open the desired spreadsheet in Excel.
  2. Simply, navigate to the “View” tab on the menu bar.
    freeze cells in excel
  3. Now, you will observe an option which says – “Freeze Panes” on it. Simply, click on it to view more options.
    freeze cells in excel
  4. Finally, from the options listed, you need to select “Freeze First Column” in order to freeze the first column of your excel sheet.

3. Desired Row – Freeze Cells in Excel

Prior to freezing the cells, in this case, you need to first select the entire row. Here’s how you can freeze a complete row:

Steps To Freeze The Selected Row In Excel

  1. Open the desired spreadsheet in Excel.
  2. First of all, you need to select the row you need to freeze. In order to select the entire row, you need to click on the row number (mentioned to the left of each row).
    freeze cells in excel
  3. Simply, navigate to the “View” tab on the menu bar.
    freeze cells in excel
  4. Now, you will observe an option which says – “Freeze Panes” on it. Simply, click on it to view more options.
    freeze cells in excel
  5. Finally, from the options listed, you need to select “Freeze Panes” in order to freeze the row you selected previously.

4. Desired Column – Freeze Cells In Excel

In this case, each of the steps mentioned above will exactly be the same. Except, you need to select an entire column to freeze instead of a row.

Did the above mentioned steps work out for you? Do you know a better way (quicker) to freeze cells in Excel?

Let us know your thoughts in the comments section below.

Filed in Computers. Read more about Microsoft and microsoft office.

User Comments