Freezing Rows

**C Holmes** · 01-06-2010, 07:28 AM

Is it possible to freeze more than one row? I have tried merging them but that seems to mess things up.

**zbor** · 01-06-2010, 07:32 AM

First several rows from the top is possible.

Just put mouse in row you want freeze from and View -> Freeze panes

**Palmetto** · 01-06-2010, 08:51 AM

Take a look at the Excel Help to understand how Freeze Panes works.

In short, it "anchors" the freeze point at the upper left corner of the active cell. So if you are in cell C20 and apply Freeze Panes, all rows above row 20 and to the left of column C will remain in view, every row and column to the right of the freeze point will be hidden or shown as you scroll.

**scaffdog845** · 01-06-2010, 03:01 PM

If you mean freezing several contiguous rows from the top down, then zbors solution works and it may be a good idea to take Palmetto's solution as well.

I do not think it is possible to freeze mutiple non contiguous rows ex. 3 & 7 &14.

**C Holmes** · 01-07-2010, 07:21 AM

OK Great, I see what I was doing wrong, I should have unfroze the top row first and then froze from the lowest point up. Thanks for the help. What would a person do without forums such as this?

**zbor** · 01-07-2010, 07:27 AM

Spend more time outdoor

Thanks for giving us feedback.
Don't forget to make thread [solved]

**scaffdog845** · 01-12-2010, 03:14 PM

As a courtesy to the group...

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].