How to leave the top row motionless in Excel. How to Freeze Top Rows in Excel

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 cells when scrolling the main sheet.

In Excel, you can freeze both columns and rows of a sheet.

Freeze a row

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 record a formula, cell, and various kinds of notes. Fixed elements are visually separated by a solid line.

Thanks to this, they can be leafed through separately from each other.

To commit a string, do the following:

  • Create a new program document (or open an existing one);
  • Select the line you want to attach. To speed up the selection of a large line, click on the starting cell, then the Shift key and on the ending element. This way the entire line will be instantly highlighted;

  • Go to the standard “View” tab, which is located in the main program window on the toolbar;
  • Find the Window Options bar and select the Freeze Panes key. In the drop-down list, click on the function that fixes the line, as shown in the figure below;

This way you can easily highlight the table header.

If you look at the figure, you will see that the frozen rows are displayed, even after scrolling the table by two hundred lines.

Also be sure to read:

Freeze a column

To freeze a column using Excel, follow the instructions:

  • Select at a time the table columns that need to be attached;

  • In the “View” tab, find the menu for pinning elements and lock the selected or several columns, as shown in the figure below;

This way, the table can be scrolled from right to left. A fixed column will be visible to the user at all times.

If you want to unpin a previously selected item, follow these instructions:

  1. Go to the “View” window on the toolbar;
  2. Unfreeze areas using the menu in the Freeze Elements tab.

Freeze document areas

In the Excel spreadsheet processor, you can record not only columns and rows separately from each other.

You can also capture individual groups of custom elements. This way you can significantly speed up 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 this, the selected elements will remain visible while the window is scrolled in different directions

The Microsoft Excel program is created in such a way that it is convenient not only to enter data into a table and edit it in accordance with a given condition, but also to view large blocks of information.

The names of columns and rows can be significantly removed from the cells with which the user is working at that moment. And scrolling the page all the time to see the title is uncomfortable. Therefore, the table processor has the ability to pin areas.

How to freeze a row in Excel when scrolling

As a rule, the table has one header. And the lines can be from several tens to several thousand. Working with multi-page table blocks is inconvenient when the column names are not visible. Scrolling all the time to the beginning, then returning to the desired cell is irrational.

To make the header visible when scrolling, we will fix the top row of the Excel table:

A delimiting line appears below the top line. Now, when you scroll the sheet vertically, the table header will always be visible:


Let's say the user needs to fix more than just the header. Another one or a couple of lines should be stationary when scrolling the sheet.

How to do it:

  1. Select any cell UNDER the row that we will record. This will help Excel figure out which area should be frozen.
  2. Now select the “Freeze Regions” tool.

When scrolling horizontally and vertically, the header and top row of the table remain motionless. In the same way you can fix two, three, four, etc. lines.

Note. This method of freezing rows is relevant for Excel versions 2007 and 2010. In earlier versions (2003 and 2000), the Freeze Panes tool is located in the Window menu on the main page. And there you must ALWAYS activate the cell UNDER the fixed row.



How to Freeze a Column in Excel

Let's say the information in the table has a horizontal direction: it is concentrated not in columns, but in rows. For convenience, the user needs to fix the first column, which contains the names of the rows, when scrolling horizontally.

To freeze multiple columns, you need to select the cell at the VERY BOTTOM of the table to the RIGHT of the column you are freezing. And click the “Freeze areas” button.

How to freeze a row and column at the same time

Task: When scrolling, fix the selected area, which contains two columns and two rows.

We make the active cell at the intersection of the fixed rows and columns. But not in the pinned area itself. It should be immediately below the required rows and to the right of the required columns.


In the drop-down menu of the “Freeze Areas” tool, select the first option.

The figure shows that when scrolling, the selected areas remain in place.

How to remove a frozen area in Excel

After freezing a table row or column, the “Unfreeze Regions” button becomes available in the “Freeze Regions” menu.

Once clicked, all locked areas of the worksheet are unlocked.

Note. The Excel 2003 and 2000 Unfreeze Panes button is located in the Window menu. If you use tool buttons frequently, you can add them to the Quick Access Toolbar. To do this, right-click and select the proposed option.

Thanks to Excel's powerful performance, you can store and work with data in millions of rows and columns. However, scrolling down all these numerous cells to line 26935, it is quite easy to lose the connection between the values ​​​​in these cells and their meaning. This is one of the reasons why Excel has prepared a special tool for us - Freeze(Pin).

This tool allows you to scroll through cells with information and see row and/or column headers that are frozen and cannot be scrolled along with other cells. So, which button should you press, and what pitfalls are there?

How to keep headers visible

If you have a regular table with one row in the header, then the steps are very simple:

  1. Look at the top header row and make sure that row is visible. In this case, the line itself does not need to be selected.

The function in question has one feature: it fixes the upper visible line.

Whenever you freeze rows or columns, the command Freeze Panes(Lock Areas) becomes a command Unfreeze Panes(Unlock Regions), which allows you to quickly unlock rows or columns.

How to freeze multiple rows and/or columns

More and more often I see tables that have multiple rows in the header. These are complex structures, but they allow you to place more detailed text in the headings, thereby more clearly describing the data in the table.

In addition, the need to pin multiple rows arises when you need to compare a certain area of ​​data with another area that is located several thousand rows below.

In such situations the team Freeze Top Row(Freeze top line) will not be very useful. But the ability to pin an entire area at once is just the thing!

Here's how it's done:


As always, this is not the end of the story. Many novice users often complain that this technique does not work for them. This can happen if you have previously pinned an area.

If any of the rows or columns are already frozen, then instead of the command Freeze panes(Pin areas), you will see Unfreeze panes(Unlock areas). Take a look at the command name before you try to pin lines and everything will work as expected.

Use this small but very handy tool to ensure that area headers remain visible at all times. In this case, when scrolling the sheet, you will always know what data is in front of you.

Today we will talk about how to freeze columns in Excel. When working with various tabular data, there is often a need to see the row or column headings in front of you, throughout the entire process, at each moment in time, regardless of the given position of the scroll pointer. Luckily, the said application has a special feature that can help us.

Preparation

In order to solve the question of how to fix columns and rows in Excel, launch a table editor and open a file with the necessary data in it. Next, go to the desired sheet of the document.

Instructions

To begin with, we will tell you how to freeze a column if you are using the 2010 or 2007 version of the application. We will freeze the left column of the sheet. To do this, go to the tab called “View”. Expand it to allow you to secure areas. It is placed in a special group of commands, united under the name “Window”. We need the bottom line of the list. It is responsible for fixing the first column. Click on it with the mouse cursor or select using the key with the letter “y”.

We go to the right

Now let's look at how to freeze columns in Excel, if only the first of them is not enough. Select the appropriate column. It should be located to the right of the outermost column of the group being pinned. For this purpose, left-click on the title of the described column, that is, the cell above the top line. When you hover the cursor over the required area, it changes appearance and turns into a black arrow. Expand the “Freeze Areas” list, which is located in the “View” tab; you can find it in the main editor menu. This time we select the top line. It is also called Freeze Regions. This item may not be on the menu. This is possible if the sheet already contains other pinned areas. If this is the case, the specified place in the list will be occupied by the function for disabling pinning of areas. Let's select it first. Then we open the list again and use the “Pin areas” function, which has returned to its rightful place. If you are using the 2003 version of the table editor, the menu here is arranged differently. Therefore, in this case, selecting the column that follows the dockable one, open the “Window” section. Next, select the line called. When you need to secure not only a certain number of columns, but also several rows, follow the steps described below. Select the first cell from the unpinned area, that is, the top, left one. At the next stage of the application version 2007 or 2010, we repeat the steps described above. As for the 2003 edition, here you need to select the “Freeze Panes” item in the “Window” section.

Additional features

Now you know how to freeze columns in Excel, but you also cannot do without adding new rows or columns to the document. So, we launch a document in which such modifications are planned and create the necessary table. We save the material by assigning it an arbitrary name. In the cell located on the right in the table, enter a value or text. Add a column using the mouse. Move the label that changes its size to the right. It is located in the lower corner of the table. This way the columns will be added. It is necessary to determine the location for placing new elements in advance. We highlight a suitable place. The number of selected cells must be equal to the number of empty columns that you plan to add. If you need to insert non-adjacent elements, hold down the CTRL key while selecting. Go to the “Home” tab, use the “Cells” group. Click on the arrow located next to the “Insert” function. So we figured out how to freeze columns in Excel.

Modern Excel is a very powerful tool for working with large amounts of information in tabular form. For those cases where there are quite a lot of lines, it is possible to fix the top line and the first column. But not everyone knows how to freeze a region in Excel.

Let's look at how to do this, because there is nothing complicated here.

  1. First you need to create some kind of table. Preferably with a large number of rows and columns.

  1. Then we select all the lines that contain the main information.

  1. After that, go to the "View" tab. Click on the "Freeze Areas" button. In the menu that appears, select the first item.

  1. Immediately after this, you will have a vertical and horizontal line, which show that everything that is before them will be motionless.

The steps described above are only suitable for modern editors (2007, 2010, 2013 and 2016).

With older versions the process is a little different.

  1. We highlight the main information in the table, which should be movable during the work process.
  2. Open the “Window” menu section.
  3. Select the item “Freeze areas”.

  1. As a result, you will see a limit in the form of a horizontal and vertical line. The highlighted part will come after them.

You can scroll the sheet down and to the right. You will see that the first column and header are in place.

Using this function, you can freeze more than just one row or column. There may be several of them. It all depends on what exactly you highlight before pinning.

How to remove a pin

Undoing all changes is quite simple. Let's look at how to do this using different versions of editors as an example.

Modern Excel

  1. Go to the View tab.
  2. Click on the "Freeze Areas" button.
  3. Select the indicated item.

  1. As a result of this, everything will return to its original form (the separating lines will disappear).

Old Excel

  1. Open the "Window" section of the menu.
  2. Click on the item “Unlock areas”.

  1. The result will be similar. Now all rows and columns will be movable while scrolling.

No View tab

Some users may encounter this problem. If you open Microsoft online help, you can read that this function is not available in Excel Starter. If you don’t have this tab, then most likely you have just such an editor.

You can find out more about this.

What happens when printing

Try scrolling down the sheet until the first lines disappear.

Then press the Ctrl + P keys on your keyboard. In the window that appears, check that the printer is connected and ready to print. Then click on the “Print” button.

The result will be the following.

As you can see, everything is in its place. Nothing has disappeared anywhere, since consolidation occurs during the work process, and not when printing documents.

Conclusion

This article showed how to freeze a specific space in different versions of Microsoft Excel. If things don't work out for you, you may be selecting the wrong cells. Or, as mentioned above, your editor may have limitations.

Video instructions

If anyone has any questions, below is a video with various comments to the instructions described above.