Why is it necessary to fix lines in Excel. For those who often work with excel files with a large number of records, it is impossible not to use it. The following article details how to fix columns and rows in Excel 2013.
1. Fixed line
Note: It is important to fix the row or the column to determine the position of the mouse cursor.
Step 1: Locate the cursor position.
Place the mouse cursor in the first cell of the line below the line to be fixed. Note: the lines before the cursor line are fixed.
Step 2: Select View -> Freeze Panes .
For example: Fixed row 1 and row 2 => place the cursor in the 3rd row of the 1st cell. So when you move to the nth record with very large n, row 1 and row 2 are still displayed. and fixed on top.
Compare the results: Lines 1 and 2 are fixed. When you drag the mouse down on the 15th and 16th rows, the column headings and column properties are still displayed.
Note: You can choose to freeze the first row by clicking Freeze Top Row .
2. Fixed columns
- Step 1: There are 2 ways to locate the mouse cursor.
+ Method 1: You place the cursor at the first cell position of the column after the frozen column (For example, fix the nth column, then place the mouse cursor in the first cell of the nth column + 1). Freeze the STT column to place the mouse pointer in the cell (B, 2).
Note: The columns in front of the mouse cursor column are fixed.
+ Method 2: Highlight the entire column after the column is fixed.
Eg fixed column No. I blacked columns Full .
- Step 2: Select View -> Freeze Panes .
Let's compare the results: When we drag the column They are obscured but the STT column remains fixed and is displayed on top.
Note: If you want to fix the first column instead of choosing Freeze Panes -> Freeze First Column .
3. Freeze both rows and columns
- Step 1: Determine the position of the mouse cursor.
+ For example: Fix column STT and row 1 + 2 -> Place the cursor in cell C3.
- Step 2: Select View -> Freeze Panes .
Results:
Good luck!