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:
- From the View tab, Windows Group, click the Freeze Panes drop down arrow
- Select either Freeze Top Row or Freeze First Column
- Excel inserts a thin line to show you where the frozen pane begins
To freeze several rows:
- Select the row that is immediately beneath the last row you want frozen
- From the View tab, Windows Group, click the Freeze Panes drop down and select Freeze Panes
- Excel inserts a thin line to show you where the frozen pane begins
To freeze several column:
- Select the column that's immediately to the right of the last column you want frozen
- Select the View tab, Windows Group, click the Freeze Panes drop down and select Freeze Panes
- Excel inserts a thin line to show you where the frozen pane begins
To freeze horizontal and vertical headings simultaneously:
- Select the cell in the upper-left corner of the range you want to remain scrollable
- Select View tab, Windows Group, click Freeze Panes from the menu bar
- Excel inserts two lines to indicate where the frozen panes begin
To restore the workbook to its normal view:
- 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: