+ Reply to Thread
Results 1 to 3 of 3

Excel Printing in Half Pages

  1. #1
    Registered User
    Join Date
    03-11-2010
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    5

    Excel Printing in Half Pages

    I've been struggling with this for a while. I think this is an issue with both Excel and my printer.

    I have a workbook with 30 different worksheets that are all the same. There are 20 columns wide and set at a print area of 1 page by 1 page. Some of the worksheets print great, but for others I get a page that prints the second half of the columns (K through T).

    When I email the document to another computer, it prints just fine.

    Because I am getting some worksheets to print just fine, I have to think there is a setting in Excel that is throwing off the other worksheets, but that is just speculation.

    Please help!

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Excel Printing in Half Pages

    The worksheet(s) may be set to print 1 page x 1 page, but is there a print area that is set to only select columns K:T? When you print preview those sheets, do they look wrong too?

    To check for erroneous print areas, open one of the offending worksheets and on the Page Layout tab click Print Area -> Clear Print Area. Try Print Preview again to see if it's fixed. If not, try uploading one of the offending workbooks to the site for review. You can remove any confidential data, but put in filler data where data should exist.

  3. #3
    Registered User
    Join Date
    03-11-2010
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Excel Printing in Half Pages

    Thanks for the response! I tried to clear theprint area, but it didn't seem to fix anything. However, I will say that I suddenly realized that some of the work sheets had the print quality drop down left blank while the others were at 600 dpi. I changed them all to 600 dpi and I haven't had a problem yet.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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