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!

Marvin Fry

Update 19 May 2020

You should read it

May be interested

Table operations in Excel
instructions on table operations in excel. when working with tables you should pay attention to the following: 1. edit the width of rows and columns. there are many ways to edit the widths of rows and columns. method 1: with the column moving into the vertical bar of the column - when the child
MS Excel 2007 - Lesson 5: Edit Worksheet
editing a spreadsheet in excel 2007 includes operations like: inserting cells, inserting rows / lines and inserting columns, deleting rows, deleting cells, deleting columns, finding data, replacing data or checking spelling, go to a certain cell in the spreadsheet.
Manipulating tables editing in Excel
instructions to manipulate tables in excel. 1. insert rows and columns in the table: - for example, want to insert 1 column after salary column 1 day: step 1: select the column number of days - go to home - cells tab - insert - insert sheet column.
Excel - Convert columns to rows in Excel
if you have an excel file and enter data in the wrong row or column or vice versa, what will you do? would you delete it and re-enter it? that takes up a lot of your time. let's see how taimienphi.vn guides you on how to convert columns into rows in excel.
How to create Header in Microsoft Excel
word, excel or powerpoint header is the page title, the introduction section is at the top of the page. so how to create header on excel?
Steps to lock columns in Excel
locking columns in excel with a password helps you protect columns, prevent others from changing column content or editing columns, affecting all data of the table.
Video tutorial using Freeze feature - fixed column, line in Excel
in the previous article, tipsmake.com showed you how to use the freeze feature - fixed the rows and columns of data in microsoft excel. and for ease of tracking, we have made videos that show specific steps, how to use this function.
MS Excel - Lesson 4: Working with lines, columns, sheets
in addition to the content of tables in excel, operations with lines, columns and sheets in this program are also important. in this article, tipsmake.com will guide you to simple operation to add or remove lines, columns or sheets in excel tables.
How to convert columns into rows and rows into columns in Excel
you need to convert excel columns into rows or convert data in excel rows into columns, if retraining takes a lot of time, just a trick that network administrator instructs below, you can turn the rows into columns or columns into rows extremely easy.
MS Excel 2007 - Lesson 13: Format sheets and prints
the print titles function allows you to repeat the column and line headings at the beginning of each new page to read more pages than to read when printing.