+ Reply to Thread
Results 1 to 15 of 15

PDF as background for alignment purposes not working

  1. #1
    Registered User
    Join Date
    12-10-2014
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    24

    Unhappy PDF as background for alignment purposes not working

    I have a form that I need to replicate and it's in PDF format so I would like to be able to put a pdf (or convert it) as a background to align my cells on it.

    I tried converting it to PNG using a web tool but it doesn't keep proportions.

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: PDF as background for alignment purposes not working

    Maybe first print the PDF as JPEG. Then under Page Layout ribbon > Click background, from there you can insert the PDF you just converted to JPEG as background.

    http://www.howtogeek.com/howto/micro...07-worksheets/

  3. #3
    Registered User
    Join Date
    12-10-2014
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    24

    Re: PDF as background for alignment purposes not working

    I will try that and post my findings. The important part is to keep proportions for me to be able to replicate the form almost perfectly.

  4. #4
    Registered User
    Join Date
    12-10-2014
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    24

    Re: PDF as background for alignment purposes not working

    It does insert the background like it did with my PNG the only problem is it's not respecting proportions at all.. The original PDF is a 8x14 legal document and the background is MUCH bigger than 8x14 for sure.

    Thanks for the input JieJenn Anyone has another idea?

  5. #5
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: PDF as background for alignment purposes not working

    When you convert the PDF to JPEG, did you configure to set the image to match 100% to PDF size so all the formatting stay uniform? I just tested, and I don't see any shrinkage.

  6. #6
    Registered User
    Join Date
    12-10-2014
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    24

    Re: PDF as background for alignment purposes not working

    What are you using as a converter ? I see no such options in http://pdf2jpg.net/

  7. #7
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: PDF as background for alignment purposes not working

    Oh that might be why because you are using online tool which doesn't give you the option. I am using Adobe Acrobat Pro.

  8. #8
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: PDF as background for alignment purposes not working

    I guess the 2nd option be take a screenshot of the PDF file and pasted to Excel file.

  9. #9
    Registered User
    Join Date
    12-10-2014
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    24

    Re: PDF as background for alignment purposes not working

    I have a licence of Acrobat Pro at work I will try it there and report

  10. #10
    Registered User
    Join Date
    12-10-2014
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    24

    Re: PDF as background for alignment purposes not working

    I am at work right now and I am messing around with the conversion in Acrobat Pro and I can't seem to find the right option to set to 100% matching could you provide a screenshot please ?

  11. #11
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: PDF as background for alignment purposes not working

    Can you send me your pdf file to [email protected]?

  12. #12
    Registered User
    Join Date
    12-10-2014
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    24

    Re: PDF as background for alignment purposes not working

    Just did a second ago thanks

  13. #13
    Registered User
    Join Date
    12-10-2014
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    24

    Re: PDF as background for alignment purposes not working

    I am still trying to place the PDF in background. So far even when I convert the PDF to JPEG with the help of JieJenn it still isn't right because the image doesn't keep proportions. Unless it's a PDF shenanigans.

    Basically when you print the PDF it's in 8x14 (Legal) and when you place the jpeg as a background and select 8x14 as layout it's about 25% larger. But since I am trying to align my form to the existing one it's not doing the trick.

    I will attach the PDF in question if you guys can make it fit 8x14 and keeping the proportions I would be very grateful. JieJenn is busy at the moment.
    Attached Files Attached Files

  14. #14
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: PDF as background for alignment purposes not working

    Hi,

    I don't have Adobe Acrobat, so I had to use a 3rd party software (executable on my computer) to create the .jpg file. The .jpg file looks similar to .pdf file to my untrained eye, inside and outside of Excel, with the following noticeable differences:
    a. the lines in the .jpg file are not as sharp as the lines in the .pdf file
    b. the color in the box on the upper right does not transfer to the .jpg file very well

    In addition, I don't know what you're looking for. The attached zip file contains:
    a. Your original .pdf file
    b. My .jpg file created from your original.pdf file
    c. My .xls file with the .jpg file embedded

    I've reached the limit of my technical ability on this topic. I hope what I have done is helpful to you.

    Lewis
    Attached Files Attached Files

  15. #15
    Registered User
    Join Date
    12-10-2014
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    24

    Re: PDF as background for alignment purposes not working

    Thank you very much again Lewis I think that will do the trick :D

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 02-02-2012, 11:32 AM
  2. Cell Alignment not working
    By excelme in forum Excel General
    Replies: 1
    Last Post: 07-02-2010, 02:40 PM
  3. Macros working continuos in background
    By ingleg in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-03-2010, 09:23 AM
  4. Working with Sub function with Excel in background
    By sphinx_ps in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-10-2010, 07:43 PM
  5. [SOLVED] Macro working in background ie not on activesheet
    By Dynamiteskippy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2005, 11:05 PM

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