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

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials.

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.

For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Category:

Education

Tags:

• microsoft excel 2007
• excel tips
• excel tricks
• excel guides
• excel tutorials
• excel help
• excel teacher
• spreadsheets
• worksheets
• workbooks
• formatting
• freeze panes
• header row
• visible
• always view headers
• large data set
• database

[rahulforworld]

very nice.... thank you

[orenchick]

thanks a lot!

you're a king!

[TheGiselleBella]

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

[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

[steinernmozart]

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