Picture as background help

jcaptchaos2

Well-known Member
Joined
Sep 24, 2002
Messages
1,026
What I am trying to do is take a scanned photo of our purchase order form and set it as a background on my spread sheet. I did do that thinking that I have the data pull out of our main frame into certain cells so it looks like the form is filled out but found out that the background does not print out. What I am trying to accomplish is to be able to email the PO instead of faxing it. I can pull all of the data from our main frame into cells that would be in the correct location on the form ( scanned picture of the form) if I have the form as a background it looks perfect. I try to print to adobe or any printer and the background does not print. Sorry so long winded.
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

dave3009

Well-known Member
Joined
Jun 23, 2006
Messages
7,002
Office Version
  1. 365
  2. 2016
You can use customer header/footer for this I think. I just checked help in Excel by typing print background. The first option that comes up is Mimic watermark in Excel which, if tweeked, might help you out some.


HTH


Dave
 

jcaptchaos2

Well-known Member
Joined
Sep 24, 2002
Messages
1,026
I don't get that when I check help in excel, I have office 97 and maybe that option is not available.
 

dave3009

Well-known Member
Joined
Jun 23, 2006
Messages
7,002
Office Version
  1. 365
  2. 2016
I got this

Watermark functionality is not available in Excel. If you want to display a graphic on every printed page (for example, to indicate that the information is confidential), you can insert the graphic in a header or footer. This way, the graphic appears behind the text, starting at the top or bottom of every page. You can also resize or scale it to fill the page.

On the View menu, click Header and Footer.
In the Page Setup dialog box, click Custom Header or Custom Footer.
Click in the Left section, Center section, or Right section box.
In the row of buttons in the Header or Footer dialog box, click Insert Picture and then find the graphic you want to insert.
Double-click the graphic to insert it in the header or footer section box.
To resize or scale the graphic, click Format Picture in the row of buttons in the Header or Footer dialog box and then, in the Format Picture dialog box, select the options you want on the Size tab.

Notes

Changes to the graphic or graphic format take place immediately and can't be undone.

If you want to add blank space above or below a graphic, click before or after &[Picture], and then press ENTER to start a new line.

To replace a graphic, select &[Picture], click Insert Picture , and then click Replace.
Before printing, make sure the header or footer margin allows enough space for the custom header or footer.

To delete a graphic, select &[Picture] and then press DELETE.

Sorry about the format, perhaps this option isn't available in 97


HTH


Dave
 

dave3009

Well-known Member
Joined
Jun 23, 2006
Messages
7,002
Office Version
  1. 365
  2. 2016
Sorry I couldn't help you more, perhaps someone else will figure it out for you.

Cheers


Dave
 

Watch MrExcel Video

Forum statistics

Threads
1,109,383
Messages
5,528,385
Members
409,817
Latest member
JiNXX9500

This Week's Hot Topics

  • Change military grades into rank
    Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
  • VBA COUNTIF SOLUTION
    Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
  • INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
    Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...
  • Auto-Create a monthly Sign in sheet for preschool students
    The image below is what each page looks like. Above is space for the "Child Name" "Month" "Class" School days are obviously Monday-Friday but...
  • VBA vlookup multiple results
    Hi folks, Hopefully someone out there can help. I have a list to vlookup which works (ish). the lookup only picks up the first instance of the...
  • Extract values for earliest/latest times
    I am trying to put together a formula to get the earliest start time, the latest end time from column A for each person in Column B-F without the...
Top