Freezing columns in excel is a method in excel where we freeze a column so that it doesn’t move while the rest of the columns can move, to freeze a column in excel select a column which needs to be freeze and then go to the view tab where we can find freeze panes in the windows section and click on freeze panes.
Freeze Columns in Excel (Table of Contents)
- Excel Freeze Column
- How to Freeze or Lock Top Column in Excel?
- How to Freeze or Lock Multiple Columns in Excel?
- How to Freeze or Lock Both Column and Row at the Same Time?
- How to Unfreeze Panes in Excel?
Excel Freeze Column
In this article, I will show you how to freeze Top Column, Multiple Columns, and Both Rows & Columns with the help of Freeze Panes in Excel.
In freeze panes, we have totally 3 options. Out these 3 option Freeze Panes, Freeze Top Row, and Freeze Top Column. In our earlier article, we have already covered how to freeze top row & how to freeze multiple rows at a time.
#1 – How to Freeze or Lock Top Column in Excel? (ALT + W + F + C)
To Freeze Top Column is nothing but freezing your first column i.e. when you are moving from left to right we would see the first column (column A) all the time. Like freezing top row means the very first row of the worksheet and similarly freezing top column or first column means the very first column of the worksheet irrespective of where your data starts.
Consider the below datasheet for an example. Download the workbook to get access to the large data set and see the live impacts of freezing the columns in excel.
In order to see the first column when you are moving from left to right, we need to freeze the first column. Follow the below steps to freeze the first column.
Step 1: Select the worksheet where you want to freeze your first column.
Step 2: Go to VIEW tab > Freeze Panes > Freeze First Column.
The shortcut key to freeze the first column is. Press ALT + W + F + C
Step 3: Ok you are done and good to go. It is very similar to the way of freezing the top row. You have frozen your first column to see column A when you are scrolling from left to right.
Now, look at the above image, even though I am in the column AB i.e. our last column in the data set still we can see the first column.
#2 – How to Freeze or Lock Multiple Columns in Excel? (ALT + W + F + F)
Freezing multiple columns in excel is very similar to that of freezing multiple rows. It is almost the identical process of freezing multiple rows.
Step 1: Firstly, decide and identify how many columns you need to freeze. Let’s say I want to freeze first 4 columns
In my data, I know that the first four columns are the main columns I want to keep seeing at any point in time. If I want to freeze the first 4 columns then I need to place my cursor in the fifth column. In this I will place a cursor in the E1 cell, refer above image.
Step 2: After selecting the cell E1 to go to VIEW tab > Freeze Panes > again select the option Freeze Panes under that.
Now we have frozen first four columns. We can see the straight gray line which indicates the frozen line.
We can see all the 4 columns while scrolling from left to right. Right now I am in the last column still I can see the first 4 columns which are frozen.
#3 – How to Freeze or Lock Both Column and Row at the Same Time in Excel?
We have learned the ways of freezing excel rows and columns individually. Here comes the important portion of the article. Usually in excel first row contains our headers and the first column contains the column headers.
Look at the below image of the data.
Freezing top row can only help in seeing the top row and freezing columns in excel can help in freezing only first column.
Now let’s say I want to access to the top row as well as first column simultaneously. This enables me to see the top row while scrolling down and see the first column while scrolling from left to right.
Notes: While freezing top row and first column in excel we have not selected any of the cells. But while selecting multiple rows we have selected the first column cell and while freezing multiple columns in excel we have selected the first row.
Step 1: Unlike previous methods, we cannot simply freeze to freeze columns in excel. You need to be very sure how many rows and how many columns you need to freeze exactly.
In this case, I want to freeze only first row and first column in excel. So I need to select the cell B2 only.
Step 2: After cell B2 is selected type the shortcut key ALT + W + F + F. It will freeze panes for you i.e. left of the active cell columns and above of the active cell rows.
We can see two tiny gray lines unlike only one in previous cases.
You can see Freeze panes by scrolling from left to Right and Top to Bottom.
#4 – How to Unfreeze Panes in Excel? (ALT + W + F + F)
This is very simple, you need not select any cells you can just go to VIEW tab > Freeze Panes > Unfreeze panes.
You can also type the keyboard excel shortcut ALT + W + F + F.
The output is shown below:
Note: Excel Unfreeze Panes is available only if any of the freezes is applied in the sheet.
Things to Remember While Freezing a Column in Excel
- Only one freeze panes in available in an Excel worksheet. We cannot apply multiple freezes in a single worksheet.
- We have one more option called Split. It will split the sheet as multiple sheets.
- If you want to see only the headers of the data you can use excel tables.
This has been a guide to Freeze Columns in Excel. Here we discuss how to Freeze Top Column, Multiple Columns, Freezing both Rows & Columns and Unfreeze Columns in Excel along with practical examples and downloadable excel template. You may learn more about excel from the following articles –