Details on how to fix columns in Excel

Today we will talk about how to fix in Excelcolumns While working with various tabular data, it is often necessary to see in front of you the headings of rows or columns, throughout the process, at each moment in time, regardless of the given position of the scroll pointer. Fortunately, a special function has been implemented in this application that can help us.

Preparation

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

Instructions

To begin, let us tell you how to fix a column inExcel, if the application version is 2010 or 2007. We fix the left column of the sheet. To do this, go to the tab called "View". We open the drop-down list, which allows you to pin the area. It is placed in a special group of commands, united under the name "Window". We need the bottom line of the list. She is responsible for pinning the first column. Click on it with the mouse cursor or select it using the key with the letter “d”.

We leave to the right

Now we will analyze 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 outermost column of the group to be fixed. To this end, left-click the title of the column described, that is, the cell above the top row. When you hover the cursor on the desired area, it changes the appearance and turns into a black arrow. Expand the list of “Pinned areas”, which is located in the “View” tab, you can find it in the main menu of the editor. This time, select the top row. It is also called “Fasten the area”. This item may not be in the menu. This is possible if the sheet already contains other pinned areas. If this is the case, the designated function in the list will be taken by the function of disabling the anchorage of areas. We choose it first. Then we open the list again and use the function “Fix areas” that has returned to its rightful place. If the version of the table editor "2003" is used, the menu here is different. Therefore, in this case, selecting the column that follows the pinned one, open the “Window” section. Next, select the line called. When it is necessary to fix not only a certain number of columns, but also several lines, we carry out the steps described below. Select the first cell from the unfixed area, that is, the top, left. At the next stage of the version of application 2007 or 2010, we repeat the steps described above. As for the edition "2003", here it is necessary to select the item "Fix areas" in the section "Window".

Additional Features

Now you know how to freeze columns in Excel,but you also can't do without adding new lines or columns to the document. So, we launch the document in which similar modifications are planned, and we create the necessary table. Save the material by assigning him an arbitrary name. In the cell, which is located on the right in the table, enter the value or text. Add a column with the mouse. Move the label that changes size to the right. She is in the bottom corner of the table. This way the columns will be added. It is necessary to determine the place for placing new elements in advance. Highlight the right 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 items, hold down the CTRL key while selecting. Go to the tab "Home", use the group "Cells". Click on the arrow next to the "Paste" function. So we figured out how to fix columns in Excel.