I was struggling with how to freeze both a column and row selection at the same time. I couldn't find hte answer in the 2007 help files. However a search in Office online answered the problem. I thought I would share it:

From:
http://office.microsoft.com/en-us/ex...038611033.aspx

Freeze or lock rows and columns
Applies to: Microsoft Office Excel 2003 (also works with 2007)

You can view two areas of a worksheet and lock rows or columns in one area by splitting or freezing panes (pane: A portion of the document window bounded by and separated from other portions by vertical or horizontal bars.). When you split panes, you'll be able to scroll in both areas of the worksheet, while rows or columns in the non-scrolled area remain visible.

When you freeze panes, you select specific rows or columns that remain visible when scrolling in the worksheet. For example, you would freeze panes to keep row and column labels visible as you scroll, as shown in the following picture.

=========================================
Lock rows and columns by splitting panes

To lock rows, select the row below where you want the split to appear.
To lock columns, select the column to the right of where you want the split to appear.

To lock both rows and columns, click the cell below and to the right of where you want the split to appear.

On the Window menu, click Split.
To remove the split, click Remove Split on the Window menu.

Tip
For a quick way to split panes, point to the split box at the top of the vertical scroll bar or at the right end of the horizontal scroll bar.


When the pointer changes to a split pointer, drag the split box down or to the left to the position you want.

============================================
Lock rows and columns by freezing panes

To lock rows, select the row below where you want the split to appear.
To lock columns, select the column to the right of where you want the split to appear.

To lock both rows and columns, click the cell below and to the right of where you want the split to appear.

On the Window menu, click Freeze Panes.
To unlock rows, click Unfreeze Panes on the Window menu.