How to Freeze Cells in Excel: 9 Steps (with Pictures)

Table of contents:

How to Freeze Cells in Excel: 9 Steps (with Pictures)
How to Freeze Cells in Excel: 9 Steps (with Pictures)

Video: How to Freeze Cells in Excel: 9 Steps (with Pictures)

Video: How to Freeze Cells in Excel: 9 Steps (with Pictures)
Video: 2-Sided Printing in Microsoft Word for Mac 2024, November
Anonim

This wikiHow teaches you how to freeze specific rows and columns in a Microsoft Excel worksheet. By freezing a row or column, certain boxes will remain visible as you scroll through a page containing data. If you want to easily edit two parts of a spreadsheet at the same time, separate spreadsheet panes or windows to make editing easier.

Step

Method 1 of 2: Freezing First Column or Row

Freeze Cells in Excel Step 1
Freeze Cells in Excel Step 1

Step 1. Click the View tab

This tab is at the top of the Excel window. The frozen boxes are rows or columns that remain displayed when you scroll the worksheet. If you want column headings or row labels to remain visible when working with or managing large amounts of data, it's a good idea to lock or freeze the boxes.

You can only freeze one row or column in its entirety. It is not possible to freeze certain columns separately

Freeze Cells in Excel Step 2
Freeze Cells in Excel Step 2

Step 2. Click the Freeze Panes button

It's in the "Window" section of the toolbar. A set of three freeze options will be displayed.

Freeze Cells in Excel Step 3
Freeze Cells in Excel Step 3

Step 3. Click Freeze Top Row or Freeze First Column.

If you want the top row of boxes to be frozen or remain displayed as you scroll the page, select “ Freeze Top Row To freeze or display the first column when you scroll the page horizontally, select “ Freeze First Column ”.

Freeze Cells in Excel Step 4
Freeze Cells in Excel Step 4

Step 4. Open the frozen boxes

If you want to open or "thaw" frozen boxes, click the " Freeze Panes " and select " Unfreeze Panes ”.

Method 2 of 2: Freezing Multiple Columns or Rows

Freeze Cells in Excel Step 5
Freeze Cells in Excel Step 5

Step 1. Select the row or column after the rows or columns that you need to freeze

If the data you want to keep showing takes up more than one row or column, click the column letter or row number after the columns or rows you want to freeze. As an example:

  • If you want to keep showing rows “1”, “2”, and “3” when scrolling through pages containing data, click row “

    Step 4.' to select it.

  • If you want to keep the “A” and “B” columns displayed when scrolling the screen sideways/horizontally, click the “ C' to select it.
  • The frozen squares should connect to the top or left corner of the spreadsheet. You cannot freeze rows or columns that are in the middle of a sheet.
Freeze Cells in Excel Step 6
Freeze Cells in Excel Step 6

Step 2. Click the View tab

This tab is at the top of the Excel window.

Freeze Cells in Excel Step 7
Freeze Cells in Excel Step 7

Step 3. Click the Freeze Panes button

It's in the "Window" section of the toolbar. A set of three freeze options will be displayed.

Freeze Cells in Excel Step 8
Freeze Cells in Excel Step 8

Step 4. Click Freeze Panes on the menu

It's at the top of the menu. Columns or rows before the selected column or row will be frozen.

Freeze Cells in Excel Step 9
Freeze Cells in Excel Step 9

Step 5. Open the frozen boxes

If you want to open or "thaw" frozen boxes, click the " Freeze Panes " and select " Unfreeze Panes ”.

Recommended: