+ Reply to Thread
Results 1 to 11 of 11

Keep first row when printing multiple pages

  1. #1
    Forum Contributor
    Join Date
    11-23-2015
    Location
    Yada, Wales
    MS-Off Ver
    Office 2013
    Posts
    176

    Keep first row when printing multiple pages

    See attached file.

    How can I print multiple pages but still keep row 1-4 as the first rows in each page?
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,406

    Re: Keep first row when printing multiple pages

    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.

  3. #3
    Forum Contributor
    Join Date
    11-23-2015
    Location
    Yada, Wales
    MS-Off Ver
    Office 2013
    Posts
    176

    Re: Keep first row when printing multiple pages

    How is this done with VBA?

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,406

    Re: Keep first row when printing multiple pages

    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?

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Keep first row when printing multiple pages

    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


  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Keep first row when printing multiple pages

    @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.

  7. #7
    Forum Contributor
    Join Date
    11-23-2015
    Location
    Yada, Wales
    MS-Off Ver
    Office 2013
    Posts
    176

    Re: Keep first row when printing multiple pages

    It works!

    Thank you so much!
    Last edited by jokris; 04-23-2016 at 10:02 AM.

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,406

    Re: Keep first row when printing multiple pages

    Quote Originally Posted by TMS View Post
    @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.
    Yes, this is true, of course!

  9. #9
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Keep first row when printing multiple pages

    @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.

  10. #10
    Forum Contributor
    Join Date
    11-23-2015
    Location
    Yada, Wales
    MS-Off Ver
    Office 2013
    Posts
    176

    Re: Keep first row when printing multiple pages

    After first page for each range, would it be possible to print only 50 rows on each page?

  11. #11
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Keep first row when printing multiple pages

    Different question. Nothing to do with repeating header rows. Please start a new thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Printing multiple pages from different Worksheets into single PDF
    By Chris87 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-10-2014, 07:17 PM
  2. Printing multiple pages on one Page
    By Befuddled in forum Excel General
    Replies: 17
    Last Post: 02-08-2014, 11:42 PM
  3. Printing Macro for multiple pages
    By jsneak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2014, 05:33 AM
  4. Printing multiple pages per sheet
    By fusse in forum Excel General
    Replies: 2
    Last Post: 01-22-2014, 03:29 PM
  5. Printing Selected Pages from Multiple Worksheets into One Print Job
    By KivanAtaris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-16-2013, 03:20 PM
  6. Replies: 7
    Last Post: 12-28-2012, 03:10 PM
  7. Multiple pages after printing selected area
    By Lynn in forum Excel General
    Replies: 1
    Last Post: 04-17-2006, 11:28 AM
  8. Printing Multiple Pages Based on Different Cell Criteria
    By Nic W in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-20-2005, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1