+ Reply to Thread
Results 1 to 2 of 2

Excel sheet print copies

  1. #1
    Registered User
    Join Date
    06-06-2009
    Location
    Al-Khobar, Saudi Arabia
    MS-Off Ver
    Excel 2003
    Posts
    1

    Excel sheet print copies

    Dear All,

    I am newbie here, and am looking forward for all your help.

    I have one excel sheet that each time I wanted to print, it always printed two copies unless I have to open the printer setting, under copies and change from 2 pages to 1 page. It is not default setting issue, because other excel sheets and files displayed one (1) page only under the printer setting.

    I am confuse... and start asking myself why I'm having this auto selected 2 pages for a certain file? Can anyone help me please...

    Thank you very much in advance for your kind help.

    Jerry

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097

    Re: Excel sheet print copies

    Hi,

    Welcome to the forum, maybe you have some "ghost" data left on your sheet below or to the right of your visable data?

    If you select the row below the last row of data, then press Ctrl+Shift+Down Arrow, then press Delete.

    Then select the column to the right of your last filled column, then press Ctrl+Shift+Right Arrow, then press Delete.

    Now save the file, click Print Preview. Do you have one page now?
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

+ 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