Today we’ll talk about how to freeze columns in Excel. When working with various tabular data, there is often a need to see row or column headings in front of you, throughout the process, at each moment of time, regardless of the position of the scroll pointer. Fortunately, the specified application has a special function that can help us.
Training
In order to solve the question of how to fix columns and rows in Excel, run the spreadsheet editor and open the file with the necessary data in it. Next, go to the desired sheet of the document.
Instruction manual
First, we’ll show you how to freeze a column in
Excel if you are using the application version 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 that allows you to pin areas. He is placed in a special group of teams, united under the name "Window". We need the bottom line of the list. She is responsible for fixing the first column. Click on it with the mouse cursor or select using the key with the letter "th".
We go to the right
Now we’ll look at how to fix columns in Excel, if only the first of them is not enough. Select the corresponding column. It should be located to the right of the extreme column of the docked group. For this purpose, we left-click the heading of the described column, that is, the cell above the top row. While hovering over the desired area, it changes the appearance and turns into a black arrow. We open the “Freeze areas” list, 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 “Freeze areas.” This item may not be on the menu. This is possible if the sheet already contains other fixed areas. If so, the indicated place in the list will be occupied by the function of disabling the fixing of areas. We select it first. Then we open the list again and use the “Fix areas” function that has returned to its rightful place. If the version of the spreadsheet editor “2003” is used, the menu is different here. Therefore, in this case, selecting the column that follows the fixed 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 perform the steps described below. Select the first cell from the unsecured area, that is, the upper, left. At the next stage of the application version 2007 or 2010, we repeat the steps described above. As for the publication "2003", here it is necessary to select the item "Lock areas" in the "Window" section.
Additional features
Now you know how to freeze columns in Excel, but you also can not do without adding new rows or columns to the document. So, we launch the document in which similar modifications are planned, and we create the necessary table. We save the material by assigning it 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 resizes to the right. It is located 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 a suitable place. The number of selected cells should be equal to the number of empty graphs that you plan to add. If you need to insert non-contiguous elements, 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.