Freezing Paints in Excel is an easy way to keep interviews certain columns or certain rows while you're working or why you're analyzing your Excel workbook. It’s pretty easy to do this. You just click on view. And then in the window section, you're got to see a section called freeze paints. Okay, go ahead and click on that and let’s look at the last options first. If you go freeze on top row, it’s going to automatically freeze your top row, and you can see there’s a black line, meaning that the top line has been frozen and you could see how it works if you scroll down. Then it’s going to click tip that first row into view or you're looking at your other data in your workbook. Okay, if you want to unfreeze your paint, just click on freeze paints again and click on unfreeze paints. Let’s look at another option, click on freeze paints and you can go to freeze first column, and it’s going to free your first column. Once again, you can see you can scroll over, and it’s going to keep that first column in view. Let’s go ahead and take that off, unfreeze paints.
Now if you want to set custom paints that you want to be frozen or if you want to set multiple rows and columns to be frozen at the same time, you would have to do that manually. What you want to do is you want to click to the bottom of the row that you want frozen and to the right of the column that you want frozen. So if you want to freeze your top row, and your first column, you click in B2. So underneath, the row you want frozen and to the right of the column you want frozen. Make sure that cell is selected, go to freeze paints and click on your first option freeze paints. You can see, you have your black lines and it froze your first row, and your first column. You can scroll and see how that works. To unfreeze your paints, click on freeze paints, and unfreeze paints
Transcription by:
Scribe4you Transcription Services