Excel Functions Tutorials
- Excel Tools
- Excel Ribbons and Tabs
- Quick Access Toolbar in Excel (QAT)
- "Save As" Shortcut in Excel
- Accounting Number Format in Excel
- Add-Ins in excel
- Add Filter in Excel
- Advanced Filter in Excel
- Auto Filter In Excel
- Auto Format Excel
- AutoFill in Excel
- Analysis ToolPak in Excel
- ANOVA in Excel
- Border in Excel
- Checkbox in Excel
- Check Mark in Excel (? Tick Symbol)
- Combo Box in Excel and VBA
- Conditional Formatting in Excel
- Conditional Formatting with Formulas
- Conditional Formatting for Blank Cells
- Conditional Formatting Based on Another Cell Value
- Conditional Formatting in Pivot Table
- Consolidate Data in Excel
- Comma Style in Excel
- CSV vs Excel
- Data Bars in Excel
- Data Table in Excel
- Data Validation Excel
- Data Model in Excel
- Developer Tab in Excel
- Descriptive Statistics in Excel
- Dynamic Named Range in Excel
- Drawing in Excel
- Excel Fill Handle
- Excel Fill Down
- Error Bars in Excel
- Excel Forms for Data Entry
- Excel Tables
- Excel Power View
- Exponential Smoothing in Excel
- Filters in Excel
- Flash Fill in Excel
- Freeze Panes in Excel
- Freeze Columns in Excel
- Freeze Cells in Excel
- Format Painter in Excel
- Shortcut for Format Painter in Excel
- F-Test in Excel
- Goal Seek in Excel
- Gridlines in Excel
- Heat Map in Excel
- 3D Maps in Excel
- Header and Footer in Excel
- Insert Button in Excel
- Insert / Draw Line in Excel
- Insert Function in Excel
- List Box in Excel VBA
- Lock Cells in Excel
- Macros in Excel
- Enable Macros in Excel
- Merge and Center in Excel
- Merge Cells in Excel
- Merge Tables in Excel
- Name Box in Excel
- Name Range in Excel
- Null in Excel
- One Variable Data Table in Excel
- OneDrive Excel
- Protect Workbook in Excel
- Pivot Table in Excel
- Pivot Table Examples
- Pivot Table Filter
- Pivot Table Slicer
- Paste Special in Excel (With Top 10 Shortcuts)
- Quick Analysis Tools in Excel
- Radio Button in Excel
- Recording Macros in Excel
- Regression Analysis in Excel
- Scenario Manager in Excel
- Scroll Bars in Excel
- Scroll Lock in Excel
- Slicers in Excel
- Solver in Excel
- Sort by Color in Excel
- Sort by Number in Excel
- Sort Data in Excel
- Sparklines in Excel
- Spell Check in Excel
- Split Panes in Excel (Horizontally, Vertically, Cross Split)
- Status Bar in Excel
- Text to Columns in Excel
- Timeline in Excel
- Toolbar on Excel
- Track Changes in Excel
- Trend Line in Excel
- Two-Variable Data Table in Excel
- Watch Window in Excel
- Wrap Text in Excel
- XML in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tips (178+)
- VBA (162+)
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 –