[Excel] Image behind text
Solved/Closed
Djeko
Posted messages
5
Status
Membre
-
bassethound -
bassethound -
Hello everyone.
How can we work with an image behind the cells in Excel?
The background option doesn't work because the image stays at its size based on pixels (and thus the screen) and not in centimeters (and thus the layout).
The transparency option works, but the image remains above the cells, and to fill those cells, you have to select a cell outside the image area and then move and manage everything with the keyboard. It is doable but not very practical, especially with an A3 sheet...
Actually, I am looking for the Wrap/Text Behind function from Word.
Thank you for your attention,
Best regards
Djeko
--
I got chills
How can we work with an image behind the cells in Excel?
The background option doesn't work because the image stays at its size based on pixels (and thus the screen) and not in centimeters (and thus the layout).
The transparency option works, but the image remains above the cells, and to fill those cells, you have to select a cell outside the image area and then move and manage everything with the keyboard. It is doable but not very practical, especially with an A3 sheet...
Actually, I am looking for the Wrap/Text Behind function from Word.
Thank you for your attention,
Best regards
Djeko
--
I got chills
Configuration: Windows XP Internet Explorer 6.0
1 réponse
Hello Djeko,
The background function in Word does not exist... But if your image is the size of your page, you can insert it in the header:
- File, Page Layout, Header/Footer tab
- Choose Custom Header
- Click in the central part
- Click on the image icon and select the image
- Preview before printing and adjust the margins if necessary to center the image.
m@rina
The background function in Word does not exist... But if your image is the size of your page, you can insert it in the header:
- File, Page Layout, Header/Footer tab
- Choose Custom Header
- Click in the central part
- Click on the image icon and select the image
- Preview before printing and adjust the margins if necessary to center the image.
m@rina
I’ve searched everywhere but I can’t seem to put the text above the image (Excel 2007) without using transparency
I think I’m going to use Word.
Print your page and place your form on top of it. In the light, you will see which cell of your grid corresponds to the form. Create an identical grid in which the cells are all empty except for those that should appear in your form.
All that’s left is to create a third information input grid in which you will report to the second grid of small cells, making sure to use a "text" format (they will overflow to the right into adjacent cells).
Print your form, then run it through the printer a second time by printing the second Excel grid with references to the information input grid.
Hé HOP! It's nice, but it takes two operations or a stock of pre-printed forms.