Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Headers on only first page and Footers on only last page | Excel Discussion (Misc queries) | |||
printing headers on every page | Excel Discussion (Misc queries) | |||
Repeating the Row Headers on each page | Excel Discussion (Misc queries) | |||
1st page only Headers & Footers | Excel Discussion (Misc queries) | |||
Custom Page Headers | Excel Discussion (Misc queries) |