+ Reply to Thread
Results 1 to 1 of 1

How to set multiple-paged custom print area?

  1. #1
    Forum Contributor
    Join Date
    02-18-2020
    Location
    Ottawa, ON
    MS-Off Ver
    Professional Plus 2010
    Posts
    139

    Lightbulb How to set multiple-paged custom print area?

    Hi Everyone,

    With the help of this forum I have a macro that converts every sheet in my workbook to PDF's, and then emails them to me. This has worked out great so far, with the exception of the sheets that require 2 or more pages due to their size. I'm trying to figure out how I can set up a custom print area, so that I can choose exactly which cells will show up on page 1, and which ones will show up on page 2 (and page 3, etc..). At the moment though, I have been unable to add any page breaks that would mark where page 2 should start, which causes the PDF to be a single page of unreadable data since there's so many cells included in one page. Can you all help me figure out how to set up these custom print areas? Here's the things I've tried so far:
    - Inserting "Page Break" appears to do absolutely nothing no matter where I try to insert it.
    - Dragging the page break in the "page break view" to my desired cutoff point for page 1. When I do this, the rest of the sheet is simply omitted from the PDF entirely.

    I've attached some photos to explain -

    Photo 1: Shows the entire sheet as a single page on the print area
    Photo 2: The red line is where I want Page 2 to start
    Photo 3: What happens when I try simply dragging the page break to where I want page 2 to start. It doesn't appear that a "page 2" is automatically added for me.
    Attached Images Attached Images

+ 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. How to set custom print area for multiple pages?
    By Keegan1116 in forum Excel General
    Replies: 2
    Last Post: 05-03-2024, 09:30 AM
  2. [SOLVED] All data print in one sheet with Multiple Print Area seletion
    By rajeshn_in in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-10-2017, 11:49 AM
  3. Custom VBA Print Area on Excel Workbook
    By clprdctn in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-12-2014, 12:08 PM
  4. Replies: 2
    Last Post: 10-09-2014, 12:03 PM
  5. Replies: 1
    Last Post: 02-12-2013, 12:16 PM
  6. Replies: 8
    Last Post: 05-23-2007, 06:39 AM
  7. [SOLVED] set the print area print multiple tabs
    By veng in forum Excel General
    Replies: 5
    Last Post: 02-12-2005, 03:08 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