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.
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.
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.
Step 2 : Select the View tab -> Freeze Panes -> Freeze Panes.
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.
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.
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:
Step 2 : Select the View tab -> Freeze Panes -> Freeze Panes.
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.
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.
Step 2 : Select the View tab -> Freeze Panes -> Freeze Panes.
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.
FIXED
If you don't want to freeze rows, columns, or rows and columns, just select Freeze Panes -> Unfreeze Panes.
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!