How to fix a column in Excel?

When working with one of the most useful programs called “Excel”, users have the same question: how to fix a column in “Excel”? The reason for the question is immediately understandable, since scrolling causes inconvenience and impedes the stable operation of the utility. Also, not everyone understands what differences are in fixing the zone of lines and columns. Programmers from Microsoft offered users several different solutions to the issue in the form of useful tools. These functions can help not only fix a certain area horizontally, but also along the second plane. Yes, no one even bothers you to do this in two directions at once. In order to make life easier for beginners, we present to your attention a small understandable instruction on how to resolve the issue.

to contents ↑

Is it possible to “immobilize” a row in the program?

There are two ways to fix a line:

1. Using a tool called “Freeze the top row”.
2. Using a tool called “Freeze areas”.

The first function is ideal for those cases where fast fixation of the top line is required and is not much different from the second when it comes to highlighting the first row. It is for this reason that you can always use only the second tool.

In order to fix any of the lines, you must do the following:

1. Select with the mouse cursor the necessary part of the working field over which you are going to conduct the operation. Once again, you don’t need to select anything for the first line and you can immediately use the “Lock Top Line” tool.
2. In order to achieve the desired result, select the zone that is located below the fixed.
3. Next, go to the window called “View”, which is located at the top of the program on the toolbar.
4. Use the “Window” function and set “Freeze areas”. Two tools are located in the same menu, which were discussed at the beginning.

For those cases when the header at the top fills in just a few lines, you just need to select the line with the data that you do not need to fix. If you need to remove your pinning, just use the above function again and select the “Unpin areas” option.

With this, everything is simple and understandable, but how to fix the columns in Excel, because a large number of Internet users complain about this problem.

to contents ↑

We fix the problem using standard tools

For this case, the procedure looks almost the same as for the previous one:

1. Select an already familiar tab called “View”.
2. Now move the cursor just below the “Freeze areas” button and you will see the function that allows you to fix only the first column. It is not necessary to select the column itself for this.
3. If you want to commit more than one column, just select the one to the left of which the priority ones for fixing are located.

Now, thanks to these actions, nothing will “move” when scrolling, but in order to cancel the function, you need to do everything in the reverse order and end with the selection of the parameter called “Unpin areas”.

Freezing a column and a row is very simple, and now for general development we’ll introduce another useful function.

to contents ↑

Commit tool

You should have noticed that during the fixation of an element, the menu item that is responsible for fixing the subsequent one immediately disappears. In other words, after the operation is completed, the function can only be turned off. It is often required that for the horizontal and vertical planes all the elements are stationary during scrolling. To solve this issue, this tool was created. To do the following:

1. Select the cell that is the very first one located to the right of the desired areas.
2. We get to the “View” window and click on the “Fix areas” item.
3. In the turned-up context menu, select the item of the same name.

After these actions, the result will not be long in coming.

to contents ↑

Stock footage

The Excel program opens up many useful and convenient functions for those who understand and learn how to use all the tools. We hope that now you are one step further in this and already on the way to the status of an advanced PC user.