+ Reply to Thread
Results 1 to 2 of 2

How can I add a blank page in my worksheet?

  1. #1
    Registered User
    Join Date
    10-23-2013
    Location
    North Carolina, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    How can I add a blank page in my worksheet?

    I need to add a blank page, in my worksheet, before printing so that the rest of the pages print correctly. This worksheet is a monthly calendar planner with each month covering two pages. January, for example, has half of the month (left side) on the first page and the second half (right side) on the next page. I've already changed the page sort order to "over then down" but I need a blank page to start so that I can print these pages front and back (on one sheet of paper). What I would like to end up with is a blank piece of paper, with the left side of January on the back. Then the right side of January on the front of the next page and the left side of February on the back and so on. That way, when finished, the pages can be three ring punched and inserted into a binder as a monthly planner. I'm stumped on the blank page though. Thanks for any help!

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: How can I add a blank page in my worksheet?

    ...Well, if it was me I would print one month/page on 11x17 paper instead, but if that's not possible...

    I couldn't figure out an easy way to do this in excel, so I would do it by printing out to PDF with CutePDF or something, and then I'd append a "dummy" front page on the PDF document with something like PDFBinder, and that's what I'd send to the printer to print double-sided, from my PDF reader.

    Well, it might be possible to do it with excel, but, I would put the amount of time I spent processing the excel=>PDF=>printer on one end of a scale and the amount of time I would spend wrangling the excel on the other, and then whichever one is lighter would win.

+ 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. Replies: 1
    Last Post: 08-26-2013, 07:44 PM
  2. Automatically adding a blank page at the end of sheets with page count odd
    By NewDawn999 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-15-2013, 02:33 PM
  3. Hide Column & Print page Macro printing blank page?!
    By Margate in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2013, 03:59 PM
  4. Opening a worksheet only opens a blank page.
    By whitesidehasdon in forum Excel General
    Replies: 5
    Last Post: 07-04-2008, 06:08 PM
  5. Replies: 2
    Last Post: 06-30-2005, 05:05 PM

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