All TalkersTech Sections

How To Freeze First Two Columns In Excel

Last Updated : Feb 11, 2022

How To Freeze First Two Columns In Excel

In this article we will show you how to freeze first two columns in excel, Excel is used in many workplaces and other institutions for data keeping. It is one of the oldest ways of keeping official data for comparison or reference purposes.

Despite the availability of many other options of data-keeping, excel has kept a stronghold in the market.

It is because of all the features that you get with excel. If you know the right shortcuts and methods of using different features of excel then it will be easier for you to work on excel.

Comparing information can be difficult if you are working with a lot of data on excel. But excel includes many tools that make it easier to view content from different parts of the sheet at the same time. Some of these features include freeze panes and split your sheet.

In this article, we will focus on the method of freezing selected columns on excel. The steps to freeze selected columns on excel includes the following.

Step By Step Guide On How To Freeze First Two Columns In Excel :-

  1. Select the column to the right of the first two columns that you wish to freeze for comparison purposes. For example, if you have 5 columns named A, B, C, D, and E and you want to freeze the first two columns here. Suppose the columns you want to freeze are A, and B. Then select Column C so that you can start the freeze pane process.

    How To Freeze First Two Columns In Excel

  2. Click the view tab on Ribbon. It is on the top portion of the sheet.
  3. On the view tab, select the Freeze Panes command. It will open a drop-down menu.

    How To Freeze First Two Columns In Excel

  4. Choose the freeze panes command from the drop-down menu.

    How To Freeze First Two Columns In Excel

  5. Once done, your columns will be frozen in place.
  6. Scroll across the sheet to check if the columns have frozen. When you do then you will find that the columns you have frozen are constant.

Conclusion :-

There are separate options of freezing just the first row and column on the sheet. So you can just choose that if you wish to freeze the first row and column.

Overall, it is an easy method of comparing data with the reference material frozen in place. Just follow the steps accurately so as to not do anything wrong on the sheet.

If you do it according to the mentioned steps then you can easily freeze any number of columns and rows.

In conclusion, these steps are easy to execute and you just need to follow it to freeze the first two columns in excel. Moreover, you can follow the same steps to even unfreeze the first two columns.

So, make your work of data comparison easier with the above mentioned trick. I hope this article on how to freeze first two columns in excel helps you and as now you can freeze first two columns in excels just by following the above given step-by-step guidance properly.

Popular Articles