Rows to repeat at top

[LAS]

I was trying to find "freeze panes" and stumbled on Page Layout/Sheet/Rows
to repeat at top and Columns ro repeat at left. I tried putting in
numbers for rows, "1", "1-2", "1,2". None are valid. What do you enter
there, and does it perform the same function as Freeze Panes?

Also, I'm running Excel 2007. Where do I find "freeze panes?"

TIA
LAS

 

[trip_to_tokyo]

I was trying to find "freeze panes" and stumbled on Page Layout/Sheet/Rows
to repeat at top   and Columns ro repeat at left.  I tried putting in
numbers for rows, "1",  "1-2",  "1,2".  None are valid.  What do you enter
there, and does it perform the same function as Freeze Panes?

Also, I'm running Excel 2007.  Where do I find "freeze panes?"

TIA
LAS

Also, I'm running Excel 2007. Where do I find "freeze panes?

View tab / Window group

If my comments have helped please, if possible, rate my posting.

Thanks.

 

[Gord Dibben]

Rows to repeat at top is a Print only command.

Proper syntax is 1:1 or 1:2, 1:3

Not the same as freeze panes which is a window function.

Freeze Panes found under View>Window category.


Gord Dibben MS Excel MVP

 

[LAS]

Thanks much.

Rows to repeat at top is a Print only command.

Proper syntax is 1:1 or 1:2, 1:3

Not the same as freeze panes which is a window function.

Freeze Panes found under View>Window category.


Gord Dibben MS Excel MVP