Freezing rows

[Jack-P-Winner]

I have 4 cells I would like to freeze on several sheets in a book. Is there a way to freeze them if they are not on row 1? They are cells C1 D1 E1 F1 or I would like to freeze all of row 2. I am using Office 2010 and/or 2013

Thanks

 

[Hui]

Jack

"Is there a way to freeze them if they are not on row 1? They are cells C1 D1 E1 F1"

As C1:F1 will never be on row 2?

Can you please explain what you want as it is ambiguous ?

 

[Jack-P-Winner]

UG. So sorry Hui, I need sleep lol I'm trying to freeze row 2

 

[Hui]

based on what ?

 

[Jack-P-Winner]

Based on what what? I want to freeze the entire row from moving and keep it on top or on the 2nd row. That's what freezing as row means

 

[Hui]

Select A3
Goto the View, Freeze panes Tab
Freeze panes