How to fix columns and headlines in Excel

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.

How to fix columns and headlines in Excel Picture 1

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.

How to fix columns and headlines in Excel Picture 2

Note: You can choose to freeze the first row by clicking Freeze Top Row .

How to fix columns and headlines in Excel Picture 3

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).

How to fix columns and headlines in Excel Picture 4

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 .

How to fix columns and headlines in Excel Picture 5

- Step 2: Select View -> Freeze Panes .

How to fix columns and headlines in Excel Picture 6

Let's compare the results: When we drag the column They are obscured but the STT column remains fixed and is displayed on top.

How to fix columns and headlines in Excel Picture 7

Note: If you want to fix the first column instead of choosing Freeze Panes -> Freeze First Column .

How to fix columns and headlines in Excel Picture 8

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.

How to fix columns and headlines in Excel Picture 9

- Step 2: Select View -> Freeze Panes .

How to fix columns and headlines in Excel Picture 10

Results:

How to fix columns and headlines in Excel Picture 11

Good luck!