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!
You should read it
- How to fix column and header rows in Excel 2016
- How to add columns, delete columns, add rows, delete rows in Word 2007, 2010, 2013, 2016
- How to use Group to hide, show rows and columns in Excel 2007, 2010, 2013, 2016, 2019
- How to hide columns and hide rows in Excel 2016, 2013, 2010
- Complete tutorial of Excel 2016 (Part 6): Change the size of columns, rows and cells
- How to create Header and Footer borders in Word 2019, 2016, 2013, 2010 and 2007
- How to split columns in Word - Instructions on dividing columns in Word 2007, 2010, 2013, 2016
- How to wrap text in Excel 2007, 2010, 2013, 2016
- MS Excel 2007 - Lesson 10: Modify columns, rows and cells
- MS Excel 2007 - Lesson 5: Edit Worksheet
- Page numbering in Word 2007, 2010, 2013 and 2016
- How to draw a table - Add, edit, and delete column rows in a table in Excel 2016
May be interested
Page numbering in Word 2007, 2010, 2013 and 2016
How to wrap text in Excel 2007, 2010, 2013, 2016
How to create newlines in Excel
How to create a newline in Excel 2020
How to wrap text in an Excel cell - Wrap text in an Excel cell
Instructions automatic text carriage return in Excel - Auto line breaks when the width of the column in Excel