How to Fix Column and Header Rows in Excel 2007, 2010, 2013, 2016

This guide explains how to resolve Column and Header Rows in Excel 2007, 2010, 2013, 2016, starting with the most likely causes and moving through practical troubleshooting steps.

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.

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

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.

Your results will be as follows:

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.

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

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.

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

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

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

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!