+ Reply to Thread
Results 1 to 2 of 2

Removing blank rows for printing

  1. #1
    Registered User
    Join Date
    12-23-2011
    Location
    Brandon, Vermont
    MS-Off Ver
    Excel 2007
    Posts
    12

    Removing blank rows for printing

    Hello, I tried searching for this answer but am not having any luck. Seems like it should be an easy thing. I have a workbook with 38 sheets. I need to convert it to a pdf so customers can print it if needed. After conversion, it has 2 blank pages between each sheet. How can I get it to ignore the blank rows & columns. The sheet with the most rows has 186, most are in the 60-70 range. No columns beyond "E" are used either. I appreciate any help provided!

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    459

    Re: Removing blank rows for printing

    First start out using Print Preview in Excel. This may show you why you have blank pages. If there is too much info in the columns, try using Shrinking (fit all Columns to One Page). You may also nee to change your margins? Also, check out how you display the data by going to: VIEW / Page Break view - this may also show you how and why it is printing the way it is. If there are empty rows in the worksheet, then delete them. Without seeing the file, it's hard to assist.

+ 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. [SOLVED] Removing blank rows VBA
    By bigjdawg43 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-30-2018, 03:18 PM
  2. Removing rows that appear to have blank cells
    By pr1m35 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-02-2010, 06:42 PM
  3. [SOLVED] Removing blank rows
    By Bob in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-20-2006, 07:55 PM
  4. Removing Rows for Printing
    By Frick in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 03-10-2006, 07:00 PM
  5. Removing Blank Rows
    By inveni0 in forum Excel General
    Replies: 4
    Last Post: 02-05-2006, 06:15 AM
  6. [SOLVED] Removing blank rows
    By Carlton Patterson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-17-2005, 07:05 AM
  7. [SOLVED] Removing blank rows
    By in forum Excel General
    Replies: 2
    Last Post: 03-15-2005, 11:51 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