You need to freeze rows or columns in Excel but don’t know how to do it? In this article, we will guide you through how to freeze rows and columns in Excel fully and in detail.
Nội dung
1. How to freeze rows in Excel
- 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!
-730x400.jpg "A dark border appears, meaning you have successfully frozen the line.")
A dark border appears, meaning you have successfully frozen the line.
- 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.
-730x400.jpg "Fixed lines will be marked with a black line.")
Fixed lines will be marked with a black line.
2. How to freeze columns in Excel
- 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.
-730x400.jpg "The fixed column will be marked with a bold line.")
The fixed column will be marked with a bold line.
- 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.
-730x400.jpg "Fixed columns will appear in bold.")
Fixed columns will appear in bold.
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!
-730x400.jpg "When you successfully freeze, a dark border will be on the right just below the columns")
When you successfully freeze, a dark border will be on the right just below the columns
4. Freeze multiple areas in Excel
- Step 1: To freeze multiple rows and columns at once, select the cell to the right of the last column and below the last row you want to freeze.
- Step 2: Click the View tab and Freeze panes below the Freeze panes button to freeze the area.
-730x400.jpg "Select a cell below the last row and to the right of the last column you want to lock to freeze a region.")
Select a cell below the last row and to the right of the last column you want to lock to freeze a region.
5. How to unfreeze columns and rows
To unfreeze rows or columns in Excel, go to View > Freeze Panes > Unfreeze Panes .
-730x311.jpg "Go to View > Freeze Panes > Unfreeze Panes to unfreeze")
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.
Cause: The cells you want to freeze are not within the display range, resulting in selecting the wrong cell.
For example: You just want to fix these 2 lines:
(1)-730x311.jpg "Select the correct cell you want to freeze")
Select the correct cell you want to freeze
(2)-730x311.jpg "The cells you want to freeze are not within the visible range.")
The cells you want to freeze are not within the visible range.
And the result after fixing is a series of unnecessary lines are also fixed.
(3)-730x311.jpg "Fixed error")
How to fix:
- Step 1: Select View > Freeze Panes > Unfreeze Panes to delete the old, faulty pane.
- Step 2: Scroll up until you see all the cells and columns you want to freeze, then freeze them as instructed above.
(4)-730x311.jpg "Make sure that all rows and columns that you want to lock are in view.")
Make sure that all rows and columns that you want to lock are in view.
In this case, save the file, close it and reopen it and the file will work normally. This is a fairly common error so just restart it and it will work normally.
(6)-730x311.jpg "Please close and reopen the file for the tool to work normally.")
Please close and reopen the file for the tool to work normally.
In this case, let’s switch to the Table feature. You highlight all the content you want to fix. Then press Ctrl + T to convert the spreadsheet to Table format. At this time, the title of the table will appear on the title bar for you to easily follow.
(5)-730x311.jpg "The spreadsheet title will appear on the title bar.")
Here is a simple and detailed guide to freezing rows and columns in Excel for all versions. If you have any questions about the process, feel free to leave a comment below. I hope this article will be helpful to you. Wishing you success!
See more: Instructions on how to merge multiple sheets in Excel