+ Reply to Thread
Results 1 to 6 of 6

Print pages 3,5 in 1 page

  1. #1
    Forum Contributor
    Join Date
    09-18-2011
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    375

    Print pages 3,5 in 1 page

    How to print non-consecutive pages (say 3,5) within one page (i.e. 2 in 1)?
    Last edited by london7871; 10-20-2011 at 01:30 AM.

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Print pages 3,5 in 1 page

    we'll be needing another sheet for printing.
    (use ctrl-c)copy the first sheet or select the 1st page(click and drag) then paste special - picturelink to the sheet for printing
    the same goes to the other page.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Print pages 3,5 in 1 page

    thats probably just a printer setting print pages 3,5 2 pages per sheet, depends on your printer tho.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  4. #4
    Forum Contributor
    Join Date
    09-18-2011
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    375

    Re: Print pages 3,5 in 1 page

    My excel's printer setting only allow print "page from # to #" or "All" ; cannot set print pages 3,5. So how to print "2 into 1"?

  5. #5
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Print pages 3,5 in 1 page

    Can you give me the model of your printer.

    If your printer do not support this features there is only one way to do that as my earlier post,use
    Hello
    the camera method.


    when using the Camera method, the picture inserted is not a static image, the contents of the graphic will change if you make changes to the original.

  6. #6
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Print pages 3,5 in 1 page

    heres one.
    i've experimented it on epson lx- 300
    1. select page 3 then select page page 5 holding down CTRL
    2. set print area
    3. Ctrl- P(Print) > Properties > Page format > pages per sheet >select 2
    4. click advance > page per sheet layout >> experiment here until arrive at the desired outcome.
    HTH.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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