How to insert a drawing behind the text in Excel

Anonim

How to insert a drawing behind the text in Excel

Method 1: Insert images as footer

On our site already there is an article about how footswear is added for the table in Excel. This is a great method to adjust the format of the page before printing, organizing all the necessary editing points in accordance with GOST or the requirements of the project customer. The functionality of the working tool with footers can be used to insert a pattern that will automatically settle down under the text creating the necessary effect.

The disadvantage of this method is an uncomfortable image size formatting, if suddenly it turned out that it is too large or small, so in the event of difficulties, read the following options.

Method 2: Insert images as a substrate

The substrate is a kind of background of the page in the exhale table, which is perfect for inserting there an image without additional size settings and other parameters. However, you must be pre-confident that its transparency and present colors arrange the overall picture of the table, without overlapping the inscriptions and other important elements.

  1. Open the "Page Markup" tab, where the functions mentioned is located.
  2. Go to the page Markup tab for adding a substrate from an image under the text in Excel

  3. Click on the "Substrate" button.
  4. Button to add a substrate as an image under the text in Excel

  5. The image insertion window will appear, where you can find the file on the computer and select it.
  6. Selecting an image to create a substrate in Excel

  7. The substrate will immediately appear even in the usual view mode.
  8. Successful add image as a substrate under the text in Excel

Instead of the "Substrate" button, "Delete Background" is now displayed. Click on it if you no longer want to use the inserted image as a substrate.

Method 3: Inserting a transparent image

Unfortunately, the functionality of this program for working with spreadsheets does not allow you to take a regular insert tool, add a picture and immediately adjust its transparency, so you have to go on a small trick, making an image as a background of the shapes.

  1. Click on the "Illustration" block on the "Insert" tab.
  2. Go to the menu of the geometric shape before the image below the text in Excel

  3. Among the list of figures, find a rectangle or any other suitable object.
  4. Creating a rectangle before adding an image for text in Excel

  5. Add it by setting the appropriate size.
  6. Successful creation of a rectangle before adding an image for text in Excel

  7. Click on the figure right-click and through the context menu, go to "Figure Format".
  8. Go to the format of the figure to edit a rectangle in Excel

  9. To start in its parameters, turn off the contour by removing its color.
  10. Disabling the rectangle loop before adding an image for text in Excel

  11. Next, go to the "fill" and mark the version of the "Figure or Texture" version.
  12. Enable Filight Fill Mode To add an image to the text in Excel

  13. Insert the picture as a fill.
  14. Transition to the image selection as fillings for the figure in Excel

  15. Use the previously discussed menu.
  16. Image selection as fillings for figures in Excel

  17. It remains only to set the level of transparency that matches your requirements.
  18. Setting the image transparency after its choice as fillings for the figure in Excel

  19. Return to the table and place a new figure so that it is under the contents of the sheet, and then save the project.
  20. Successful add image as fillings for a figure when it is located under the text in Excel

Read more