Help freezing multiple top rows

V

Virgo

In earlier versions, you clicked below the rows you wanted frozen in place or
to the right of the rows you wanted frozen. Now I see only how to freeze row
1.

I have a main title in row 1, row 2 is blank and row 3 has column headings,
so I want row 3 to stay frozen in place. I am having trouble accomplishing
this and need help, please. Thank you.
 
G

Gord Dibben

The freezing rule is...........

Anything above and to the left of your selected cell is frozen when you
freeze panes.

View>Freeze Panes>da da da(based on current selection)

So.............

A4 and freeze panes will freeze rows 1 to 3

B4 will freeze rows 1 to 3 and column A


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help Freezing Multiple Rows 3
Freeze multiple rows/columns in Excel 2007 7
Sorting issue with frozen panes 11
freez issues need merge help 1
How to rename the head A,B,C,D,E etc. on every column 0
Scrolling in Excel 2
Freeze Panes 5
How to create a dynamic table based on a set of other nested attributes 0

Top