Microsoft Excel 50 Freezing and Unfreezing Panes

SimpleTutorials

Microsoft Excel is a powerful spreadsheet application used for organizing, analyzing, and visualizing data. In this course, you will learn the essential skills you need to get started and become confident in using Excel.  In this video lesson, we will learn about Freezing and Unfreezing Panes in Microsoft Excel  You can access the entire Microsoft Excel Course in the following playlist: https://www.dailymotion.com/playlist/xa9hyw

Transcript

00:00So over here you can see that I got these particular cells right here. And if I were

00:09to go ahead and scroll down and scroll to the right, you can see that the entire table actually

00:14moves. But let's say what I want to do is I want to go ahead and freeze off the first cell right

00:20here. That is the first row. In that case, I can simply go ahead right here onto View tab and then

00:26click on Freeze pane. So here if I were to select Freeze top row, then what happens is that it

00:32freezes out the top row so you can always see it. Similarly, you can go to Freeze pane and freeze

00:38the first column as well. And once you do that, you can see that it freezes out the first column

00:43right here. If I were to go around over here onto this particular cell, let's say for example,

00:48and then go to Freeze pane right here, I can go ahead and let's say for example, unfreeze it out

00:54and freeze the pane. And then what happens is that it'll take this reference point

00:58and freeze the top as you can see and freeze the right as well. So that is how you can go ahead

01:04and freeze and unfreeze out panes inside of Microsoft Excel. So I hope you found this video useful.

01:11Be sure to hit the like button. Don't forget to share this out with your friends and family.

01:16And for more contents like these, do follow simple tutorials.

Category

Transcript

Be the first to comment

Recommended