Details on how to fix columns in Excel

Today we'll talk about how to fix columns in Excel. When working with different tabular data, it often becomes necessary to see the headers of rows or columns before you, throughout the process, at each time, regardless of the position of the scroll pointer. Fortunately, the specified application has a special function that can help us.

Preparation

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

Instructions

First, we'll show you how to fix a column in Excel if you are using the 2010 or 2007 version of the application. We fix the left column of the sheet. To do this, go to the tab called "View". Expand the drop-down list, which allows you to anchor the area. 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 with the key with the letter "i".

We leave to the right

Now let's see how to fix columns in Excel, if only the first one is not enough. Select the appropriate column. It should be located to the right of the last column of the group being fixed. To do this, we click the left mouse button's button on the header of the column described, that is, the cell above the top row. When you move the cursor to the desired area, it changes the appearance and turns into a black arrow. Expand the list of "Lock areas", which is located in the "View" tab, you can find it in the main editor menu. This time choose the top row. It is also called "Lock areas". This item may not appear in the menu. This is possible if the sheet already contains other fixed areas. If this is the case, the indicated place in the list will be occupied by the function of disabling the fastening of regions. We choose it first. Then again open the list and use the function "Lock areas" returned to the right place. If you use the version of the table editor "2003", the menu here is different. Therefore, in this case, selecting the column that follows the docked, open the "Window" section. Next, choose a line called. When you need to fix not only a certain number of columns, but also several lines, perform the steps described below. We select the first cell from an unattached area, that is, the upper, left. In the next stage of the 2007 or 2010 version, we repeat the steps described above. As for the publication "2003", here you must select the "Lock areas" item in the "Window" section.

Additional Features

Now you know how to fix columns in Excel, but you also can not do without adding new lines or columns to the document. So, start the document, in which such modifications are planned, and create the necessary table. We save the material, assigning it an arbitrary name. In the cell that is located on the right side of the table, enter a value or text. Add a column with the mouse. Move the label to the right, which changes the size. It is in the bottom corner of the table. Thus, the columns will be added. Determine the location for the placement of new items must be in advance. We highlight a suitable place. The number of allocated cells must be equal to the number of empty graphs that you plan to add. If you want to insert non-contiguous elements, hold down the CTRL key while highlighting. Go to the "Home" tab, use the "Cells" group. Click on the arrow next to the Paste function. So we figured out how to fix the columns in Excel.