View original (French)

[Excel] Image behind text

Solved/Closed
Djeko -  
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
Configuration: Windows XP Internet Explorer 6.0

1 answer

  • Votes
  • Date
  • Descending date
  1. m@rina Moderator
    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
    1. Furtif Contributor
      Hi

      Well, his question was more like: "How can we, in Excel, work with an image behind the cells?"--

      I understand his problem well, I haven't been able to figure it out either.
      However, there is a feature that I haven't completely explored:

      Shift + Edit ... offers to copy an image as a background image, more or less transparent.

      *** @+ / Stealth ***
      *** Eat bananas! ***
    2. m@rina Moderator
      Hello,

      No, there is no way other than those mentioned here, knowing that the transparent image over the cells works quite well but is not very practical.

      The insertion of an image in the header (yes, I insist...) will indeed be below the text entered in the cells.
      Before inserting it, it should be formatted: size, transparency, etc.

      m@rina
    3. Djeko Author
      @m@rinaHello,

      Thank you for your help.
      The header option would indeed allow me (if I managed to position the image correctly) to print the elements in the right place, but I must admit I didn't specify that I want to do the opposite... If you want, I have a form to fill out multiple times, and to make it faster, prettier and more Excel-like, I scanned it so that I could then print the fields I had to fill out directly on the form.
      I have continued my efforts with the transparency, but I don't know if it's the scanning or if I mismanaged the resizing of the image; in any case, the data is of course misaligned on the form (too high or too low, too far left or right...)
      I will explore the Shift+Edit option a bit, and if all else fails, I will go back to my trusty pen...
      Thanks again for the help,
      Have a great day,
      Djeko
      --
      I got chills
    4. m@rina Moderator
      @DjekoHello Djeko,

      Indeed, I understand your problem better now.
      Know that Excel is not WYSIWYG at all!

      You draw a rectangle to which you give specific values, you print it, and it doesn't match...
      I have an app that required drawing a rectangle, and I had to guess the measurements until I found the right size when printing!!! :(

      For filling out a form, it might be better to use Word, even if it means inserting Excel cells into it.

      m@rina
    5. salaheddine biskra
      @m@rinaHello
      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.