Do you need to freeze rows or columns in Excel but don’t know how to do it, or do you encounter some errors when doing it? In this article, we will guide you on how to freeze rows and columns in Excel fully and in detail, and how to fix some common errors. Follow along.
Nội dung
1. How to freeze rows in Excel
Freeze the Top Row
Step 1: Select any cell in the spreadsheet sheet > Go to View > Freeze Panes > Freeze Top Row.
Step 2: You can see that the frozen row will be marked with a black line, darker than the lines of other rows right below the locked data cell. So your frozen operation has been successful!
Freeze Multiple Rows
Step 1: Identify the group of rows that need to be frozen, then select the first cell of the row below the group of rows that need to be frozen. For example, to freeze the first two rows in the table below, you need to select cell A3 .
Step 2: Select the View tab > Freeze Panes > Freeze Panes. Similarly, the frozen rows will be marked with a black line, darker than the lines of other rows, right below the locked data cell.
2. How to freeze columns in Excel
Freeze the first column
Step 1: Select any cell in the spreadsheet sheet > Go to View > Freeze Panes > Freeze First Column.
Step 2: The fixed column will be marked with a line that is darker than the lines of other rows and columns.
Freeze multiple columns
Step 1: Identify the group of columns that need to be fixed, then select the cell in the first row of the column to the right of the group of columns that need to be fixed. For example, to fix the first 2 columns in the table below, you need to select cell C3 .
Step 2: Select View > Freeze Panes > Freeze Panes. The frozen columns will be marked with a line that is darker than the lines of other rows and columns.
3. Freeze multiple rows and columns
Excel allows you to freeze rows and columns in a snap with a few simple steps:
Step 1: Identify the rows and columns you want to freeze, then select the box below the last row and to the right of the last column you want to freeze.
For example: You need to fix the first 2 columns, and at the same time want to fix the first 2 rows of the table below, then what you need to do is select cell C3 , which is the cell below the last row and to the right of the last column of the rows and columns you want to fix.
Step 2: Select the View tab > Freeze Panes > Freeze Panes. After performing the above operation, if a dark border appears on the right and right below the columns and rows you want to freeze, then you have succeeded!
4. How to unfreeze columns and rows
To unfreeze rows or columns in Excel, go to View > Freeze Panes > Unfreeze Panes .
Go to View > Freeze Panes > Unfreeze Panes to unfreeze
Note :
- Unfreezing a row or column will return all the rows and columns you froze to their normal state. You will need to refreeze the rows and columns as you wish after performing the unfreeze command.
- The Unfreeze Panes command appears only when you have frozen columns or rows on a worksheet.
As we know, the Freeze Panes function in Excel will help fix rows and columns in a Sheet. However, using this function sometimes creates “errors” that confuse us. Let’s learn about common errors when fixing rows and columns in Excel and how to fix them with Excel Online Learning.
If you do not know how to use the Freeze Panes tool to freeze rows and columns in a spreadsheet, you can review the article:
5.1 Tools in the Freeze Panes function group are not displayed
Status
Cannot click on Freeze Panes in the View tab, or click but the Freeze Panes function window does not appear
How to fix
- Method 1 : Save the file > Close the file > Reopen the file to work normally. This error sometimes occurs while running the Microsoft Excel application. We can restart the application to avoid the error.
- Method 2 : Call the Freeze Panes / Unfreeze Panes tool out of the toolbar by using the Customize the Ribbon operation. When bringing this tool out, we can use it directly without having to open the Freeze Panes tool group anymore.
5.2 Freeze Panes function not working as expected
Status
In a data table where the header is located in a position other than row 1, for example row 6. When fixed with Freeze Panes, all rows from 1 to 6 are fixed. Meanwhile, we only want to fix row 6 when viewing the content below, but not hide rows from 1 to 5. In this case, Freeze Panes does not meet the requirement.How to fix
In this case, Freeze Panes cannot be used. Instead, we will use Table. Here’s how:
- Select the entire data table. You can select more than the number of rows in the table to accommodate additional content.
- Press the Ctrl and T key combination (Ctrl + T) to convert the data table to Table format in Excel.
- When converting to Table mode, the table title will always be displayed on the title bar, instead of column names A, B, C, D.
Status:
You want to freeze a row but there are other hidden rows above it. As a result, when you freeze a row, the hidden rows will also be frozen, and you do not want this.
How to fix:
Step 1: Unhide all rows above the row you want to freeze: Before freezing, make sure all rows above that row are visible. This helps you control and remove unwanted rows from the freeze range.
Step 2: Insert a temporary row above the row you want to freeze (if necessary): If you don’t want to change the status of hidden rows, add a temporary row above the row you want to freeze.
Step 3: Proceed to freeze the desired row: After completing the above steps, you freeze the row as usual:
Select the cell immediately below the row you want to freeze.
Go to the View tab > Select Freeze Panes > Freeze Panes.
Step 4: Hide unwanted rows again (if necessary): After freezing, you can hide the rows above if you don’t want to display them.
Step 5: Delete temporary row (if used): If you have inserted a temporary row, you can delete it after successfully freezing it.
Above is a simple and detailed guide on how to freeze rows and columns in Excel for all versions. If you have any questions about the process, please leave a comment below. I hope this article is helpful to you. Good luck!
See at: Freeze panes to lock rows and columns
See more: Instructions on how to merge multiple sheets in Excel