PDF download Download Article PDF download Download Article

When you freeze a column or a row, it will stay visible when you're scrolling through that worksheet, which is a useful tool when you're comparing data. You can freeze a single panel or multiple panels . When you freeze columns or rows, they are referred to as "panes." This wikiHow will show you how to freeze and unfreeze panes to lock rows and columns in Excel.

Method 1
Method 1 of 3:

Freezing a Single Panel

PDF download Download Article
  1. You can either open the program within Excel by clicking File > Open , or you can right-click the file in your file explorer.
    • This will work for Windows and Macs using Excel for Office 365, Excel for the web, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007. [1]
  2. The frozen columns will remain visible when you scroll through the worksheet.
    • You can press Ctrl or Cmd as you click a cell to select more than one, or you can freeze each column individually.
    Advertisement
  3. You'll see this either in the editing ribbon above the document space or at the top of your screen.
  4. A menu will drop-down.
  5. This will freeze the panes in the columns next to what you have selected. [2]
    • You'll notice when you freeze panes if you scroll away and a column or row stays on the screen.
    • We'll show you how to unfreeze panes further down.
  6. Advertisement
Method 2
Method 2 of 3:

Freezing Multiple Panels

PDF download Download Article
  1. You can either open the program within Excel by clicking File > Open , or you can right-click the file in your file explorer.
    • This will work for Windows and Macs using Excel for Office 365, Excel for the web, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007. [3]
  2. The frozen columns will remain visible when you scroll through the worksheet.
  3. All the cells you click will be added to your selection when you have that key pressed.
    • You can release the key when you are done making your selections.
  4. You'll see this either in the editing ribbon above the document space or at the top of your screen.
  5. A menu will dropdown.
  6. This will freeze the panes in the columns next to what you have selected. [4]
    • You'll notice when you freeze panes if you scroll away and a column or row stays on the screen.
  7. Advertisement
Method 3
Method 3 of 3:

Unfreezing Panes

PDF download Download Article
  1. You can either open the program within Excel by clicking File > Open , or you can right-click the file in your file explorer.
  2. You'll see a drop-down menu.
  3. It's next to Arrange All and Split/Hide towards the right side of the toolbar.
  4. This will unfreeze all the cells that you have frozen on the screen.
  5. Advertisement

Expert Q&A

Ask a Question
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Thanks for submitting a tip for review!

      About This Article

      Article Summary X

      1. Open your project in Excel.
      2. Select cell to the right of the column you want to freeze.
      3. Click View .
      4. Click Freeze Panes .
      5. Click Freeze Panes .

      Did this summary help you?
      Thanks to all authors for creating a page that has been read 41,625 times.

      Is this article up to date?

      Advertisement