Freeze Panes

One feature of Excel that many people are still unsure of how to use is Freeze Panes. This allows a user to lock a particular row or column in place, so that the information contained within that row or column is constantly displayed on the screen when scrolling across or down the page. It sounds simple enough, but actually knowing where it is located and how to use it is the trick.

So how exactly does this help someone? Let’s find out:

More →