Excel: Freeze Panes in Spreadsheets

Cedarville's Center for Biblical and Theological Studies glowing in the evening light

Cedarville University

Excel: Freeze Panes in Spreadsheets

The Excel Freeze Panes tool allows you to lock your column and/or row headings so that, when you scroll down or over to view the rest of your sheet, the first column and/or top row remain on the screen. The following steps show you how to use freeze panes in Excel 2016, 2013, 2010, or 2007. 

To Use Freeze Panes:

  1. Open your document.
  2. Click the [View] tab > From the "Workbook Views" group, click [Normal], if not already selected. 
  3. From the "Window" group, click [Freeze Panes]. 
  4. Choose from the following options:
    • Freeze Panes: Lock more than one column or row (select the row below the last row you want to freeze and/or to the right of the last column you want to freeze).
    • Freeze Top Row: Only lock the top row.
    • Freeze First Column: Only lock the first column. 

Keywords: freeze cells, cells in place, office 2010, repeat column headings, repeat headings

Email this to a Friend

Help Page Feedback

Did this content help you? *

What is your opinion about the content? *

Suggest new content or let us know how we can improve this content (optional):

If you desire a response, please provide your email address (optional):

Leave this field empty