| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
repeat first row at the top of page?
How do you make row 1 repeat itself in the worksheet? I.E. As you scroll down
the page, row one will always be at the top of the worksheet. I can make it repeat itself as the first line on each new page, but I need it be at the top of the worksheet as I scroll down so I can easily see the column headings. |
|
#2
|
|||
|
|||
|
One way of doing this is with 'freeze panes'. If you want Row 1 to always be visible click in Cell A2, go to Window Freeze panes. If you wanted it to show the columns as well, then perform the same, but have cell B2 selected. It won't change the way that the document prints however. Hope this helps, Hywel Manchester UK -- Hywel ------------------------------------------------------------------------ Hywel's Profile: http://www.excelforum.com/member.php...o&userid=14824 View this thread: http://www.excelforum.com/showthread...hreadid=345804 |
|
#3
|
|||
|
|||
|
Thanks champ, that's what I'm after!
"Hywel" wrote: One way of doing this is with 'freeze panes'. If you want Row 1 to always be visible click in Cell A2, go to Window Freeze panes. If you wanted it to show the columns as well, then perform the same, but have cell B2 selected. It won't change the way that the document prints however. Hope this helps, Hywel Manchester UK -- Hywel ------------------------------------------------------------------------ Hywel's Profile: http://www.excelforum.com/member.php...o&userid=14824 View this thread: http://www.excelforum.com/showthread...hreadid=345804 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
repeat first row at the top of page?
"dumo13" wrote: How do you make row 1 repeat itself in the worksheet? I.E. As you scroll down the page, row one will always be at the top of the worksheet. I can make it repeat itself as the first line on each new page, but I need it be at the top of the worksheet as I scroll down so I can easily see the column headings. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
repeat first row at the top of page?
"dumo13" wrote: How do you make row 1 repeat itself in the worksheet? I.E. As you scroll down the page, row one will always be at the top of the worksheet. I can make it repeat itself as the first line on each new page, but I need it be at the top of the worksheet as I scroll down so I can easily see the column headings. |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
repeat first row at the top of page?
curious wrote:
"dumo13" wrote: How do you make row 1 repeat itself in the worksheet? I.E. As you scroll down the page, row one will always be at the top of the worksheet. I can make it repeat itself as the first line on each new page, but I need it be at the top of the worksheet as I scroll down so I can easily see the column headings. Place the cursor in cell A2 and select Window | Freeze Panes. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| content does not stay in page break | Excel Worksheet Functions | |||
| How do I keep page breaks for each page in a sheet without the co. | Excel Discussion (Misc queries) | |||
| make first few rows print on every page? | New Users to Excel | |||
| how to have excel repeat a template on each page of each workshee. | Excel Discussion (Misc queries) | |||
| excel 2003 page numbering | Excel Worksheet Functions | |||
Linear Mode
