Today, there are a lot of special text editors, drawings and table data for creating and processing documents. With the latter, Microsoft Excel can work. For the convenience of editing large files, you should use the instructions, as in Excel, to fix the header of the table.
How to fix the header of the table The program is designed to handle huge data sets with many functions and formulas. It may not be small tablets, but complexes of thousands of lines and columns. These files have one serious problem. It is represented by the fact that when you scroll down the data it becomes unclear, the column with what name refers to the cell you are viewing. This situation is easily solved by the way how to fix the header of the table in the Excel. It is based on the following simple steps: - Open your document with which you will work.
- On the top task bar, click the "View" tab and click on it.
- Find the serial number of the name of the plate - it is on the left side of the sheet. Select the entire line by clicking on the number.
- On the "View" tab, look at the part of the taskbar called "Window".
- Click on "Pin area", and then select the top of the items.
- Open your document with which you will work.
- On the top task bar, click the "View" tab and click on it.
- Find the serial number of the name of the plate - it is on the left side of the sheet. Select the entire line by clicking on the number.
- On the "View" tab, look at the part of the taskbar called "Window".
- Click on "Pin area", and then select the top of the items.
This method is suitable not only to "freeze" the title of the tablet. They can solve a problem, as in Excel to fix a line, and with overlying cells above it. To do this, in the third step you need to choose a different number. If the title is the first, you can use one more way, how to fix the header in the Excel table. To do this, in the fifth step, you need to select the fixation of the top line. The result will be the same - a black bar will appear under these cells. It reflects the area you have chosen for fixation.
If you could implement one of the above methods, then as a result, get the so-called pass-through lines. They ensure the accuracy of the document, and also protect you from incorrect labeling of data. In addition, they can be made permanent even for printing. To do this:
- on the taskbar, go to the "Page layout" tab;
- find the window with the name "Page parameters";
- click on "Print headers";
- , where you see the "Through lines" field, write down the numbers required.
How to fix a row and a column in Excel at the same time
At work, you may need another instruction that helps to solve not only one question, how to fix the header of the table in the Excel. It is often necessary to freeze a column as well, and not just a line. To fasten two basic elements of the plate simultaneously, go through the following steps:
- Define a cell that is both the first to the right of the column and below the line.
- As in the previous fixation instruction, go to the desired tab and click on the first item.
After that, 2 black lines will appear, delimiting the usual and fixed ranges of the structural elements of the label. The peculiarity of this instruction, how to fix cells in Excel, is that those that are higher or to the left of the sheet become immovable. You can not lock a row and a column at the same time in the center. This is the peculiarity of working with this program.