---
title: "Freeze Panes in Excel"  
description: "Freeze Panes in Excel"  
author: "AVADHESH PATEL"  
published: 2013-03-11  
updated: 2019-09-07  
canonical: https://www.mindstick.com/articles/1158/freeze-panes-in-excel  
category: "excel"  
tags: ["excel"]  
reading_time: 2 minutes  

---

# Freeze Panes in Excel

When you working with very [large](https://answers.mindstick.com/qa/95624/atacama-large-millimeter-submillimeter-array-alma-is-located-in-which-country) spreadsheets headings you scroll [spreadsheet](https://answers.mindstick.com/qa/31730/explain-spreadsheet-and-its-basics) [right](https://www.mindstick.com/articles/23257/how-to-find-the-right-design-agency-for-your-logo-design) or down side for looking whole recode but without the headings, it's hard to keep track of which [column](https://www.mindstick.com/forum/2288/column-site_name-ambiguous-problem) or row of data you are looking at. So for looking record with [heading](https://yourviews.mindstick.com/view/81027/world-economy-heading-towards-recession) we freeze the column and row. Steps are given below.\

Step 1: Open your excel spreadsheet.

Step 2: If you want to scroll column, then freeze the column. [Select](https://www.mindstick.com/forum/34066/use-select-operator-in-linq) your [header](https://www.mindstick.com/forum/649/set-header-and-footer-with-in-master-page) column and chose “[Freeze Panes](https://answers.mindstick.com/qa/96532/what-is-freeze-panes-in-ms-excel)” from View menu [option](https://www.mindstick.com/forum/158788/what-is-rust-s-option-type-and-how-is-it-used-for-handling-nullable-values) as below [image](https://www.mindstick.com/articles/23551/an-investigate-distinctive-seafood-restaurant-for-your-image-stamp-character) and select “Freeze First Column” option as below image.

![Freeze Panes in Excel](https://www.mindstick.com/mindstickarticle/bbf1062e-d82f-47ec-ac48-7d03731a83ba/images/e40bf0c6-e601-4fd1-aa21-2055e6764292.png)

Now Scroll your spreadsheet horizontal. You see, your header column is fixed and other column will be scrolled.

Step 3: If you want to scroll row, then freeze the row. Select your column header and chose “Freeze Panes” from View menu option as below image and select “Freeze First Row” option as below image.

![Freeze Panes in Excel](https://www.mindstick.com/mindstickarticle/bbf1062e-d82f-47ec-ac48-7d03731a83ba/images/475e97b2-6a87-4016-aa30-e63a6fe66522.png)

Now Scroll your spreadsheet vertical. You see, your header row is fixed and other row will be scrolled.

Step 4: If you want to freeze row and column same time then select cell. This selected cell’s above rows and column will be fixed and left rows and column will be scroll. First select cell then select freeze option.

![Freeze Panes in Excel](https://www.mindstick.com/mindstickarticle/bbf1062e-d82f-47ec-ac48-7d03731a83ba/images/0a3f6a63-e0a7-488c-9786-d8b1432e83d2.png)

---

Original Source: https://www.mindstick.com/articles/1158/freeze-panes-in-excel

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.