Skip to content

DigiRuns

Surpass Technical Knowledge

Menu
  • Home
  • Fundamentals
  • Digital Marketing
    • WordPress
    • Web Design and Development
  • Microsoft Office
    • Microsoft Word
    • Microsoft Excel
    • Microsoft PowerPoint
Menu

How to Freeze Panes (Rows and Columns) in Excel – 2022

Posted on 08/06/202118/04/2022 by DigiRuns

Freezing the Upper, Left, or both parts of the Row and Column Headings to keep it visible while the rest of the worksheet scrolls up and down or left and right, called Freeze Panes. Remove freezing the rows, columns, or both is called Unfreeze Panes.

In other words:

For example, If the data in the sheet is not fully visible or if you are working with the current data when you scroll down or right, a portion of the data along with the row title (header) or column (header) title is hidden on the screen.

See also  Apply Data Validation to Range of Cells in Excel - 21 Steal

Usually, in the worksheet, we enter or read the data by scrolling up and down, or on the left and right based on the row header and column header. In this case, we must freeze them so that the row header and column header will not be hidden. 

Freeze Panes in Excel – Freeze Rows and Columns in Excel

How to freeze panes (rows and columns) in ms-excel)
Hoe to Freeze Panes in Excel

Click to read the full article on Microsoft Word 2019, 2016, 2013, 2010, and 2007.

How to Freeze Rows and Columns in Excel Sheet

Freeze the upper and left parts of the rows and columns while rest of the worksheet scrolls. To freeze rows and columns, follow the steps below:

First, enter the data with column and row headings. For example, look at the picture above.

  1. Now click the common cell which is underneath the row heading and immediate right to the column heading as given in the 1st step of the picture above.
  2. Then go to the View tab
  3. And then click on the Freeze Panes in MS-Excel
  4. Afterwards, select the “Freeze Pane’s”
  5. Now Scroll the page to see the frozen area of the worksheet.
Freeze rows and columns in MS Excel
Freeze rows and columns in MS Excel

How to Freeze Top Row in Microsoft Excel

Freeze the top row of a worksheet while rest of the worksheet scrolls. To freeze the top row, follow the steps below:

First, enter the heading on the top of the row in a worksheet. For example, look at the picture below.

  1. Then go to the View tab
  2. And then click on the Freeze Panes in MS-Excel
  3. Afterwards, select the “Freeze Top Row”
  4. Now Scroll the page to see the frozen area of the worksheet.
Freeze Panes in MS-Excel

Freeze Panes in MS Excel – Freeze Rows and Columns in Excel

How to Freeze First Columns in Excel

Freezes the First column of a worksheet while rest of the worksheet scrolls. To do it, follow the steps below:

  1. First, enter the heading in the first column in a worksheet. For example, look at the picture below.
  2. Then go to the View tab
  3. And then click on the Freeze Panes in Excel Worksheet
  4. Afterwards, select the “Freeze First Column”
  5. Now Scroll the page to see the frozen area of the worksheet.
Freeze First Column in Excel

Freeze Panes in MS Excel – Freeze Rows and Columns in Excel

Unfreeze the Panes in Excel

To Unfreeze the pane after freezing the upper part, left part, or both parts of the rows and columns (column or first row in a sheet), click the “Unfreeze Panes”. The first option of the Freeze pane in ms excel turns as Unfreeze pane when you freeze the rows and columns in a worksheet.

Conclusion: As explained about Freeze Panes in MS-Excel | Freeze Rows and Columns in Excel, the use of freeze work is extremely efficient. In a worksheet, it is more difficult to work when there are more data than what appears on the screen. My suggestion is that freezing is only very helpful when there is a large amount of data. So, when you are working, choose a freeze option and hope to make it a habit. I repeat if it contains so much data that it is not easy to work with.

Related Posts:

  • Click to read the full article on Microsoft Word 2019, 2016, 2013, 2010, and 2007
  • Click here to read more about Create a Custom AutoFill Series List in Microsoft Excel
  • Ways to Apply Accounting Number Format in Excel
  • How to Add Zeros Before a Number in Excel
  • The Draw Tab in Word, Excel, and Ppt.

FAQ:

What are Freeze Panes in Excel?

Freezing the Upper, Left, or both parts of the Row and Column Headings to keep it visible while the rest of the worksheet scrolls up and down or left and right, called Freeze Panes.

How to Unfreeze Panes in MS Excel?

To Unfreeze the pane after freezing the upper part, left part, or both parts of the rows and columns (column or first row in a sheet), click the “Unfreeze Panes”. The first option of the Freeze pane in ms excel turns as Unfreeze pane when you freeze the rows and columns in a worksheet.

Recent Posts

  • How to Hide Featured Image On a WordPress Post/Page – 2022
  • YouTube Floating Window for Windows, Mac, and Mobiles
  • A Table Generator for Word and Office 360 – Shortcut Trick
  • How to Enable Missing Theme Editor and Plugin Editor in WP
  • (A-Z) Change Text Direction (Rotate, Flip or Mirror) in Word
  • How to Select Objects That are Behind Text in Word – 2022