Keep Headers at top of page

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.
 
R

Roger Govier

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

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

The message was checked by ESET Smart Security.

http://www.eset.com
 
B

Bob I

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

Megan

Click on cell C3, then click freeze panes selecting the first option (rows
and columns)
 
R

RonaldoOneNil

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

RSteph

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top