Results 1 to 4 of 4

Thread: Printing a report with a front cover - how to have different margins

  1. #1

    Printing a report with a front cover - how to have different margins



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am trying to print a report in excel - I have a different header for my front page but how can I change the margins so that I dont have a huge white border on the front page? thanks

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,250
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Depends on the version of Excel. In 2007/2010 you can adjust margins via the Page Layout tab, Page setup group, Margins.

    I am curious though...do you have each page in a different worksheet, or are they all in the same worksheet? Excel only gets one set of magins per worksheet, so if your worksheet prints out to 10 pages, you can't have different margins for page 1. The workaround would be to split your cover page to a different worksheet, then you can customize it however you like.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    thanks Ken - we were trying desperately to keep it in one worksheet for reasons I wont bore you with but it looks like we have to abandon that idea and split the content across 5 sheets now. Its slightly a pain as it means an extra process and we have to do this 250 times, which is why I was hoping for an easier way. But thanks for your help, much appreciated

  4. #4
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,250
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    I suppose you could write a macro to set the print margins, then print page 1, then set them back and print the rest of the pages. But if you're going to do that, I think I'd honestly create a separate sheet for the cover, and set up macro to just print it first and the rest afterwards.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •