You tin can enhance the appearance of your Excel spreadsheet and make it more visually attractive to an audience. The best way to spice it up is to add an Excel background epitome. This commodity will show you several different ways to practise and so.

You can use an image as a background or a solid color or pattern. At that place are basically iii means you lot tin can do this in Excel: using Page Layout, adjusting the transparency of an image and inserting an object.

Add together an Excel Background Image In Excel Using Page Layout

  • Open the page layout ribbon by clicking on Page Layout.
  • Wait under the Page Setup department for Groundwork.
  • Click on Background and see the three options – from a file, Bing Paradigm Search, and OneDrive-Personal.
  • Permit's first by selecting the first option From a file and cull an image from your reckoner.
  • Select an image and then click Insert. Run into the background called behind your data in the screenshot below.

As you curl downwards the folio or as you motion from side to side, the image repeats itself over and over in the groundwork.

Be careful with the Excel groundwork image you choose to use. Every bit you lot tin see in the image higher up, the information is obscured in many areas because the area on the picture is dark and so is the text.

Y'all have a few options. You tin change the color of the text and bold it.

Go along in mind that your data is the focal point of your spreadsheet. If the Excel groundwork prototype makes it hard to read, you are diluting the touch of your information.

This is a downside of using groundwork images. You don't desire the background to interfere with your information.

Some other disadvantage is the data gets smaller when yous zoom out on your spreadsheet while the image size stays relatively the same.

If y'all zoom in, the text gets larger, and the prototype remains relatively stable.

The Excel background epitome does non follow the data by staying proportional to it. Let's employ the second option at present to add a background.

First, delete the old ane by going to Page Layout > Delete Groundwork.

The second pick is to insert a motion-picture show from a Bing Image Search. This is ofttimes a better option because you might not have the best image on your computer.

Since this spreadsheet is about fiscal information in different countries, let's search for images almost maps.

By default, the search will only bring up results for Artistic Commons images. These are images that have been uploaded to the web to exist shared.

Click on the filter icon to only meet the epitome Sizes, Types, Layouts, and Colors and select the ones you adopt.

Meet the screenshot below with a picture of a map groundwork. I bolded the black text to make information technology stand up out more.

Backgrounds tin can be visually appealing, but you must exist careful that they don't brand your text unreadable.

When you insert an Excel groundwork image using this method, the image does not show up when printed.

It is therefore only useful when you are showing your spreadsheet to others in a presentation and you want to grab their attention.

Insert a Picture & Adjust Its Transparency

Make certain you are on the Domicile tab and get to Insert > Pictures.

Choose an image from your computer and click Insert. Observe that the picture is non a background prototype. It is floating on top of the spreadsheet information.

You can move the image around the spreadsheet and resize it by putting your cursor on one of the circles on the edges and dragging information technology.

An advantage of inserting an Excel background epitome rather than adding a background is that you can adjust the transparency. If your spreadsheet is very long, this method might not be the most user-friendly method.

Start by pushing the image to the acme left-hand corner of your spreadsheet. Then elevate the movie and then that it covers all the information.

Conform the transparency by clicking on the image. Then click on Picture Format tab > Transparency > Flick Transparency Options.

Add transparency to the picture then that it is sitting in the background and the data is behind the information. Move the toggle on the Transparency option to the right until the data becomes articulate and can be easily read.

This method uses an inserted picture show that behaves like a background image and will show upwardly when printed.

Insert An Object In Excel

If your spreadsheet is very long, the previous method could be cumbersome. Inserting an object might be a better option.

  • Start by clicking Insert from the ribbon menu.
  • And so click Shapes. The drop-down carte next to Shapes will open up.
  • Select a shape by clicking on it. Nosotros will use a rectangular shape. Using your mouse, drop the shape on your spreadsheet to create it.
  • Then resize information technology past dragging the circular buttons effectually the shape until it covers all your data. Correct-click on the shape and select Format Shape.
  • Click Fill from the bill of fare > Picture or texture fill > Insert (under Picture source). Insert a picture from a file, online pictures, or from icons.
  • Let'due south choose a Texture fill. Nether the Format Shape, select Picture or texture fill up. Then click the drop-downward card side by side to Texture and cull one to apply.
  • The texture will fill the shape and cover your data. Utilise the slider next to Transparency to ready a percent that allows your data behind the texture to evidence. In the screenshot beneath, nosotros used 75% transparency.

When you lot use this method, the background will show upwards when you print.

When calculation a background to an Excel spreadsheet, keep in mind that existence able to read your data conspicuously is vital.

Adjusting the transparency of the background and changing the font color or manner can improve the readability of your information while adding a footling pizzazz to your spreadsheet.

Take yous had any trouble calculation an Excel groundwork prototype – or perhaps you have a tip on how to add other background features? Join the chat and let united states know in the comments below.