print friendly version

Questions and answers

760
How do I freeze/fix column or row headings in Excel?


Excel 2013 and Excel 2010

When you work with a large Excel worksheet, it's often difficult to remember exactly what kind of data, columns or rows contain once you begin scrolling around the sheet.

 To freeze the top row or first column:

  1. From the View tab, Windows Group, click the Freeze Panes drop down arrow
  2. Select either Freeze Top Row or Freeze First Column
  3. Excel inserts a thin line to show you where the frozen pane begins

To freeze several rows:

  1. Select the row that is immediately beneath the last row you want frozen
  2. From the View tab, Windows Group, click the Freeze Panes drop down and select Freeze Panes
  3. Excel inserts a thin line to show you where the frozen pane begins

 To freeze several column:

  1. Select the column that's immediately to the right of the last column you want frozen
  2. Select the View tab, Windows Group, click the Freeze Panes drop down and select Freeze Panes
  3. Excel inserts a thin line to show you where the frozen pane begins

 To freeze horizontal and vertical headings simultaneously:

  1. Select the cell in the upper-left corner of the range you want to remain scrollable
  2. Select View tab, Windows Group, click Freeze Panes from the menu bar
  3. Excel inserts two lines to indicate where the frozen panes begin

To restore the workbook to its normal view:

  1. Select View tab, Windows Group, click Freeze Panes and select Unfreeze Panes

 

Help us to improve this answer

Please suggest an improvement
(login needed, link opens in new window)

Your views are welcome and will help other readers of this page.

Categories

This is question number 760, which appears in the following categories:

Created by Jason Bailey on 27 July 2001 and last updated by Alexander Butler on 17 July 2018