Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Repeat rows on top - in worksheet - not printing!
How do I repeat my column headings so that they are visible when I scroll
down my worksheet? I know how to set this up for printing (page setupsheetrepeat rows on top), but how do you get them to show up in your worksheet? Thank you very much for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Repeat rows on top - in worksheet - not printing!
One way - say, if your headings are from A1:F1 and A1:A50, click on B2 click
on Window freeze panes. Thanks. -- when u change the way u look @ things, the things u look at change. "Jane25" wrote: How do I repeat my column headings so that they are visible when I scroll down my worksheet? I know how to set this up for printing (page setupsheetrepeat rows on top), but how do you get them to show up in your worksheet? Thank you very much for your help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Repeat rows on top - in worksheet - not printing!
You can freeze the headings at the top of the screen, so that as you scroll
down they are always visible. To do this, first position your cursor in the first cell below the area that the want to freeze - often this will be in A2 if your headings are on row 1. Then click on Window | Freeze Panes. Press <Page Down a few times to see the effect. If you also want to freeze the left hand column (where you might have some labels), then you can position your cursor in B2 before doing Window|Freeze Panes. Hope this helps. Pete "Jane25" wrote in message ... How do I repeat my column headings so that they are visible when I scroll down my worksheet? I know how to set this up for printing (page setupsheetrepeat rows on top), but how do you get them to show up in your worksheet? Thank you very much for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy a worksheet to new one with repeat rows 5 times | Excel Discussion (Misc queries) | |||
Repeat printing rows in multiple worksheets | Excel Discussion (Misc queries) | |||
printing issue - want to repeat two rows and also 5 rows in column | Excel Discussion (Misc queries) | |||
Repeat rows on bottom when printing in Excel | Excel Discussion (Misc queries) | |||
how do I repeat rows at foot of worksheet? | Excel Discussion (Misc queries) |