See attached file.
How can I print multiple pages but still keep row 1-4 as the first rows in each page?
See attached file.
How can I print multiple pages but still keep row 1-4 as the first rows in each page?
Go to the Page Layout ribbon and select Print Titles - set your header rows in the resulting dialog.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
How is this done with VBA?
I have no idea, sorry. I did not realise that you wanted a VBA solution. What is wrong with using the in-built dialog for this?
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
@Ali: you can just record a macro while you set it up. You get a load of stuff you don't need but you can delete that.
It works!
Thank you so much!
Last edited by jokris; 04-23-2016 at 10:02 AM.
@Ali: Indeed
@jokris: You're welcome. Thanks for the rep.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
After first page for each range, would it be possible to print only 50 rows on each page?
Different question. Nothing to do with repeating header rows. Please start a new thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks