+ Reply to Thread
Results 1 to 11 of 11

Printing filling the entire page

  1. #1
    Registered User
    Join Date
    06-12-2007
    Posts
    11

    Printing filling the entire page

    I'm trying to scale a worksheet so that when it prints it fills the entire A4 page.

    I have used under the print preview menu - page setup option the fit to 1 page with by 1 page tall option. This creates a blank space at the bottom of printed area.

    Is there any way I can get Excel to stretch the vertically side of things so that it fills the entire page?

    Any help will be very much appreciated.

    Many thanks
    John

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Try going into Page Setup and closing the margins down to zero, bearing in mind that you can not print to the edges exactly as there will always be a slight margin.
    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

  3. #3
    Registered User
    Join Date
    06-12-2007
    Posts
    11
    Quote Originally Posted by oldchippy
    Try going into Page Setup and closing the margins down to zero, bearing in mind that you can not print to the edges exactly as there will always be a slight margin.
    Thanks for the reply. Just tried it and it does make the printing bigger, but there is still a huge cap below.

    It is not as though the worksheet is all that small in terms of the number of rows as its 24 in total with each row about 21.75 points high.

    To make matters worse my sheet was originally produced in Lotus 123 and the same layout fills the printed sheet when printed - so 123 can do it but can Excel?

  4. #4
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Have you set your print area to 24 rows deep by "x" column wide, in other words just the data you see on the screen, or is the print area set to something bigger?

  5. #5
    Registered User
    Join Date
    06-12-2007
    Posts
    11

    Question

    Quote Originally Posted by oldchippy
    Have you set your print area to 24 rows deep by "x" column wide, in other words just the data you see on the screen, or is the print area set to something bigger?
    Yes I've set the print area to just be the data on the worksheet. Interesting problem isn't it?

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

    Is it possible you could provide a zipped sample of your spreadsheet and I’ll have a look to see if I can spot what the problem is?

    To post a zipped example, go to “My Documents” or wherever you have your file stored, right-click and “Send to > Compressed file”, then attach this zipped file to your post

  7. #7
    Registered User
    Join Date
    06-12-2007
    Posts
    11
    As requested. The worksheet I need to print is the one on the Plan Sheet Tab.

    Many thanks for your help in all of this. It is much appreciated.
    Attached Files Attached Files

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

    As your Page set up is set to print "one page wide x one page high" all you need to do is to go into Page Preview and click on Margins, then just made some of the columns narrower. By doing that it will make the page longer, therefore filling up more of the sheet, its just a matter of playing around with the columns some that the preview looks OK, then print.

    I've had ago myself, but this is for my printer, this may have different margins to your printer.

    Let me know how you get on?
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    06-12-2007
    Posts
    11
    Many thanks for your help. Your attachment printed fine.

    Your help is very much appreciated.

    Best regards
    John

  10. #10
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Glad to have helped - thanks for the feedback

  11. #11
    Registered User
    Join Date
    09-29-2012
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    1

    Question I need help too!!! Re:Printing filling the entire page

    I am working on a 16/45(cells)table in Excel and am having the same problem!! I tried to work with the margins and it did nothing besides erase the right margin. I am totally stuck and NEED help..Would you be willing to take a look and try to help me as well? Any help would be appreciated.

+ 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