+ Reply to Thread
Results 1 to 4 of 4

How do I print a single worksheet over 2 sides of a sheet when printing.

  1. #1
    Forum Contributor
    Join Date
    08-02-2005
    Location
    LONDON
    MS-Off Ver
    OFFICE365
    Posts
    167

    How do I print a single worksheet over 2 sides of a sheet when printing.

    Hi

    I have posted on here but got no answer yet.

    https://www.mrexcel.com/board/thread...sided.1176611/

    Please see below. Any suggestions as I need to get sorted asap.

    Hi

    I have this macro below and it prints too small and now want the sheet called "SHIFT SHEET" to print double sided . I need the following area printed on one side A1-J72 and on the other side print K1-S63

    Also I need it set up so it fits to the full page size as in on both sides.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: How do I print a single worksheet over 2 sides of a sheet when printing.

    The great asset of this site is to be able to attach Excel sample, see the yellow banner at the top.
    Can you do it, to be sure to understand the print as you are doing ...!
    In addition give details about the format used.
    - Battle without fear gives no glory - Just try

  3. #3
    Forum Contributor
    Join Date
    08-02-2005
    Location
    LONDON
    MS-Off Ver
    OFFICE365
    Posts
    167

    Re: How do I print a single worksheet over 2 sides of a sheet when printing.

    Apologies on that.

    I have attached the workbook and what im trying to do is where its in light shade I need that printing on one side and then I need the sheet to flip page on long edge and print the stuff on the other side that has data in a darker shading.

    I DO NOT need the shading to print as in the lines as its there for illustration purposes only, but DO need the cells where coloured yellow to print yellow.
    Attached Files Attached Files
    Last edited by tweacle; 07-17-2021 at 07:05 AM. Reason: file amended

  4. #4
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: How do I print a single worksheet over 2 sides of a sheet when printing.

    If you select the print area from B2 to I71
    Then select "Fit all columns on one page " in the print menu
    You will see that there is 2 pages to print: There is to many rows versus columns to print on one page.
    You need to adjust the ratio between nb of rows and total columns width, for the first page

+ 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. Set Printer & Print on both sides of paper
    By rcprito in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2014, 11:30 AM
  2. Replies: 0
    Last Post: 03-18-2012, 04:03 PM
  3. Printing sheets from listbox as a single print job
    By longrock in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-17-2011, 07:22 AM
  4. [SOLVED] how to print a complete workbook with multiple tabs on both sides
    By Michel Drouin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-09-2006, 02:45 PM
  5. [SOLVED] [SOLVED] Print correct Page X of Y when printing single worksheet
    By dbarrett44 in forum Excel General
    Replies: 3
    Last Post: 04-13-2006, 10:34 PM
  6. Printing Multiple Worksheets as a single print job
    By MGatESSInc in forum Excel General
    Replies: 0
    Last Post: 11-17-2005, 10:55 AM
  7. i want to print using both sides of A4 sheet
    By Rox in forum Excel General
    Replies: 4
    Last Post: 08-08-2005, 04: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