In Excel, freeze the top two rows. Freeze a cell area in Excel
To fix a row or heading in Excel, you need to go to the View tab.
Going to the “View” tab, you need to click on any cell in the Excel table, and then in top panel Click on “Freeze areas”. Will open context menu in which you need to select “Lock top row”. After that the top one visible line will not disappear when scrolling down the table.
Working with Excel 2007 and 2010
This function is available in every version of Excel, but due to the difference in the interface and the location of menu items and individual buttons, it is not configured in the same way.
Freeze a row
If you need to attach a header to a file, i.e. top line, then in the “Window” menu you should select “Freeze Areas” and select the cell of the first column of the next line.
To fix several rows at the top of the table, the technology is the same - the leftmost cell next to the rows being fixed is highlighted.
Freeze a column
Fixing a column in Excel 2003 is done in the same way, only the cell in the top row of the next column or several columns after the one being frozen is selected.
Freeze an area
The Excel 2003 software package allows you to record both columns and rows of a table at the same time. To do this, select the cell next to the ones being assigned. Those. To freeze 5 rows and 2 columns, select the cell in the sixth row and third column and click “Freeze Regions”.
Later versions software package Excel also allows you to freeze the file header in place.
Freeze a row
When you need to fix not one, but another number of lines, you need to select the first scrollable line, i.e. the one that will be immediately behind the assigned ones. After that, in the same item, select “Pin areas”.
Freeze a column
To freeze a column, in the “Freeze Regions” section, you must check the option to freeze the first column.
Freeze an area
The two options mentioned above can be combined by making sure that when scrolling the table horizontally and vertically, the necessary columns and rows will remain in place. To do this, select the first scrollable cell with the mouse.
Afterwards, fix the area.
Those. if, for example, the first line and the first column are fixed, this will be the cell in the second column and the second line, if 3 rows and 4 columns are fixed, then you should select the cell in the fourth row and fifth column, etc., the operating principle should be understandable.
How to Freeze a Column in Excel
To freeze a column in Excel, you need to go to the View tab.
Going to the “View” tab, you need to click on any cell in the Excel table, and then in the top panel click on “Freeze Areas”. A context menu will open in which you need to select “Freeze first column”. This will prevent the leftmost column from disappearing when you scroll the table to the right.
Freezing columns in Excel is almost exactly the same as freezing rows. You can freeze just the first column, or freeze multiple columns. Let's move on to examples.
Fixing the first column is just as easy, click “View” -
When working with large databases, the user scrolls the worksheet up and down from time to time. Moreover, the most important part, i.e. The table header becomes invisible. It seems like a small thing, but sometimes this can cause difficulties, especially if the table has many columns. The solution to this problem is very simple: you just need to know how to freeze a row in Excel.
Video instructions for pinning a row in Excel
How to freeze a row in Excel?
So, the essence of the problem is as follows: the user has enough large base data in Excel, and you want the first row to remain visible at all times when scrolling down. Before you begin this task, there are 2 things to note:
- You can only fix those lines that are at the top (i.e., either only the first, or the first two, the first three, etc.).
- If the worksheet is protected or in use, then this procedure will be unavailable (to exit this mode, press the “Esc” key).
Fixing the table header in Excel differs slightly depending on the version of the program. In order for the first row in Excel 2007 (or 2010) to be visible all the time, you need to click on the field that is located below it (in in this case this will be box A2) and then go to the View tab in the menu bar. After that, in the “Window” group, you need to click on the “Freeze Panes” button and specify that the top line is always displayed at the top (even when scrolling the worksheet up and down). Another way is to select the entire row by clicking on its number. After this, you need to execute the already familiar commands in the menu bar.
If everything was done correctly, now the table header should always be at the top. You can verify this by scrolling down the worksheet. This is also confirmed by a barely noticeable black stripe, which emphasizes the recorded range.
In more old version table processor(2003) there are 2 ways to fix the table header.
The first method is exactly the same - select the desired field (i.e. A2), and then click on the menu bar “Window - Freeze areas”. If the specified range is underlined with a black line, then everything has been done correctly.
The second method is a little more complicated. First, you need to click “Window - Split” in the menu bar. After this, 2 lines will appear: vertical and horizontal. A vertical line can be deleted by double-clicking on it with the left mouse button. A horizontal line must be moved so that it emphasizes the first row. Then you need to select the “Freeze Areas” command again in the same item in the menu bar, after which the header will always be displayed on top.
In order to remove the fixation, you need to select the appropriate command in the “Window” item, which is called exactly the same.
Freezing Columns and Ranges
To fix a row in Excel 2007 and 2010 versions, use the “Freeze Areas” button. As you may have noticed, there were as many as 3 options in the drop-down list. In addition to a row, you can also mark a column or a specific range of cells.
The fixation procedure follows exactly the same principle as for strings. The user can mark only the left columns: for example, the first, first two, first three, etc. In order to mark a column, you need to select the corresponding cell, which is located to the right of it. For example, if you want only the first column to be visible, then you need to select field B1 and click on the “Fix column” item.
The area is marked similarly (i.e., row and column at the same time). For example, if you select field B2 and select the “Freeze Areas” command, Excel will freeze the first row and first column.
Let's start with the easiest thing - learn how to pin one row or one column. It's very easy to do. Go to the tab View -> Freeze Areas. Next, select from the drop-down list required action Freeze top row or Freeze first column.
A little more complicated when we need to secure more lines or columns than one. Let's say you need to fix the top 2 rows. To do this, select line 3 by clicking on its number on the side.
A special division will appear at the border between the second and third lines.
This means that the lines are anchored and will remain in place when you scroll down the document.
You can freeze a column in the same way. To do this, select the column that is next to the one you want to dock and click To fix areas. In my example this is the second column.
Please note that you cannot freeze both rows and columns at the same time.
To remove pinned areas, simply go to View -> Freeze Areas and select the item from the drop-down list Unlock areas.
Congratulations, now you know how to freeze a row in Excel.
In this lesson I will tell you how to freeze a row or column in Excel. Pinned areas will always be visible on the screen when scrolling vertically or horizontally.
In this lesson I will tell you how to split text into columns in Excel. This lesson is suitable for you if you want to split text from one column into several. Now I will give an example. Let's say you have cell "A", which contains the first name, last name and patronymic. You need to make sure that in the first cell “A” there is only the last name, in cell “B” - the first name, and in cell “C” the middle name.
In this lesson I will tell you how to concatenate date and text in Excel. Let's say you have several cells, one of which is a date. It is necessary to obtain a cell in which the record “Agreement No. 150 dated December 28, 2015” will be stored, provided that the type of document, its number and date will be stored in different cells.
Work with multi-page documents in Excel is complicated by the fact that the cells used are often located at a considerable distance from the names of the table blocks. Constantly scrolling through the sheet from the names to the required data is irrational, time-consuming and inconvenient. The fixation function will help eliminate this drawback. Fixing a row in Excel requires a minimum of time; as a result, the header in the table will remain in view all the time, no matter how far down the cells with information are dropped. Vertically, you can make a column static when scrolling.
Method for fixing line data
You can fix either one or several horizontal blocks at once. To do this you need:If it is necessary to fix two or more upper sections horizontally, do the following:
Method for fixing vertical blocks when scrolling
To establish immobility first vertical stripe necessary:
Similar to the option with a horizontal header, the function of immobilizing several vertical blocks is implemented.
How to immobilize rows and columns together
You can fix one or more stripes horizontally and vertically at the same time by going through the following steps: 
How to remove fixation
You will need to unfasten a commit if you make a mistake or erroneous action in the previous lists; otherwise, the procedure is similar:
Now there are no fixed stripes left in any direction. The difficulty of the work lies in the order of actions and care.