How to Freeze and Unfreeze Panes in Excel

Chủ nhật - 05/05/2024 23:24
When you freeze a column or a row, it will stay visible when you're scrolling through that worksheet, which is a useful tool when you're comparing data. When you freeze columns or rows, they are referred to as "panes." This wikiHow will...
Table of contents

When you freeze a column or a row, it will stay visible when you're scrolling through that worksheet, which is a useful tool when you're comparing data. When you freeze columns or rows, they are referred to as "panes." This wikiHow will show you how to freeze and unfreeze panes to lock rows and columns in Excel.

Method 1
Method 1 of 3:

Freezing a Single Panel

  1. Step 1 Open your project in Excel.
    You can either open the program within Excel by clicking File > Open, or you can right-click the file in your file explorer.
    • This will work for Windows and Macs using Excel for Office 365, Excel for the web, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007.[1]
  2. Step 2 Select a cell to the right of the column you want to freeze.
    The frozen columns will remain visible when you scroll through the worksheet.
    • You can press Ctrl or Cmd as you click a cell to select more than one, or you can freeze each column individually.
    Advertisement
  3. Step 3 Click View.
    You'll see this either in the editing ribbon above the document space or at the top of your screen.
  4. Step 4 Click Freeze Panes.
    A menu will drop-down.
  5. Step 5 Click Freeze Panes.
    This will freeze the panes in the columns next to what you have selected.[2]
    • You'll notice when you freeze panes if you scroll away and a column or row stays on the screen.
    6. Advertisement
Method 2
Method 2 of 3:

Freezing Multiple Panels

  1. Step 1 Open your project in Excel.
    You can either open the program within Excel by clicking File > Open, or you can right-click the file in your file explorer.
    • This will work for Windows and Macs using Excel for Office 365, Excel for the web, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007.[3]
  2. Step 2 Select a cell to the right of the column you want to freeze.
    The frozen columns will remain visible when you scroll through the worksheet.
  3. Step 3 Press the Ctrl or ⌘ Cmd key as you click.
    All the cells you click will be added to your selection when you have that key pressed.
    • You can release the key when you are done making your selections.
  4. Step 4 Click View.
    You'll see this either in the editing ribbon above the document space or at the top of your screen.
  5. Step 5 Click Freeze Panes.
    A menu will dropdown.
  6. Step 6 Click Freeze Panes.
    This will freeze the panes in the columns next to what you have selected.[4]
    • You'll notice when you freeze panes if you scroll away and a column or row stays on the screen.
    7. Advertisement
Method 3
Method 3 of 3:

Unfreezing Panes

  1. Step 1 Open your project in Excel.
    You can either open the program within Excel by clicking File > Open, or you can right-click the file in your file explorer.
  2. Step 2 Go to View.
    You'll see a drop-down menu.
  3. Step 3 Click Freeze Panes.
    It's next to Arrange All and Split/Hide towards the right side of the toolbar.
  4. Step 4 Click Unfreeze Panes.
    This will unfreeze all the cells that you have frozen on the screen.
    5. Advertisement

Total notes of this article: 0 in 0 rating

Click on stars to rate this article

Related New

Related

Lastest News

How to Store Electronic Parts

How to Store Electronic Parts

06/05/2024Computers and Electronics
How to Fix Oculus Controllers That Are Not Responding

How to Fix Oculus Controllers That Are Not Responding

06/05/2024Computers and Electronics
How to Run Powershell

How to Run Powershell

06/05/2024Computers and Electronics
How to Get Data from .Nbf Files

How to Get Data from .Nbf Files

06/05/2024Computers and Electronics
Upgrading RAM on a Macbook Pro: Expert Tips & Suggestions

Upgrading RAM on a Macbook Pro: Expert Tips & Suggestions

06/05/2024Computers and Electronics

Popuplar News

How to Contact Klook

How to Contact Klook

05/07/2024Travel
What Does Islam Say about Dream Interpretation?

What Does Islam Say about Dream Interpretation?

05/07/2024Philosophy and Religion
How to Contact Priceline

How to Contact Priceline

05/07/2024Travel
How to Compost in an Apartment

How to Compost in an Apartment

05/07/2024Home and Garden
How to Become an Accountant

How to Become an Accountant

05/07/2024Finance and Business