• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 18121
  • Last Modified:

How to freeze 2nd and 3rd row in excel sheet.

I'm using Microsoft Office Excel 2007.  How do I freeze 2nd and 3rd row?  As scroll down the sheet, I need 2nd and 3rd row to be visible.
3 Solutions
Select forth row then on the view tab find freeze pane and click freeze
Go to Cell  C1, and select Freeze Frames on View menu
Rob HensonFinance AnalystCommented:
I don't believe you can freeze just 2nd and 3rd but you can freeze 1st, 2nd and 3rd.

Put cursor into cell A4 and then choose View tab on Ribbon and then Freeze Panes. The dropdown gives 3 options, choose Freeze top row. Eventhough this suggest that only top row will freeze because the cursor is in row 4, rows 1 to 3 will freeze.

Rob H
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now