How to fix column and header rows in Excel 2007, 2010, 2013, 2016

Freezing columns and headlines helps columns or headlines always show no matter how big the mouse pointer moves to a large number of records. It will make it easier to manage and process data for large numbers of Excel spreadsheets. If you do not know how to fix column and row headers in Excel 2007, 2010, 2013, 2016, please refer to the following article.

How to fix column and header rows in Excel 2007, 2010, 2013, 2016 Picture 1

Here are instructions on how to fix column and row headings in Excel 2016, with Excel 2007, 2010, 2013, 2016 you apply the same implementation.

Freeze columns in Excel 2007, 2010, 2013, 2016

If you just want to fix a first column, then on the worksheet select View -> Freeze Panes -> Freeze First Column.

How to fix column and header rows in Excel 2007, 2010, 2013, 2016 Picture 2

So the first column will be fixed, you move the mouse to the second column how much the first column will still be displayed.

How to fix column and header rows in Excel 2007, 2010, 2013, 2016 Picture 3

If you want to fix multiple columns , you place the mouse cursor in the first cell of the next column to fix the columns. For example, if you want to fix column STT (A), First Name (B), you put your cursor in cell C1 (the first cell of the next column). Then choose View -> Freeze Panes -> Freeze Panes.

How to fix column and header rows in Excel 2007, 2010, 2013, 2016 Picture 4

Your results will be as follows:

How to fix column and header rows in Excel 2007, 2010, 2013, 2016 Picture 5

Fixed headlines in Excel 2007, 2010, 2013, 2016

If your title has only one row, then on Excel worksheet you just need to select View -> Freeze Panes -> Freeze Top Row.

How to fix column and header rows in Excel 2007, 2010, 2013, 2016 Picture 6

So you can drag to how many lines, the first line is fixed will remain displayed.

How to fix column and header rows in Excel 2007, 2010, 2013, 2016 Picture 7

If you want to fix multiple headlines, place your cursor in the first cell of the next row, just below the headlines that you want to fix. For example, if you want to fix row 1 and row 2, you place the mouse pointer in cell A3. Then select the card View -> Freeze Panes -> Freeze Panes.

How to fix column and header rows in Excel 2007, 2010, 2013, 2016 Picture 8

As such, the lines above the line where the mouse pointer is positioned will always be displayed.

How to fix column and header rows in Excel 2007, 2010, 2013, 2016 Picture 9

Unfreeze column or header row in Excel 2007, 2010, 2013, 2016

To unfreeze in Excel, select View -> Freeze Panes -> Unfreeze Panes.

How to fix column and header rows in Excel 2007, 2010, 2013, 2016 Picture 10

If you want to freeze multiple rows, multiple columns or a whole column in Excel 2007, 2010, 2013, 2016, please refer to the article http://TipsMake.vn/cach-co-dinh-cot -va-dong -ieu-de-in-excel-2016 /

Hope the article will help you. Good luck!