00:00In this short Microsoft Excel tutorial, I want to show you a tool called Freeze Panes and I want to
00:06illustrate for you how it's useful.
00:08And to do so, I have a simple spreadsheet here. It's basically just a list of synth pop bands and
00:13their recent albums.
00:14And there's some other information here as well.
00:16But notice as I browse down the page, it's easy for me to lose track of what each of these
00:22columns represents.
00:23Because my column titles, band, album, genre, price, sales, that all gets lost as I browse down the page.
00:31Now this is just a list of 30 records or so.
00:33But imagine what if I had a spreadsheet with thousands of records, thousands of rows, or even just hundreds of
00:40rows.
00:41It would be very easy to get confused about what does this number one represent?
00:46What does 20 represent? What does it mean?
00:49And that's where the Freeze Panes tool comes in very handy.
00:52Basically, what it allows me to do is it makes it so that I can freeze row number one, for
00:58example,
00:59so that it stays there at the top of the screen and doesn't disappear and go away.
01:04So as I browse down the page, I would always be able to see row number one.
01:08Let's look at how to activate Freeze Panes.
01:10There are basically two different ways you can do it.
01:12The classic, old-fashioned way to do it would be to click on the row underneath the row that you
01:18want to freeze.
01:19So I clicked on row number two, it highlighted the entire row, and now I can go up to the
01:23View tab,
01:24and notice there's Freeze Panes.
01:27I just click on that and choose Freeze Panes.
01:30It doesn't look like anything happened.
01:32But now, watch, as I browse down the page, row number one stays at the top.
01:37So I always know what the numbers mean and what the text means.
01:41So that's the classic way to activate Freeze Panes, and it doesn't have to always be this top row.
01:47Okay, I'm going to Unfreeze Panes, and I could choose, if I wanted to, to freeze rows one through 17.
01:54In order to do that, I just click on row 18, go up to Freeze Panes, Freeze Panes.
01:59Now, the first 17 rows are all frozen.
02:02Okay, so like I said, that's the classic, old-fashioned way of doing Freeze Panes.
02:07The newer method is simply to not worry about what column you're in, about what row you're in, or what
02:14cell is selected,
02:15but simply to go up here to Freeze Panes and choose Freeze Top Row.
02:20So this way, you don't even have to worry about which row should I select, or anything like that.
02:25You simply go up to Freeze Panes and choose Freeze Top Row.
02:29And it has the exact same effect as if you had done it the old-fashioned way.
02:33Notice that there is also an option to freeze the first column.
02:36If you choose that, then the column at the far left stays visible, no matter how far to the right
02:42you go.
02:43So I hope you find Freeze Panes to be helpful, and I hope that you found this video to be
02:47helpful.
02:47If you have, please click the Like button below, and consider connecting with me on my social media websites,
02:52like Twitter, Facebook, and Pinterest.
02:54And definitely do subscribe to my YouTube channel for more videos about technology for teachers and students,
03:00and watch for another video from me at least every Monday.
03:03And if you're interested, check out these bands by looking in the description below.
03:07You'll find links to more information about them.
03:10J.
03:10J.
03:10J.
03:10J.
Comments