FREEZE FIRST TWO ROWS IN EXCEL 2016 HOW TO
So, let us learn How to Freeze Rows and Columns in MS Excel 2016? Steps to Freeze Rows and Columns in MS Excel 2016: Frozen rows and column will appear, no matter wherever you are on the sheet. The best way to retain rows and columns is to freeze them. Same is the case with column if you scroll the sheet rightwards the columns to the left will be invisible. It will make no sense of reading data without headings. To read the data at the bottom of the sheet, if you scroll the sheet upward, the headings that lie in the top row will be invisible. From now on you will not spend too much time processing Excel files with large amounts of data.Suppose, you have an Excel sheet that contains a lot of data. Thus, with just a few simple steps, you can quickly fix the column and the headline. If you don't want to freeze rows, columns, or rows and columns, just select Freeze Panes -> Unfreeze 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. 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.įor 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. If you want to fix both the headlines and the first columns of an Excel file, do the following: 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. 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).įor example: Need to fix column 1 and column 2, then you put the mouse cursor at the first position column 3 as shown below: If you want to fix more than 1 column then you need to do the following: If you need to fix the first column in the file, just select View -> Freeze Panes -> Freeze First Column. 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. Step 2 : Select the View tab -> Freeze Panes -> Freeze Panes. 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).įor 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. If you need to fix more than 1 line then you need to do the following: If you need to fix the first 1 row in a sheet, select View -> Freeze Panes -> Freeze Top Row. 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. 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. Now fixed the column and the headline is a necessary job, you can easily check and process data without confusion and waste more time. With an excel data sheet with a large number of columns and rows, during the process of processing, you will surely face many difficulties.