Freeze area in Microsoft Excel. How to unfreeze areas in Excel

When working with tables in Excel, you often encounter the need to strengthen the top row or left side of the table. In this material we will learn how to freeze an area in Excel using the additional function “Freeze Area”.

The “Lock area” function allows you to lock a part of the Excel box in such a way that it will always be in front of your eyes when you scroll the page. In addition, when sorting data, the middle areas of the pinned area do not take part in the sorting and do not change their location.

In order to freeze an area in Excel, you need to go to the “View” tab and click the “Freeze Areas” button.

When you press this button, a menu appears with the following items: freeze areas (this drop-down menu item allows you to freeze a large part of the Excel box), freeze the top row (this drop-down menu item allows you to freeze only one top row), freeze the first column (this item in And the drop-down menu allows you to pin only one first column). Let's take a look at all the menu items in order.

The first item “Lock areas” allows you to lock any number of first rows and columns. In order to quickly use this function, you need to see the mark that is on the crossbar of the fastened rows and stops.

For example, if you want to secure the first two columns and the first two rows on the Excel box, then you need to see the box that is in the third column and the third row. Then you need to see the C3. Once you have seen the required area, you need to click on the “Lock areas” button and select the first menu item.

As a result, vertical and horizontal lines will appear on the Excel arch, which reinforce the fixed area near the mouth of the arch.

If you just need to secure the first row or the first row, you can quickly use the “Secure the top row” or “Secure the first column” functions. To use these functions, you will probably have to look at the com- mittees. All you need to do is go to the “View” tab, click on the “Lock Areas” button and select the option from the menu.

Working with tables in Excel is even easier and manually. You can add, remove unnecessary rows or items. You can put even a great amount of information in there. All over the world, work around the table is growing and getting bigger. And in order to understand how much value can be placed in one or another business, you need to continuously scroll up the top of the table. It’s almost impossible that she’s getting tired.

Excel has a function that allows you to fix the table header, so that when you scroll it to the beginning or end, the top part of the table becomes unfixed.

How to attach a table header in Excel

In order to attach a header in Excel, you need to do the following:

• Open the Excel workbook.
• We see a necessary box by clicking on it with a target.
• At the table that appears, go to the “View” tab.
• On this tab you can find the "Lock area" menu.
• In the submenu that appears, select the required method for pinning the area.

The “Pin area” submenu has three types of pinning:

• Freeze area – this function freezes the area in front of the visible middle.
• Freeze the top row - no matter where the mouse cursor is and no middle is visible, this function will immediately lock the top row of the table.
• Lock the first step – fixes the first step in the work area.

In order to lock the header, you need to select “Lock top row” by clicking on it.

That's it, the top part of the table is fixed.

In order to unfreeze the pinned area, you need to do the same steps, except in the “Freeze area” submenu and select “Unlock the area”.

How to fix a row and column in an Excel table

Often there is a need to secure both the header of the table and the first column. For example, it is impossible to place the numbering of rows or other information.

For which you need to do the following:

• On the working area of ​​the table you can see the mark that is located on the crossbar of row 2 from column B.
• In the “Lock area” menu, select the first item “Lock area” by clicking the mouse button.

And it’s ready, now the first row and the first row are fixed.

Microsoft Excel is a very simple and handy tool for working with tables and data. It is easy to set up for comfortable work with a wealth of information.

If you want to freeze a row in a document, you need to know how to freeze a row in Excel.

Therefore, you can adjust the visibility of the middles when you scroll the main arc.

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

Secured row

Please! For the additional function of attachment, you can remove the necessary columns or rows in front of the file. In the same manner, you can fix a formula, composition, and various notes. The fixed elements are visually reinforced by a consistent line.

In fact, they can be swallowed one at a time.

To fix the row, enter the following actions:

• Create a new document using the program (or open the current one);
• See the row that needs to be attached. To speed up the appearance of the large row, click on the cob, then press the Shift key and on the end element. In this manner, the entire row will be instantly visible;

• Go to the standard “View” tab, which is located at the main window of the program on the toolbar;
• Find the window's Options bar and select the Freeze Panes key. In the list that drops down, click on the function that fixes the row, as shown in the picture below;

In this way, you can easily see the table header.

If you look at the little ones, you will see that the fixed rows appear after scrolling through the table for two hundred rows.

Also read it in layman's terms:

Fixed item

To register the steps in your Excel program, enter the following:

• View once the table columns that need to be attached;

• In the “View” tab, find a menu for pinning elements and fixing selections or a number of stoppers, as shown in the picture below;

In this way, the table can be scrolled right-handedly. Fixings will be visible to the kristuvachev steadily.

If you want to mark the fastening before the visible element, enter the boxes:

1. Go to the "View" window on the toolbar;
2. Unlock the pinning of areas for the additional menu in the tab of fixing elements.

Freezing document areas

In the Excel spreadsheet processor, you can record columns and rows adjacent to each other.

It is also possible to fix a group of corrugated elements together. In this way you can significantly speed up the work with folding tables and signs.

To fix several storage areas at once, see them and click on the “freeze areas” menu item, as shown in the little one:

After seeing this, the elements will disappear from your eyes as you scroll the window in different directions

Many more articles on the topic:

The hem of the window on the edge of the independent area

To divide the document frame into separate areas where you can work independently from one another, click on the “Lock Areas” button without seeing any elements of the frame.

Microsoft Excel has a wide variety of functions. With this help, you can create tables, analyze data based on created data, create diagrams and graphs, develop values, analyze and use necessary formulas and functions. And also, using Excel, you can also look at the great tables.

Since you have a lot of data recorded in rows and rows, everything that is needed is to record the rows and rows. Then you can burn it out and, for example, wear your hat again.

So, let's figure out how to secure the necessary Excel area.

First row and last row

Let's take the offensive butt, which has the names of all the soldiers inscribed on it. Go to the “View” tab and click on the button "Lock areas". From the menu that drops down, you can select an item with a unique name.

Button "...top row" Allow to fix the row under the number “1”. As a result, if you scroll through the data, you will forever lose your respect.

Please note, similar rows and columns will be supported by a black line in the table.

Yakshcho vibrati “...first stovpets”, then when you scroll the sheet to the right or left, the “A” section will be lost in place.

This does not fit into this category, because the first row of rotations is under the letter “C”, and the required row is under the number “3”.

Required stitch

In order to secure the header in the Excel spreadsheet, you need to do the following. We see the row that appears just under the cap, in our case there are 4. About the methods of seeing, you can read the report. Now click on the button "Lock areas" And select the same item from the menu that appears.

As you know, when the table is scrolled down, the header is removed from its place.

Consumer goods

In order to fix the first step for entering data, which is not in A, you can see it in appendix D. Now click on the button "Lock areas".

You can roll over, and if your right hand is swallowed, you lose your place.

Swedish method

To secure the first row of the table, see the mark that is located under the crossbar: at the butt – D4. Then press the buttons we already know. Horizontal lines will appear to indicate the fixed area.

Yak vidality

If you need to see the frozen area in Excel, click on the button "Lock areas". From the list you will see that the top ones are now standing there "Remove the assignment...", click on new.

Once you know, it’s easy to fix the area you need in Excel. Based on the following recommendations, you can fix the table header, the first row and the next.

Excel users, who work in workspaces with tens or hundreds of rows, know that the column headings in the top row appear when you scroll down the sheet to look at the records below.

In this article we will look at a number of quick ways, How to lock rows and columns in Excel. You will learn how to quickly freeze the header row and/or the first column, and how to freeze several areas at once, so that when you scroll to the right or down in Excel, the rows and/or columns are always shown.

All methods discussed above work in all current versions of Excel 2016, Excel 2013, Excel 2010 and Excel 2007.

In this article we look at the following nutrition:

How to freeze a row in Excel

As a rule, it is necessary secure the first row, to see the chapter headings as you scroll down. Otherwise, your table may contain important information in many top rows And you will need to secure them. Let's take a look at these two aspects.

How to freeze the top row in Excel

In order to freeze a row in Excel by scrolling, just go to the “View” tab to the “View” group and click “ Freeze areas» --> « Lock the top row».

Freeze columns and rows in Excel - Freeze top row

Now fasten the row visually with a darker and thinner bottom border.

Freeze the end of a row in Excel - The darker the line indicates that the row above it is frozen

Now, when you scroll the arch down, the first row will be fixed.

Freeze columns of rows in Excel - Fix the first row by scrolling

How to freeze a number of rows in Excel

What do you want secure a number of rows in the table, for example, fasten two rows, then earning money is not always difficult.

1. First, select the row below the row you want to secure. For example, if you want to secure 2 rows, select the entire third row or see mark A3.

Freeze columns and rows in Excel - See the row before which you want to freeze the rows

1. Go to the “View” tab, click “ Freeze areas» --> « Freeze areas».

Freeze end rows in Excel - Freeze the top two rows

The result of the views shown below the top two rows on the Excel arch are fixed and will now appear when you scroll.

Freeze columns and rows in Excel - The darker edges indicate that the top two rows are frozen

Yak secure the row, or else fasten the top 2 rows We already knew, now let’s take a look, How to freeze a column in Excel when scrolling.

How to secure a step in Excel

Anchoring articles in Excel It is practically the same as securing the rows. You can only secure the first column, or secure a number of columns. Let's move on to the butts.

How to secure the first step in Excel

Securing the first step is as simple as clicking “View” --> “ Freeze areas» --> « Secure the first stovets».

Freeze the first column in Excel - Freeze the first column in Excel

And yet, the darkness and thickness of the boundary mean that the left side of the fastenings.

Freeze the first column in Excel - Freeze the first column in Excel

How to secure a number of articles in Excel

What do you want secure 2 items or more on arkush, then proceed like this:

1. Select the left-handed option from the remaining option you want to secure. For example, whatever you want freeze 3 columns in Excel(A, B, C), select the entire section D or section D1

Make sure that the fixed columns now start from the left column (A). It is impossible to secure one or a number of pillars here in the middle of the arch.

Freeze columns and rows in Excel - The last column before which you want to freeze columns

1. And now follow the already familiar path, then in the “View” tab --> “ Freeze areas» --> and I say again « Freeze areas».

Freeze columns and rows in Excel - Freeze three columns in Excel

Make sure that all the items you want to secure are visible at the time of securing. As soon as the actions of these people are in the field of view (so that they are received), you will not help them later.

How to lock a row in Excel

Do you want secure the row and row at the same time? There are no problems, you can earn money, for the sake of your mind, what you start with top rowі First of all.

To freeze a number of rows and columns at a time, select the middle one below the remaining row and the right hand side of the remaining column that you want to freeze.

For example, please secure the first column and the first row, select middle B2, go to the “View” tab and click “ Freeze areas"at the point" Freeze areas».

Freeze rows and rows in Excel - Freeze rows and columns in Excel

Now secured and row and column in Excel.

Freeze columns and rows in Excel - Freeze first column and first row

This way you can freeze as many panels in Excel as you want. For example, to secure the first 2 rows and 2 columns, you select order C3; To secure 3 rows and 3 columns, select size D4, etc. Of course, the number of secured rows and columns is necessarily the same. For example, to secure 2 rows and 3 columns, you select D3.

How to unfreeze areas in Excel

To remove pinned areas, whether fixed rows, fixed items or else fixed rows and stations, click on these actions: go to the entire “View” tab, “View” group and click “ Unlock areas».

Freeze columns and rows in Excel - Unfreeze areas

Well, that’s all, for reading the article. I hope that now you can easily secure the row, secure stovpets, lock row and row in Excel.