I need a watermark in Excel with the text "internal use only". I then need to make a pdf of the Excel sheet and would like the watermark to look the same in the pdf as it does in Excel.
I used the method of adding a jpg picture to the header, and this works well as a watermark in Excel.
The problem is when I make a pdf of the sheet. The picture ends up about half the size as it was in Excel.
Any ideas why this is happening? How I can get around it.
Thanks in advance!
Last edited by HelenStrand; 01-19-2011 at 04:01 AM.
use NotroPDF converter
__________________
Regards
Rahul Nagar
Founder of www.myshortcutkeys.com.
If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.
I think I've just found the problem, and it's annoyingly simple . . .
In Excel I used the "fit to 1 page" setting, which reduced it to about 63%. When I changed that to 100%, the watermark came through to the pdf with the correct size. The only problem now is that I need to reformat my Excel sheet so that everything fits onto one page when it's at 100%
Last edited by HelenStrand; 01-19-2011 at 03:57 AM.
Correct...
__________________
Regards
Rahul Nagar
Founder of www.myshortcutkeys.com.
If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks