How to Freeze Rows in Excel | Freeze Panes Function in Excel

Abstract:  Freeze Panes tool allows to lock column or row headings in the sheet. While scroll down or over to view the rest of the data of sheet, the column and row remain on the screen.

Introduction to Freeze Panes

Freeze panes feature in the spreadsheet is the most useful tool to Freeze single/multiple Rows or columns however it is always displayed, even as you navigate the spreadsheet.

Purpose of Freeze Panes

Freeze panes feature in the spreadsheet allows to Freeze Rows and Columns in the sheet. By the help of this feature, you will be able to scroll through your data while continuing to view the frozen cells or column.

Learning Objects of Freeze Panes

  • Freeze Top Row
  • Freeze First Column
  • Freeze Panes
  • Unfreeze Panes

Procedure to Freeze Top Rows in Excel

  • Click VIEWFreeze Panes > Freeze Top Row

Procedure to Freeze Top Rows in Excel

Scroll down your data, you will find the Top row has frozen however the top row visible while scrolling through the rest of the worksheet.

Procedure to Freeze First Column in Excel

  • Click VIEW > Freeze Panes > Freeze First Columns

Procedure to Freeze First Column in Excel

Scrolls vertically to your data, you will find the First column has frozen however the first column visible while scrolling through the rest of the worksheet.

Procedure to Freeze Panes in Excel

“Freeze panes tool keep rows and column visible while rest of the worksheet scrolls (based on current Selection)” this tools allow us to freeze multiple rows and columns at once.

  • Open the Spreadsheet

Procedure to Freeze Panes in Excel

  • Click on View Tab. In the View tab, click Freeze Panes and select the freeze Panes. This tool will freeze all rows and columns before Selection.

For example, we want to freeze Rows 1 & 2 and Column A. so we will select cell B3 in order to freeze rows 1&2 and columns A. Refer the below screenshot.

Procedure to Freeze Panes in Excel 2

When the user scrolls vertically or horizontally through an open spreadsheet, everything scrolls except the frozen row or column. This is the tool that allow us to freeze multiple rows and columns at once.

 

Learning Video for Freeze Panes Function

Join Our Telegram Group techguruplus telegram group Join Our WhatsApp Group techguruplus whatsapp group
Nazim Khan - Author Image

Nazim Khan (Author) 📞 +91 9536250020
[MBA in Finance]

Nazim Khan is an expert in Microsoft Excel. He teaches people how to use it better. He has been doing this for more than ten years. He is running this website (TechGuruPlus.com) and a YouTube channel called "Business Excel" since 2016. He shares useful tips from his own experiences to help others improve their Excel skills and careers.