+ Reply to Thread
Results 1 to 3 of 3

Printing Problem / Extra Column

  1. #1
    Forum Contributor
    Join Date
    03-30-2008
    Posts
    121

    Printing Problem / Extra Column

    When I print my worksheet it is extending over and printing
    an extra column. It should be a 52 page document which
    is extended to 104 pages and the last 52 pages are only
    one blank column.

    I have adjusted my PageSettings every which way from Sunday
    and I still can't eliminate the one last column.

    Any suggestions where I might start to find the problem?

    Thanks.

  2. #2
    Valued Forum Contributor Dunc3142's Avatar
    Join Date
    09-05-2007
    Location
    Franklin OH
    MS-Off Ver
    2000 and 2007 and 2010 @ Home & Teach 2010
    Posts
    351

    Set your print area

    If you set a print area, only the cells in the print area are printed.
    How you do this depends on what version Excel you are using
    2000
    XP
    2003
    2007
    Yes it will. we just have to figure out how...
    If I have helped you, PLEASE click the * and add to my Rep.
    Also, if the problem is SOLVED please mark it as so.

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582
    Excel believes there is data to the right of the your last column of data. Sometimes this happens if you entered something in there and it was later deleted. If your last column of data is in E; highlight column F and Hold down the CNTROL SHFT and Left arrow keys. That should highlight all the columns to the right of your data. Now Right click inside that area and chose delete.
    Now do a print preview. Did that work?

    ChemistB

+ 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