Grab your jacket, we are freezing our panes - Microsoft Excel Tutorial

- Burr, it's getting a little cold out here. Grab your jackets 'cause we are about to be freezing our panes. So as you can see here in row one and two we have our titles in our column headings respectively. Now watch what happens if we scroll down on our screen we can no longer see our title and our column headings. So let's say we want to lock those into place so when we're scrolling, we will always have those up at the top. We can do this with the pane freezing tool in Excel. So the first thing we do to freeze our panes is we are going to highlight one row below the area we wish to freeze. So in this case, I'm going to highlight row three and navigate to my View ribbon. And in the window segment, we have the Freeze Panes button. Now there are three different options here. The first one is freeze your panes, which is the one we'll be using. The second one is freeze top row. And the third one is freeze first column. So depending on how your data set up one of these options may work best for you. However, in our case, we got a custom order. So we are going to click on the Freeze Panes button in order to freeze both row one and row two. And now to test it out, simply scroll down and notice how those two top rows stay locked in place for us. This is a great technique to use if you have a complicated spreadsheet with a ton of different row or column headings that you would like to keep visible at all times and have your data be more easily navigated you can go in and add in those frozen panes.