Excel Formatting Tip 9 - Freeze Panes & Prevent Headers from Moving in the Spreadsheet in Excel

[rahulforworld]

very nice.... thank you

[orenchick]

thanks a lot!

you're a king!

[TheGiselleBella]

I thought I was insane, but I am not. My freeze pane button is not allowing me the option to use it. What have I possibly done wrong? Please help. Thanks a million

[TheGiselleBella]

@TheGiselleBella Could it be that the rows are different sizes? Ahhh, sheesh. I will figure this out.

[TheGiselleBella]

@TheGiselleBella Okeh!!! I figured it out. I am unable to use freeze pane when in workbook layout view. Thanks.

[steinernmozart]

Nice work dude . I've been searching for an explanation on freezing panes. Thanks.