EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Tools Freeze Columns in Excel
Secondary Sidebar
Excel Functions
  • Excel Tools
    • Excel Shortcut Redo
    • Reduce Excel File Size
    • Quick Analysis in Excel
    • Goal Seek in Excel
    • Compare Two Lists in Excel
    • Excel Quick Analysis
    • Estimate Template in Excel
    • Pivot Table Count Unique
    • CSV Files into Excel
    • Excel Business Plan Template
    • Excel Export to PDF
    • Free Excel Template
    • Excel Repair
    • Color in Excel
    • Form Controls in Excel
    • Timecard Template in Excel
    • How to Unhide All Sheets in Excel?
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (12+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE

Freeze Columns in Excel

By Madhuri ThakurMadhuri Thakur

Freeze Columns in excel

Excel Freeze Columns (Table of Contents)

  • What are Freeze Columns in Excel?
  • How to Freeze Columns in Excel?

What are Freeze Columns in Excel?

Freeze helps us fix the select Column so that we can see the data towards the most right in the worksheet. Freeze Column can be accessed from the View menu tab’s Window section from the drop-down list of Freeze Panes. First, to freeze the column, select the column which we want to freeze or put the cursor anywhere in that column and then select the Freeze Column option from the list. We will be able to see the selected column is now frozen.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,412 ratings)

Why Freeze Panes?

When you are working on data that are large, you may not be able to view some of the data because it does not fit on the screen. So let’s take a look at the below excel sheet. As you can see in the above screenshot, you can only see column U and Row 23. So if you have headers in Row 1 and you scroll down or right, the headers will not be visible.

This is where Freeze Panes come for help. Freeze panes can keep rows or columns visible while scrolling the rest of the worksheet.

How to Freeze Columns in Excel?

Freeze Panes come with three options, and we will take a look at all of them one by one with examples.

You can download this Freeze Columns Excel Template here – Freeze Columns Excel Template

Example #1 – Freeze Top Row

As you can see in the below Excel screenshot, Row 1 is the header for my report, which contains Employee’s personal information, and I want the headers to be visible all the time.

Freeze Columns in excel 1-1

But when I scroll down now, I will not be able to see the header row.

Freeze Columns in excel 1-3

So to keep the first row visible, I need to Freeze Top row. To Freeze the top row, we need to execute the following steps:

  • Select Row 1 as shown in the below screenshot.

Freeze Columns in excel 1-4

  • Go to the View Tab in the Excel Sheet.

Freeze Columns in excel 1-5

  • Select Freeze Panes.

Freeze Columns in excel 1-6

  • In the drop-down list, select Freeze Top Row.

Freeze Columns in excel 1-7

  • So after selecting Freeze Top Row, you will be able to freeze row 1, and you can scroll all the data below Row 1 without losing visibility to the headers.

Top Row Freezed

Example #2 – Freeze First column

Now, if you have important information in Column A which you want to be visible when you scroll towards the right, you need to use the Freeze the First Column option.

Suppose, in our first example; I want to freeze the Employee Names in Column A. You will need to follow the below steps.

  • Select Column A

top row column1

  • Go to the View Tab in the Excel Sheet.

Top row excel

  • Select Freeze Panes.

top row column 2

In the drop-down list, select Freeze First Column.

Top row excel 1

Now when you scroll towards the right, you can scroll without losing the visibility to column A.

Column Freezed

Example #3 – Freeze Panes

To Freeze any pane in the sheet, either it’s a row or column, you need to select the Freeze Panes option from the drop-down list. This option is not for Top Row and First Column; it will freeze your screen from any row or column which you want to freeze and scroll the rest of the data.

You need to follow the below steps to use this option. Go to the View Tab in Excel Sheet and Select Freeze Panes.

Freeze Columns in excel 1-5

  • Before selecting the freeze pane, you need to select the cell from where you want to freeze the pane.
  • In the below example, if I need to freeze data till Qualification and I want to freeze the top row, I will select cell D2 and click Freeze Panes.

Freeze Panes in Excel 2

Now, as you can see, data till column C and row 1 is always visible even if you scroll down or scroll towards the right.

How to Unfreeze the Freeze Panes?

If you want to unfreeze the pane and come back to the earlier view, you just need to follow the below steps.

  • Select the Row or Column, which is already Freeze.
  • Go to the View Tab in Excel Sheet and Select Freeze Panes; in the Drop-Down list, select Unfreeze pane so the row or column will be Unfreeze as shown in the below screenshot.

Things to Remember About Freeze Columns in Excel

  • If the Worksheet is in Protected mode, then you cannot Freeze or Unfreeze Panes.
  • It is very important that while printing anything, you need to Unfreeze panes as the Rows or Columns which are frozen will not come while Printing the Worksheet.
  • If you are in cell editing mode or page layout view, you will not be able to Freeze or Unfreeze Panes.

Recommended Articles

This is a guide to Freeze Columns in Excel. Here we discuss how to freeze columns in excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Excel Freeze Rows
  2. Excel Freeze Panes
  3. Column Header in Excel
  4. COLUMNS Formula in Excel
Popular Course in this category
MS Excel Training Bundle
  13 Online Courses |  100+ Hours |  Verifiable Certificates |  Lifetime Validity
4.5
Price

View Course

Related Courses

Excel Advanced Training (16 Courses, 23+ Projects)4.9
Excel Training (23 Courses, 9+ Projects)4.8
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Freeze Columns Excel Template

EDUCBA

Download Freeze Columns Excel Template

EDUCBA

डाउनलोड Freeze Columns Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more