Keep Headers at top of page
 

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.

Keep Headers at top of page
 

Hi

Place cursor in C3 before Selecting Freeze Panes

--
Regards
Roger Govier

"RSteph" wrote in message
...
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




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

The message was checked by ESET Smart Security.

http://www.eset.com

Keep Headers at top of page
 

Select a cell , Freeze Panes, every thing left of and above the cell is
frozen. Please see Freeze in Excel Help.

RSteph wrote:

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.

Keep Headers at top of page
 

Click on cell C3, then click freeze panes selecting the first option (rows
and columns)
--
If this has helped you, please click Yes

Thanks,
Megan


"RSteph" wrote:

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.

Keep Headers at top of page
 

Select Cell C3 and then select freeze panes. This will freeze everything
above and to the left of your selected cell.

"RSteph" wrote:

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.

Keep Headers at top of page
 

Thank you to all that responded. That worked.

"RonaldoOneNil" wrote:

Select Cell C3 and then select freeze panes. This will freeze everything
above and to the left of your selected cell.

"RSteph" wrote:

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.