Excel involves working with large amounts of numerical information. And when viewing large tables, the question arises, how to fix a row in Excel when scrolling? After all, such data always implies the presence of headers and totals. This is the information that is convenient to see in front of you on the screen all the time, even when scrolling. That is what we will talk about in this article.
How to fix a line
If you need to fix the header in Excel, you can use the special command on the toolbar. To execute it, set the pointer to any cell in the table.
Go to the "View" tab and click on the "Freeze panes" button.
A menu will appear in which you can set the required options. 
Select the second item - "Freeze the top line." Try to scroll the table and you will see that the first line does not move - it is fixed. 
Only in our example, this is not the data that makes sense to capture when scrolling. We need a hat. In this case, we must fix the region.
How to freeze an area in Excel
It is obvious that you cannot fix the range from the middle of the Excel table when scrolling. So when it comes to area, it includes all rows from the first to the top docking and the columns from the first to the left docking.
The screenshot shows an example area. Fragments fixed during scrolling are highlighted in orange. 
To get such a fixation when scrolling, you need to set the pointer correctly by first selecting all the necessary lines from the header, and then, holding ctrl key select the required columns.
Freeze Multiple Excel Rows
Place the pointer on the FIRST cell of the row following the one being pinned. 
Then choose the Freeze Pane command from the View panel. 
Notice the thin line that marks the border of the pinned area. 
Freeze Multiple Excel Columns
Place the pointer on the FIRST cell of the column following the anchored in the FIRST ROW.
If you, as in our example, have a union for all columns, then it will also fall into the region fixed when scrolling. To avoid this, remove the join and move it to loose columns. . 
Run the same command again. 
The columns will be fixed on scroll. 
To freeze one first column in Excel, proceed in the same way as with the first row, selecting the appropriate item. 
Freeze regions in Excel
Place the pointer on the FIRST cell AFTER the column to be anchored and the row to be anchored.
In the screenshot, the area is filled with color, and the first cell outside it has the address B3. 
After that, execute the "Freeze area" command again. Everything will be ready. 
It is not possible to freeze cells in Excel when scrolling separately.
How to freeze a cell in a formula in Excel
Another important feature of the program that you need to know about is fixing the cell address in the formula. When creating a formula, you specify their addresses, the data from which is involved in the calculations. 
When copying these formulas, the addresses are shifted in the corresponding direction. For the example from the screenshot, copying the formula down will give C4/B4 calculations for the next cell. 
Such a reference to a cell (C4 or B4) is called RELATIVE. In our example, in the last column, the value is calculated as the ratio of the actual volume for the day to the total for the year. 
When trying to "stretch" the formula to the end, we get the following result. 
This is because the second address is also shifted. 
But if we go to the cell with the address B39, we will naturally find that it is empty. After all, the amount is considered only once. 
In this case, you need to create ABSOLUTE link to cell C38 in the very first formula. This will fix it when copying by stretching.
When entering a formula, after clicking on the second cell in the formula, immediately press F4. The address will be surrounded by dollars. 
Then press Enter and copy. 
All calculations will be done.
Cycling F4 while entering a formula will give different results:
- The first is full address fixation: $C$38
- The second is fixing the line number: C$38. When copying, the column will change, and the second part of the address will remain at position 38 - D38, E38, etc.
- The third push fixes the column name: $C38. When copying, the column will remain unchanged, and only the number will change: C39, C40, etc.
- The fourth press is the removal of fixation.
This way you can manage your formulas. In conclusion, we recall that you can freeze while scrolling a column, row, or area from the first column and first row to the current ones. You can't freeze a cell while scrolling. But you can fix the cell address to avoid shifting when copying. We wish you good luck with your work in Excel!
Have a great day!
If you want to freeze a specific area in a document, you need to know how to freeze a row in Excel.
Thanks to this, you can adjust the visibility of the cells when scrolling the main sheet.
In Excel, you can freeze both columns and rows of a sheet.
Line pinning
Advice! Using the attachment function, you can leave the necessary columns or lines in sight while scrolling through the file sheet. In the same way, you can fix the formula, cell and all sorts of notes. Fixed elements are visually separated by a solid line.
Thanks to this, they can be flipped through separately from each other.
To freeze a row, do the following:
- Create a new program document (or open an existing one);
- Highlight the line you want to attach. To speed up the selection of a large line, click on the start cell, then the Shift key and on the end element. Thus, the entire line will be instantly selected;
- Go to the standard "View" tab, which is located in the main program window on the toolbar;
- Locate the window options bar and select the pinning panes key. In the dropdown list, click on the function that fixes the string, as shown in the image below;
Thus, you can easily highlight the table header.
If you look at the figure, you will see that the fixed rows are displayed, even after scrolling the table for two hundred lines.
Also be sure to read:
Freezing a column
To freeze a column using Excel, follow the instructions:
- Select at one time the columns of the table that you want to attach;
- In the "View" tab, find the menu for pinning elements and fix the selected or several columns, as shown in the figure below;
Thus, the table can be scrolled from right to left. The fixed column will be visible to the user at all times.
If you want to unpin a previously selected element, follow the instructions:
- Go to the "view" window on the toolbar;
- Unfreeze areas using the menu in the Freeze Elements tab.
Pinning Document Regions
In the Excel spreadsheet, you can fix not only columns and rows separately from each other.
You can also fix individual groups of custom elements. Thus, you can significantly speed up the work with complex tables and reports.
To fix several components at the same time, select them and click on the “freeze areas” menu item, as shown in the figure:
After that, the selected elements will remain visible while scrolling the window in different directions.
A couple more interesting articles on the topic:
Dividing a window into separate independent areas
To divide a sheet of a document into separate areas that you can work with independently of each other, click on the "Freeze areas" button without selecting any elements of the sheet.
Contains columns and rows. Columns are often labeled with headings that explain the information they contain. In tables containing a large amount of data, when scrolling down, the headings remain at the top of the page, which can be inconvenient to work with. Let's learn how to fix the header in Excel.
To ensure that the table header does not change its position and is always visible on the sheet, you need to fix the top row containing the column headings. Let's take an online cosmetics store as an example. The table contains a list of goods indicating the type of product, manufacturer, cost and colors decorative cosmetics.
The list of products is quite long, and when you scroll down, the titles are no longer visible. To fix this, fix the Excel table header. To do this, open the "View" tab and find the "Window" toolbar. There is a group of commands "Freeze areas", in the drop-down menu of which is the operation "Freeze the top line".
The top line becomes separated from the rest of the cells on the sheet by a thin line. And if we now scroll down the list, the column headings will always be displayed on the screen.
It happens that row headers play an equally, if not more important role in the construction of a table. And the problem of their disappearance from the screen when the cursor moves to the right is just as relevant as the invisibility of the column headings. In this case, it is necessary to fix this area in the file. Let's see how to fix the header in Excel, located in the first column of the table.
The table shows the academic performance of students of the college of the first year of study. The number of items is large and does not fit on the screen, so it requires scrolling to the right. So that at the same time the names do not disappear, we will fix the first column. In the “Freeze Panes” menu of operations already known to us, which is located on the “View” tab, “Window” panel, select the “Freeze First Column” item.
Now you can move to the right on the sheet and see who owns this or that assessment.
Pinning other areas and unpinning
In the student progress table, the first three columns contain the last name, first name and patronymic of the student. If we want to see all this data when moving around the sheet, we need to freeze not only the first column. Let's check how to fix the header in Excel, consisting of several columns.
To do this, select cell D1, which is outside the fixed area and adjacent to it, and select the “Freeze Areas” menu item in the “Window” panel, already known to us, of the “View” tab. By analogy, we can “freeze” the first three columns and the row. In this case, it is necessary to mark already cell D2.
General rule to fix arbitrary areas - you need to select the field at the intersection of the ranges, but not included in them.
This method works for many versions of the program, but the location of the command is different in older versions. To fix the header in Excel 2003, you need to select "Freeze Panes" from the "Window" menu.
To return the file to its original appearance and remove pinning, use the Unpin Areas menu item.
In versions of Excel, starting from 2007, it became possible to set the format of tables. At the same time, the data area with the specified style is automatically converted into a table that is convenient to work with. When configured accordingly, the program highlights the first entry as a header row and automatically sets filters for each column.
The header is highlighted in color and font and separated from the rest of the data range, and when scrolling down the data, the user can constantly see the headers without the need for additional fixation.
To do this, go to the Home tab Styles panel and select Format as Table. Set the style and click the desired element.
Now you know two ways to fix the header in Excel and you will successfully put them into practice.
For convenience, you can fix a row or column, that is, make it so that when you scroll down the table, the top row will always remain visible, and when you scroll the table to the right, the leftmost column will not disappear from view. In a table, you can freeze the topmost row, the leftmost column, or the cell-selected area
How to Freeze Header or Top Row in Excel
To fix a row or title in Excel, you need to go to the View tab.
How to freeze a row in Excel 2010
Going to the "View" tab, you need to click on any cell in the Excel spreadsheet, and then in top panel Click on "Lock Areas". Will open context menu in which you need to select "Lock the top line". After that, the topmost visible row will not disappear when the table is scrolled down.
How to freeze a column in Excel
To freeze a column in Excel, go to the View tab.
So you can fix the first column Going to the "View" tab, you need to click on any cell in the Excel spreadsheet, and then in the top panel click on "Freeze areas". A context menu will open in which you need to select "Freeze first column". After that, the leftmost column will not disappear when scrolling the table to the right.
How to freeze an area in excel
To freeze an area in Excel, go to the View tab.
This way you can fix the area above and to the left of the specified cell On the View tab, click on a cell. The cell must be selected in such a way that the selected area will be to the left and above this cell. By clicking on the cell, you need to click on "Freeze areas". A context menu will open in which you need to select "Freeze areas". After that, all rows above the selected cell will not disappear when the table is scrolled down and all columns to the left of the selected cell will not disappear when the table is scrolled to the right.
How to unfreeze areas in excel
Only visible rows and columns are fixed, and you can see everything above and to the left of the pinned area only after unpinning the areas. To unpin areas, go to the View tab.
This is how the selected areas are unfastened On this tab, you need to click on "Lock areas". A context menu will open in which you need to select the very first item "Unpin areas".
We will not discover America by saying that work with tables excel sometimes it can be very routine and tedious, especially when the table is large, the “headers” of the table are not visible and it is completely incomprehensible in which column to drive in certain data. You have to go back up, look at the name of the column, then go down the table again to the desired cell and only then enter information. It will be much easier to work if the "header" of the table is fixed. In this case, no matter how long the table is, you will always see the name of the cells. This will save you time and avoid mistakes when filling out Excel tables. So, in this article, we will look at how to freeze an area in an Excel spreadsheet.
Consider an example. Let's say we compile a table of vacations for employees of the organization (Fig. 1).
As the table enlarges, its “header” (full name, position, place of residence) will no longer be visible, and this may introduce some difficulties into the filling process. To avoid this, we fix the "header" of our table. To do this is quite simple: in the menu office go to tab View and click on the button To fix areas(Fig. 2).
Here we are offered a choice: to fix an arbitrary area, the first row or the first column. Because in our case, the "header" of the table occupies 1 line, we select the option Pin the top line. Now, no matter how long the table becomes, the first line will be visible all the time, which will help to avoid filling errors.
Unpinning a selected area is also very easy. To do this, click the button again. To fix areas and select the item Unpin areas(Fig. 3).
Everything is clear with the first row and column. But the question arises: how to fix an arbitrary area? For example, we want the administration leave columns (5 employees) to be visible all the time. This is also easy to do. First you need to determine the boundaries of the fixed area (Fig. 4).
Now you need to select an area to pin and define the last cell. In our case, the last cell will be F5, because in the table, the last row is 5 and the last column is F.
Now the cursor needs to be moved diagonally down one row and one column. And put it in this cell. In our case, this will be cell G6. Now, as we did before, you need on the tab View click on the button To fix areas and select item Selected rows and columns.
All is ready. Now, when scrolling the table, the area up to cell F5 will always be visible. To deselect an area, as usual, go to the tab View, click on the button Pinning cells and select the item Unpin areas.
If you have any questions, ask them on our.