Freezing Panes in Excel

Learn how to freeze panes in Excel – Columns, Rows, and both columns and rows.

Freezing Panes

Working with large spreadsheets can become unmanageable very quickly.  Trying to enter data in rows or columns is impossible when the headings disappear off the screen as you can easily enter data into the wrong cells.  Event trying to review the data can become very cumbersome.  The ability to freeze rows and/or columns allows you to efficiently enter data into large spreadsheets without having to continually scroll to the headings to ensure you are in the right cells.  It also allows you to hone into specific data quickly.  Below are the step-by-step instructions for freezing rows, columns, and both rows and columns.

To keep an area of a worksheet visible while you scroll, you can freeze specific rows or columns and/or lock them in place.  NOTE:  You can only freeze rows at the top and columns on the left side of the worksheet.  You cannot freeze rows and columns in the middle of the worksheet.

Freezing Rows
  1. Select the row below the row or rows you need to keep visible when scrolling.
  2. Click the View tab.
  3. Click the down arrow on Freeze Panes in the Window group.VLBTechEd Excel Panes Image 1
  4. Click Freeze Panes.
Freezing Specific Columns
  1. Select the column to the right of the column or columns you want to keep visible when you scroll.
  2. Click the View tab.
  3. Click the down arrow on Freeze Panes in the Window group.VLBTechEd Excel Panes Image 1
  4. Click Freeze Panes.
Freezing Both Columns and Rows
  1. Select the cell below and to the right of the rows and columns that you want to keep visible when you scroll.
  2. Click the View tab.
  3. Click the down arrow on the Freeze Panes in the Window group.VLBTechEd Excel Panes Image 1
  4. Click Freeze Panes.
Unfreezing Selection
  1. Click the View tab.
  2. Click the down arrow on Freeze Panes in the Window group.VLBTechEd Excel Panes Image 2
  3. Click Unfreeze Panes.

To learn more about Office applications, please check out my courses at vlbteched.teachable.com.

Leave a Reply

Your email address will not be published. Required fields are marked *