Since I'm in heare.

  • Thread starter Thread starter MS User
  • Start date Start date
M

MS User

I have a SS that I'd like to have the first x rows (in my case 3) printed on
each page. Not a Page Header (as I already have one).

I've already got the Print Area Set, Orientation etc.

How would I do this?

Thanks.
 
<File> <Page SetUp> <Sheet> tab,
And enter the row numbers in the "Rows To Repeat At Top" box.
i.e. ... 1:3
 
Thanks Dave, I suspected something like that. I guess rule of thumb, Press
Every Button you can see.

Again, Thanks
 

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

Similar Threads

Access Sorting and grouping using multiple tables 0
Access Page Header with merge field 0
Printer selection in VBA 1
PowerPoint Super Stuck and Desperately Need Help 0
Printing footnotes in Excel - active printed area 1
form monitors users activity on sheet 2
Excel print area which only prints pages of worksheet which are active 0
Excel I have a large (62pages) excel file that needs to be sent as a pdf but it is only exporting half !? 2

Back
Top