Summary: Use the freeze pane command in Excel to create static headings by highlighting the targeted row, going to window on the menu and selecting freeze panes. Use the freeze pane command in Excel to create static headings with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Amar Enhsaihan is an assistant certified public accountant (CPA) and works with Excel applications everyday on his job.read more
"Hi, I'm Amar Enhsaihan, and I'm going to show you how to use freeze pant command to create static headings. So, here's my example, and I have a header here, special rates, and then I have first, second, third, fourth year, so this is a header too. So, let's say I want to keep rows one to four static and be able to scroll down and see other information. So, I'm going to highlight that row below what I want to be static and then go to window, freeze panes, and it worked. So, if you'll now scroll, you'll see that ones one to four are static. This is especially helpful, if you have thousands and thousands of rows where you want to keep track of, then you just freeze the headers and then scroll down to wherever, to look up information. And, this is how you use freeze pane to create static headings. I'm Amar Enhsaihan, thank you for watching!"
eHow Article: How to Use the Freeze Pane Command in Excel to Create Static Headings