Keep Headers at top of page

  • Thread starter Thread starter RSteph
  • Start date Start date
R

RSteph

I know of the "Freeze" function in Excel, but is there anyway to select the
number of rows to freeze? I've got 2 rows on the top, and 2 columns on the
left that I would like to "Freeze" in place, so they always appear on the
screen. I've been playing with the Freeze row feature, but it seems like I
can get only either the top 1 row, or the top 6 rows, but not just the top 2.
I am using Excel 2007.

Any help would be greatly appreciated. Thank you.
 
Hi

Place cursor in C3 before Selecting Freeze Panes

--
Regards
Roger Govier

RSteph said:
I know of the "Freeze" function in Excel, but is there anyway to select
the
number of rows to freeze? I've got 2 rows on the top, and 2 columns on the
left that I would like to "Freeze" in place, so they always appear on the
screen. I've been playing with the Freeze row feature, but it seems like I
can get only either the top 1 row, or the top 6 rows, but not just the top
2.
I am using Excel 2007.

Any help would be greatly appreciated. Thank you.

__________ Information from ESET Smart Security, version of virus
signature database 4533 (20091022) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...

__________ Information from ESET Smart Security, version of virus signature database 4533 (20091022) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
Select a cell , Freeze Panes, every thing left of and above the cell is
frozen. Please see Freeze in Excel Help.
 
Select Cell C3 and then select freeze panes. This will freeze everything
above and to the left of your selected cell.
 
Thank you to all that responded. That worked.

RonaldoOneNil said:
Select Cell C3 and then select freeze panes. This will freeze everything
above and to the left of your selected cell.
Click to expand...
 
Back
Top