How do I freeze both a column and a row in Excel?

Freeze columns and rows

1. Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
2. Select View > Freeze Panes > Freeze Panes.

How do I freeze horizontal and vertical panes in Excel 2007?

To freeze horizontal and vertical headings simultaneously:

1. Select the cell in the upper-left corner of the range you want to remain scrollable.
2. Select View tab, Windows Group, click Freeze Panes from the menu bar.
3. Excel inserts two lines to indicate where the frozen panes begin.

How do I freeze first row and first column in Excel 2007?

To freeze the first row and column, open your Excel spreadsheet. Select cell B2. Then select the View tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Window group. Then click on the Freeze Panes option in the popup menu.

How do you freeze and unfreeze rows and columns in Excel 2007?

Select the View tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Windows group. Then click on the Unfreeze Panes option in the popup menu. Now when you move around in your spreadsheet, columns and rows should display as normal.

How do I freeze a row in Excel 2007?

To freeze the top row, open your Excel spreadsheet. Select the View tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Window group. Then click on the Freeze Top Row option in the popup menu. Now when you scroll down, you should still continue to see the column headings.

How do you freeze columns A and B and rows 1 and 2?

To freeze rows:

1. Select the row below the row(s) you want to freeze. In our example, we want to freeze rows 1 and 2, so we’ll select row 3.
2. Click the View tab on the Ribbon.
3. Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.
4. The rows will be frozen in place, as indicated by the gray line.

How do I lock a column in Excel 2007?

Right-click and then select “Format Cells” from the popup menu. When the Format Cells window appears, select the Protection tab. Check the “Locked” checkbox. Click the OK button.

How do I freeze a column in Excel 2007?

Follow these steps to freeze panes in a worksheet:

1. Position the cell cursor based on what you want to freeze:
2. In the Window group of the View tab, choose Freeze Panes→Freeze Panes.
3. In the Window group of the View tab, choose Freeze Panes→Unfreeze Panes to unlock the fixed rows and columns.

How do you freeze selected rows in Excel?

Freezing a Row Select the row below the row you want to freeze. To select a row, you need to select the entire row on the left side. With the row selected, click on the “View” tab at the top, select “Freeze Panes” and you’ll see several different options you can choose: “Freeze Panes” will freeze all rows above your selected row.

How do you lock rows in Excel?

1) Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. 2) Select View > Freeze Panes > Freeze Panes. See More…

What is frozen in Excel?

Freezing is a way of keeping rows or columns visible at all times, even if you scroll down. With freezing rows in Excel, you can keep the topmost row, leftmost column, or any number or rows/columns within the excel sheet in view all the time.