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
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
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.
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 ”.
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
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.
Step 2. Click the View tab
This tab is at the top of the Excel window.
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.
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.
Step 5. Open the frozen boxes
If you want to open or "thaw" frozen boxes, click the " Freeze Panes " and select " Unfreeze Panes ”.