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

This Excel Video Tutorial shows you how to Freeze Panes in Excel. This allows you to keep a header row or column within the spreadsheet always visible when you are scrolling down or across the spreadsheet.

This is a great feature of Excel to use when working with large data sets, databases, employee lists, product lists, etc. where you have to do a lot of scrolling but still need to know what every column and row means and contains.


Have a great day!

[Artistramd]

I can't thank you enough. This has helped me so much. No more scrolling up and down or left and right anymore!

[steinernmozart]

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

[SassyMushu]

I've been looking for this! thank you!!

[TheGiselleBella]

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

[andersonlouis]

I thank you much as I am in the learning process

[guavaball]

thanks very much this was driving me nuts

[thebradsolution]

Judge Dredd is in charge of gift baskets HAHAHA!

[jamie]

How do you keep the first column from moving up and down as well as side to side?

[pinkspark]

thanks this was superhelpful. i just wish you'd make a shorter video... it seems like too much time was taken and too much things said to do somehting so simple :(

[TheGiselleBella]

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

[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