Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Printing one row at top of every page
I seem to remember being able to do this, but I can't say for certain and
can't remember for the life of me how. If I have one row [the one I have on my sheet is not Row 1, but if it needs to be I can make it Row 1], and I want that particular row to print on the top of every page [as it has the column descriptions for my sheet]. Anyone know how to do that? Any help would be great. Thanks Scott |
#2
|
|||
|
|||
Printing one row at top of every page
Go into File, Page Setup and click onto the Sheet tab.
Here, it says 'rows to repeat at top'. Click onto the row number of the one you want visible at the top of subsequent pages and choose OK. When you enter page breaks, you will not physically see the headings on the new pages, however, when you print your worksheet, the headings will print at the top of every page. HTH Louise "scottech" wrote: I seem to remember being able to do this, but I can't say for certain and can't remember for the life of me how. If I have one row [the one I have on my sheet is not Row 1, but if it needs to be I can make it Row 1], and I want that particular row to print on the top of every page [as it has the column descriptions for my sheet]. Anyone know how to do that? Any help would be great. Thanks Scott |
#3
|
|||
|
|||
Printing one row at top of every page
FilePage setupSheetRows to repeat at top
-- Kind regards, Niek Otten "scottech" wrote in message ... I seem to remember being able to do this, but I can't say for certain and can't remember for the life of me how. If I have one row [the one I have on my sheet is not Row 1, but if it needs to be I can make it Row 1], and I want that particular row to print on the top of every page [as it has the column descriptions for my sheet]. Anyone know how to do that? Any help would be great. Thanks Scott |
#4
|
|||
|
|||
Printing one row at top of every page
Super, thanks.
"Louise" wrote: Go into File, Page Setup and click onto the Sheet tab. Here, it says 'rows to repeat at top'. Click onto the row number of the one you want visible at the top of subsequent pages and choose OK. When you enter page breaks, you will not physically see the headings on the new pages, however, when you print your worksheet, the headings will print at the top of every page. HTH Louise "scottech" wrote: I seem to remember being able to do this, but I can't say for certain and can't remember for the life of me how. If I have one row [the one I have on my sheet is not Row 1, but if it needs to be I can make it Row 1], and I want that particular row to print on the top of every page [as it has the column descriptions for my sheet]. Anyone know how to do that? Any help would be great. Thanks Scott |
#5
|
|||
|
|||
Printing one row at top of every page
Thank you.
"Niek Otten" wrote: FilePage setupSheetRows to repeat at top -- Kind regards, Niek Otten "scottech" wrote in message ... I seem to remember being able to do this, but I can't say for certain and can't remember for the life of me how. If I have one row [the one I have on my sheet is not Row 1, but if it needs to be I can make it Row 1], and I want that particular row to print on the top of every page [as it has the column descriptions for my sheet]. Anyone know how to do that? Any help would be great. Thanks Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Page #s and bottom corner dates have disappeared in printing. | Excel Discussion (Misc queries) | |||
How can I do one-time printing without set page breaks? | Excel Discussion (Misc queries) | |||
Printing Recto/Verso | Excel Discussion (Misc queries) | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
Excel Web Page Printing | Excel Discussion (Misc queries) |