How to fix column and header rows in Excel 2016

With an excel data sheet with a large number of columns and rows, during the process of processing, you will surely face many difficulties. Now fixed the column and the headline is a necessary job, you can easily check and process data without confusion and waste more time.

If you have to work with an Excel file with a large amount of data but you do not know how to fix columns and headlines, please refer to the following article.

How to fix column and header rows in Excel 2016 Picture 1

The article guides how to fix column and header row in Excel 2016, with Excel 2013, 2010, 2007 you just need to do the same.

FIXED LINE

Freeze the first line

If you need to fix the first 1 row in a sheet, select View -> Freeze Panes -> Freeze Top Row.

How to fix column and header rows in Excel 2016 Picture 2

Fixed multiple lines

If you need to fix more than 1 line then you need to do the following:

Step 1 : You put the cursor in the first box below the lines you need to fix (all the lines above the cursor line will be fixed).

For example, if you need to fix the 3 headlines (row 1, row 2, line 3), the mouse cursor will be placed in the first cell of row 4 as shown below.

How to fix column and header rows in Excel 2016 Picture 3

Step 2 : Select the View tab -> Freeze Panes -> Freeze Panes.

How to fix column and header rows in Excel 2016 Picture 4

So you have fixed the line for the Excel file, from now on when you move to the nth row (very large n), the rows you have fixed will still be visible.

How to fix column and header rows in Excel 2016 Picture 5

FIXED COLUMN

Freeze the first column

If you need to fix the first column in the file, just select View -> Freeze Panes -> Freeze First Column.

How to fix column and header rows in Excel 2016 Picture 6

Freeze multiple columns

If you want to fix more than 1 column then you need to do the following:

Step 1: You put the cursor in the first cell in the next column next to the columns you need to fix (all the columns to the left of the column where you put the mouse cursor are fixed).

For example: Need to fix column 1 and column 2, then you put the mouse cursor at the first position column 3 as shown below:

How to fix column and header rows in Excel 2016 Picture 7

Step 2 : Select the View tab -> Freeze Panes -> Freeze Panes.

How to fix column and header rows in Excel 2016 Picture 8

So you have fixed columns for Excel file, from now on when you move to which column, the columns you have fixed will still be displayed.

How to fix column and header rows in Excel 2016 Picture 9

FIXED BOTH LINE AND COLUMN

If you want to fix both the headlines and the first columns of an Excel file, do the following:

Step 1 : First you need to determine the position of the mouse cursor, the lines on the cursor line will be fixed, the columns to the left of the mouse cursor column will be fixed.

For example: If you want to fix the first 3 rows (row 1, row 2, row 3) and 2 columns (column 1, column 2), you put the mouse pointer in the 3rd cell of the 4th row (4th cell of the 3rd column) as shown below.

How to fix column and header rows in Excel 2016 Picture 10

Step 2 : Select the View tab -> Freeze Panes -> Freeze Panes.

How to fix column and header rows in Excel 2016 Picture 11

So you have fixed the whole column you want, when moving the mouse down the bottom lines, the fixed rows are still displayed and when you move the mouse to the adjacent columns, the fixed columns are still display.

How to fix column and header rows in Excel 2016 Picture 12

FIXED

If you don't want to freeze rows, columns, or rows and columns, just select Freeze Panes -> Unfreeze Panes.

How to fix column and header rows in Excel 2016 Picture 13

Thus, with just a few simple steps, you can quickly fix the column and the headline. From now on you will not spend too much time processing Excel files with large amounts of data. Good luck!