Excel (or Acrobat) page colour (or paper colour)

[Jock1970]

I have an excel spreadsheet which is printed onto coloured paper to form part of a published document. A pdf version gets posted on our website, but we can't find an easy way to colour the pages within the pdf copy so that it looks the same as the paper version. Any tips ?

 

[Gruuuu]

Set the background of the cell to the appropriate color before converting to PDF? I wouldn't do it before printing though.

 

[Jock1970]

Thanks for your response Gruuuu - I had thought of that, but surely I would still end up with white margins.

 

[Gruuuu]

It appears that the "Save as PDF" feature in 2007 and later relies on your current printer settings. You would need to be able to specify full bleed in your printer settings. Most printers don't have this option, however many 'Print to File' printer drivers DO allow this. The 'Microsoft XPS Document Writer' appears to do this. Unfortunately that means you'll probably need to fiddle with the page settings (margins, zoom, etc).

I do not envy you that task

You could, of course, record a macro of you doing that, and use that macro whenever you needed to export your PDF.

Does any of this help?