How do I freeze column headings in Microsoft Excel?

Question

I know about the Freeze Panes feature, but I only want to freeze the column headings. I know it can be done but I can't figure it out. Thanks!

It worked! Thanks! Anthony was the first with the correct answer so I'll choose his answer in four hours or whenever Answers lets me.

Answer 1

Select the first cell in the row beneath the heading (likely A2) and go to Window --> Freeze Panes. If you select cell B2, then the first column and row will freeze.

Answer 2

click on column below where you want to freeze than do the window Freeze.
I am guessingyou want only column 1 to freeze so go to CellA2
If youare at B2 than Column a and row 1 would freeze
Everything to the top and the left of the cell you are in freezes

Answer 3

To "freeze" the first row, or column headings, position the cursor in A1, click Window, cl Freeze Panes.

To have the column header row repeat as you scroll down, go to File, Page Setup. Click the sheet tab. Where it says "row to repeat at top," type $1:$1 (that's dollar sign 1 colon dollar sign 1)
Then click o.k.

Answer 4

Click on the row under where you want it frozen, to highlight the entire row. Then go to Window on the menubar and select Freeze Panes. It will freeze it on the line above where you highlighted.

Answer 5

http://office.microsoft.com/en-us/excel/HP052038611033.aspx