Once the protection is removed, you can freeze and unfreeze panes. The first is that your worksheet is protected and wonвЂ™t allow you to make these changes.

What happens if youвЂ™re trying to lock or freeze panes in Excel and you donвЂ™t have this option? For example, you might go to View > Freeze Panes and find that the button is greyed out. If you donвЂ™t see that selection, youвЂ™ve chosen the wrong cell. If you have some locked or frozen panes that you want to unlock, you can accomplish this by reversing the procedures that we just completed.ДЇor example, you can go to the cell next to the frozen column or row, and then go to the View tab. TheyвЂ™ll always be from the top and to the left of the spreadsheet data. Remember, you canвЂ™t freeze rows and columns in the middle of a spreadsheet. This same operation will work to freeze a combination of rows and columns by choosing the cell just below and to the right of the ones that you want to freeze. First, highlight cell B2, and then go to the View tab and select Freeze Panes > Freeze Panes. Freeze Rows and Columns in Excel at the Same TimeД®xcel also allows you to simultaneously freeze the first row and column in your spreadsheet in a few simple clicks. Note: You can only freeze columns on the left side of your worksheet, not on the right or in the middle. Then, the first two columns will be locked as you scroll to the right. Then go to the View tab and choose Freeze Panes > Freeze Panes.ДЇor example, if you want to freeze the first two columns, you can highlight cell C1 to complete this operation. To do this, select the column or a cell just to the top right of the columns you wish to freeze. You can also freeze more than one column. If you want to freeze or lock the first column only, go the View tab and select Freeze Panes > Freeze First Column.ДЄfter you do this, the leftmost column in your spreadsheet will remain frozen as you scroll to the right. You can also freeze columns in Excel, and the operation is similar to the way you freeze rows. Note: Excel only allows you to freeze rows at the top of your spreadsheet and not ones in the middle. Then go the View tab and click Freeze Panes > Freeze Panes. For example, if you want to freeze the first two rows, go to cell A3. To do this, navigate to the first cell or row below the ones you want to freeze. You can also freeze multiple rows in Excel. Your top row (Row 1) will now have a grey line below it, which indicates that it has been frozen or locked. To do this, go to the View tab in Excel, and select Freeze Panes > Freeze Top Row. This way, when you scroll down through hundreds of rows, youвЂ™ll still have those headings at the top to give you the information you need. You may want to freeze the top row in Excel because it holds your column titles. Which clicks you use will depend on what you want to do вЂ“ freeze the top panes only or a group of several rows. You can freeze rows in Excel with just a few clicks. Learn the basics of freezing rows and columns in Excel to control your view of data.

How to freeze a row in excel