As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Freeze Cells in Excel: Step-by-Step Guide

Freezing cells in Excel is a valuable feature that keeps specific rows or columns visible while scrolling through a large worksheet. This step-by-step guide covers two common methods for freezing cells in Excel: using the Freeze Panes feature and the Split Screen feature.

What is Cell Freezing?

Cell freezing in Excel allows users to keep a set of cells visible at all times, enhancing efficiency when working with extensive data sets.

Method 1: Freeze Panes

  1. Open Excel Workbook:
  2. Launch Excel and open the workbook containing the data you want to work with.
  3. Select the Top-Left Cell:
  4. Click on the cell that will be the top-left cell of your frozen pane.
  5. Navigate to the View Tab:
  6. Click on the "View" tab located on the ribbon at the top of the Excel window.
  7. Access Freeze Panes:
  8. Click on the "Freeze Panes" button in the ribbon.
  9. Freeze Panes Option:
  10. Select the "Freeze Panes" option from the dropdown menu.
  11. Cell Freezing:
  12. Your selected cell is now frozen, and it will remain visible while scrolling through the worksheet.

Method 2: Split Screen

  1. Open Excel Workbook:
  2. Launch Excel and open the workbook containing the data you want to work with.
  3. Select the Top-Left Cell:
  4. Click on the cell that will be the top-left cell of your frozen pane.
  5. Navigate to the View Tab:
  6. Click on the "View" tab located on the ribbon at the top of the Excel window.
  7. Access Split Screen:
  8. Click on the "Split Screen" button in the ribbon.
  9. Split Screen Option:
  10. Select the "Split" option from the dropdown menu.
  11. Cell Freezing:
  12. Your selected cell is now frozen, and it will remain visible while scrolling through the worksheet.

How to Unfreeze Cells in Excel

Method 1: Unfreeze Panes

  1. Open Excel Workbook:
  2. Launch Excel and open the workbook containing the frozen cells.
  3. Navigate to the View Tab:
  4. Click on the "View" tab located on the ribbon at the top of the Excel window.
  5. Access Unfreeze Panes:
  6. Click on the "Unfreeze Panes" button in the ribbon.
  7. Unfreeze Panes Option:
  8. Select the "Unfreeze Panes" option from the dropdown menu.
  9. Your cells are now unfrozen, and you can scroll through the worksheet as usual.

Method 2: Remove Split Screen

  1. Open Excel Workbook:
  2. Launch Excel and open the workbook containing the frozen cells.
  3. Navigate to the View Tab:
  4. Click on the "View" tab located on the ribbon at the top of the Excel window.
  5. Access Split Screen:
  6. Click on the "Split Screen" button in the ribbon.
  7. Remove Split Screen:
  8. Select the "Remove Split" option from the dropdown menu.
  9. Your cells are now unfrozen, and you can scroll through the worksheet as usual.