Rows to repeat at top


L

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
 
Ad

Advertisements

T

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.
 
G

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
 
Ad

Advertisements

L

LAS

Thanks much.

Gord Dibben said:
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
 

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

Top