Freezing Pains is a great way to keep your menus in place as you scroll through your Excel worksheet. Typically in a sheet full of data you’ll have labels at either the top row of the column, the first column in a row, or both. It can be such a pain in the a** if your scrolling through a Excel worksheet full of a data and you get down really far and you look in a different column or row and you want to know what data you’re looking at, but you have to scroll all the way back up top or all the way back to the left to find out what the label says.
Freezing pains can allow you to do that. I’m going to use a list of stock data to show you examples. In the top row are the labels for a bunch of data about the stock. In the first column is the name of the stock. There is a different stock in each row. I am going to freeze the top row, then the first column, and then I’ll show you how to freeze both.
I’m first going to freeze the top row. To do this go to the “View” tab and click the freeze pains button. Once that happens a menu will drop down showing you options for what you want to freeze.
Now it’s obvious how you freeze the first row and the first column. You simply go to the “View” tab, click the “Freeze Panes” button and on the drop down menu that appears choose “Freeze Top Row” or “Freeze First Column”. This will permanently hold the top row or the first column in place as you or someone else scrolls through your workbook.
Using the above you’ll be able to freeze only the top row or the first column NOT BOTH. In order to freeze both the top row and the first column in Excel follow the below procedure:
If your Excel worksheet is like mine where you need to freeze the top row of labels and the first column of labels then click on cell B2 (On my worksheet this is the corner below and next to where the top row of labels meets the first column of labels.) After you click on the cell below and next to where the row labels and column labels meet click the “Freeze Panes” button on the “View” tab in Excel and click “Freeze Panes” on the drop down menu. This will free both the row and the column.