Image with Cell/Formula Integrated

%3CLINGO-SUB%20id%3D%22lingo-sub-1699914%22%20slang%3D%22en-US%22%3EImage%20with%20Cell%2FFormula%20Integrated%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1699914%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20figure%20out%20how%20to%20put%20an%20image%20in%20excel%20while%20still%20having%20the%20ability%20to%20type%20over%20it%20and%20ideally%20have%20things%20pull%20from%20other%20sheets.%20The%20goal%20being%20to%20have%20a%20cover%20page%20that%20automatically%20prints%20with%20the%20updated%20info%20from%20other%20sheets%20in%20the%20file.%26nbsp%3B%20Is%20this%20possible%3F%20*PLS%20HELP*%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1699914%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1699994%22%20slang%3D%22en-US%22%3ERe%3A%20Image%20with%20Cell%2FFormula%20Integrated%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1699994%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F703724%22%20target%3D%22_blank%22%3E%40Bennadeau%3C%2FA%3E%2C%3C%2FP%3E%3CP%3EAppreciate%20the%20help!%20Unfortunately%2C%20transparency%20does%20not%20work%20for%20the%20task%20I%20am%20working%20on.%26nbsp%3B%3CSPAN%3EThis%20is%20where%20I%20have%20been%20stuck...no%20simple%20way%20to%20just%20move%20the%20image%20to%20the%20back%20and%20pull%20info%20forward%2Fontop%20of%20it%20while%20still%20looking%20natural%2Fprofessional%2Fless%20%22word%20art-y%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1699983%22%20slang%3D%22en-US%22%3ERe%3A%20Image%20with%20Cell%2FFormula%20Integrated%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1699983%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F803796%22%20target%3D%22_blank%22%3E%40AugustR%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%20you%20cannot%20print%20a%20background%20picture.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F213977%2Fyou-cannot-print-a-background-graphic-for-a-excel-worksheet%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F213977%2Fyou-cannot-print-a-background-graphic-for-a-excel-worksheet%3C%2FA%3E%3C%2FP%3E%3CP%3EThat's%20why%20I%20went%20directly%20to%20the%20transparency%20approach.%3C%2FP%3E%3CP%3EYou%20said%20the%20text%20doesn't%20look%20very%20professional%20this%20way%2C%20you%20will%20obviously%20have%20to%20adjust%20the%20color%20of%20your%20text%20so%20it%20is%20still%20readable.%20Especially%20if%20your%20image%20is%20darker%20and%20your%20text%20is%20black.%20Or%20green%20on%20red%20for%20the%20colorblind.%3C%2FP%3E%3CP%3EIf%20you%20end%20up%20finding%20a%20better%20solution%2C%20please%20share%20it%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1699962%22%20slang%3D%22en-US%22%3ERe%3A%20Image%20with%20Cell%2FFormula%20Integrated%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1699962%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F703724%22%20target%3D%22_blank%22%3E%40Bennadeau%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20response!%20I%20am%20aware%20of%20the%20transparency%20setting.%20This%20only%20(kind-of)%20works%20for%20images%20like%20the%20one%20you%20attached...my%20photo%20is%20darker%20and%20the%20text%20doesn't%20look%20very%20professional%20when%20set%20up%20this%20way...is%20there%20any%20other%20option%20besides%20this%3F%3F%20I%20tried%20throwing%20the%20image%20up%20as%20a%20background%2C%20but%20then%20it%20doesn't%20print%20the%20image...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1699953%22%20slang%3D%22en-US%22%3ERe%3A%20Image%20with%20Cell%2FFormula%20Integrated%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1699953%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F803796%22%20target%3D%22_blank%22%3E%40AugustR%3C%2FA%3E%2C%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3EInsert%20your%20image%20in%20your%20spreadsheet%3C%2FLI%3E%3CLI%3ERe-size%20and%20position%20it%20where%20ever%20you%20want%20it%3C%2FLI%3E%3CLI%3Eright%20click%2C%20select%20%22Size%20and%20Properties...%22%3C%2FLI%3E%3CLI%3EIn%20the%20right%20hand%20pane%2C%20select%20%22Picture%22%3C%2FLI%3E%3CLI%3EChange%20the%20transparency%20to%2050%25%3C%2FLI%3E%3C%2FOL%3E%3CP%3ENow%2C%20whatever%20you%20type%20in%20a%20cell%20behind%20your%20picture%20will%20show.%20You%20may%20need%20to%20adjust%20your%20transparency%20to%20your%20desired%20level.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Bennadeau_0-1600799018409.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F221182i74AB5E4C64E7002B%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Bennadeau_0-1600799018409.png%22%20alt%3D%22Bennadeau_0-1600799018409.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I am trying to figure out how to put an image in excel while still having the ability to type over it and ideally have things pull from other sheets. The goal being to have a cover page that automatically prints with the updated info from other sheets in the file.  Is this possible? *PLS HELP*

 

 

4 Replies
Highlighted

Hi @AugustR

  1. Insert your image in your spreadsheet
  2. Re-size and position it where ever you want it
  3. right click, select "Size and Properties..."
  4. In the right hand pane, select "Picture"
  5. Change the transparency to 50%

Now, whatever you type in a cell behind your picture will show. You may need to adjust your transparency to your desired level.

 

Bennadeau_0-1600799018409.png

 

 

 

Highlighted

@Bennadeau,

 

Thank you for the response! I am aware of the transparency setting. This only (kind-of) works for images like the one you attached...my photo is darker and the text doesn't look very professional when set up this way...is there any other option besides this?? I tried throwing the image up as a background, but then it doesn't print the image...

@AugustR 

Unfortunately you cannot print a background picture. 

https://support.microsoft.com/en-us/help/213977/you-cannot-print-a-background-graphic-for-a-excel-wo...

That's why I went directly to the transparency approach.

You said the text doesn't look very professional this way, you will obviously have to adjust the color of your text so it is still readable. Especially if your image is darker and your text is black. Or green on red for the colorblind.

If you end up finding a better solution, please share it here.

Highlighted

@Bennadeau,

Appreciate the help! Unfortunately, transparency does not work for the task I am working on. This is where I have been stuck...no simple way to just move the image to the back and pull info forward/ontop of it while still looking natural/professional/less "word art-y"

 

Thanks,