#FREEZE TOP ROWS IN EXCEL HOW TO#
You will also see how to freeze several panes at a time to make Excel always show certain rows or/and columns when you scroll down or right. You will learn how to quickly lock header row or/and the first column. Your first session is always free.The tutorial demonstrates quick ways to freeze panes in Excel. Were you able to find the information you needed relative to freezing rows and columns in Excel? If you learn better with one-on-one help or need to troubleshoot an issue in Excel, our program experts can lend a hand.Įxcelchat has knowledgeable, friendly, and experienced live help standing by that can teach you about Excel or help you with a problem-specific issue. The quickest way to create a table in Excel is hitting Ctrl-T. This keeps your top row fixed so that it remains visible while scrolling. You can also use a table to lock the top row in Excel. To undo the operation, choose Split again. Navigate to the View tab and choose Split under the Window group. To do this, go the right of the column or row that you want to split. When you split panes, it divides your window into multiple areas that can be scrolled separately, with other parts of your spreadsheet remaining stationary. The first is to split panes instead of freezing them. In addition to freezing panes, Excel gives you a few other options to lock different areas of your worksheet.
Other Ways to Lock Rows and Columns in Excel Just hit the Esc or Enter key to get it out of editing mode and try again. The other is that your cell is in editing mode. 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.