Skip to content

How To Blog

  • 10 Best Single Player PC Games for Solo Play 2022 Gaming
  • Facebook Touch – How to Login and Is It Worth Your Time? Smartphones
  • What To Do When Your Second Monitor Is Not Detected Help Desk
  • Fix VMware Missing HBA Adapters Virtualization
  • Best pink scientific calculator 2020

    Best pink scientific calculator 2020

  • how do i set the print area in google sheets Computer Tips
  • how to find birthdays on facebook 2021 Computer Tips
  • What Happens When You Block Someone on Your iPhone? iPhone

How to Add and Print Excel Background Images

Posted on October 5, 2020 By blog_786 No Comments on How to Add and Print Excel Background Images

You can improve the look of your Excel spreadsheet and make it more attractive to your audience. The best way to liven it up is to add an Excel background image. This article will show you several different ways to do this.

You can use an image as a background, solid color, or pattern. There are basically three ways to do this in Excel: using the page layout, adjusting the transparency of the image, and inserting an object.

How to Add and Print Excel Background Images

  • Open the page layout ribbon by clicking Page Layout.
  • Find the background in the Page Setup section.

Add a background image for Excel in Excel using page layout

  • Open the page layout bar by clicking Page Layout .
  • Look within the Page Setup section for Background .

  • Click Background and you will see three options: From File, Bing Image Search, and OneDrive-Personal.

How to Add and Print Excel Background Images

  • Let’s start by choosing the first option “From File” and selecting an image on your computer.

How to Add and Print Excel Background Images

  • Select an image and click “Insert”. See the Background chosen for your data in the screenshot below.

How to Add and Print Excel Background Images

How to Add and Print Excel Background Images

As you scroll down the page or move from side to side, the image repeats over and over in the background.

Be careful with the selected Excel background image. As you can see in the image above, the data is not visible in many areas because the area in the image is dark like the text.

You have several options. You can change the color of the text and make it bold.

How to Add and Print Excel Background Images

Remember, your data is the centerpiece of your spreadsheet. If the Excel background image makes it difficult to read, you are weakening the influence of your information.

This is the downside of using background images. You don’t want the background to get in the way of your data.

Another disadvantage is that the data becomes smaller as the table is scaled down, while the image size remains relatively the same.

How to Add and Print Excel Background Images

As you zoom in, the text becomes larger and the image remains relatively stable.

How to Add and Print Excel Background Images

The Excel background image does not follow the data, but remains proportional to it. Let’s use the second option to add a background.

First, remove the old one by choosing Page Layout> Remove Background.

How to Add and Print Excel Background Images

The second option is to insert an image from Bing Image Search. This is often the best option because you may not have the best image on your computer.

Since this table contains financial information in different countries, let’s search for images with maps.

How to Add and Print Excel Background Images

By default, the search only shows Creative Commons images. These are images that have been uploaded to the Internet for sharing.

How to Add and Print Excel Background Images

Click the filter icon to see only the sizes, types, layouts and colors of the image, and choose the ones you like best.

How to Add and Print Excel Background Images

See screenshot below for map background image. I have made the black text bold to make it stand out more.

How to Add and Print Excel Background Images

The background can be visually appealing, but you must be careful not to make the text unreadable.

When you insert an Excel background image using this method, the image is not displayed when printed.

Therefore, it is only useful when you are showing your spreadsheet to other participants in the presentation and want to get their attention.

How to Add and Print Excel Background Images

Insert a picture and set its transparency

Make sure you are on the Home tab and choose Insert> Pictures.

How to Add and Print Excel Background Images

Select an image on your computer and click Insert. Please note that the image is not a background image. It floats on top of the table data.

How to Add and Print Excel Background Images

You can move and resize the image around the spreadsheet by positioning the cursor over one of the circles around the edges and dragging it.

The advantage of inserting an Excel background image instead of adding a background is that you can adjust the transparency. If your spreadsheet is very long, this method may not be the most convenient.

Start by clicking the image in the upper left corner of your table. Then drag the image so that it covers all the data.

How to Add and Print Excel Background Images

Adjust the transparency by clicking on the image. Then go to the Image Format tab> Transparency> Image Transparency Options.

How to Add and Print Excel Background Images

Add transparencies to the image so that it is in the background and the data is behind the data. Move the Transparency switch to the right until the data is clear and easy to read.

How to Add and Print Excel Background Images

This method uses an inserted image that behaves like a background image and is displayed when printed.

How to Add and Print Excel Background Images

Insert Object into Excel

If your spreadsheet is very long, the previous method can be cumbersome. Inserting an object might be the best option.

  • First, click Insert on the ribbon menu.
  • Then click Shapes. A drop-down menu opens next to the shapes.

  • Select the shape by clicking on it. We will use a rectangular shape. Using the mouse, drag the shape onto the spreadsheet to create it.

How to Add and Print Excel Background Images

  • Then resize it by dragging the round buttons around the shape until it covers all of your data. Right-click the shape and choose Format Shape.

How to Add and Print Excel Background Images

  • From the menu, choose Fill> Picture or Texture Fill> Paste (under Image Source). Insert an image from a file, online images or from icons.
  • Let’s select a texture fill. In the Format Shape pane, select Picture or Texture Fill. Then click the drop-down menu next to Texture and select the one you want to use.

How to Add and Print Excel Background Images

  • The texture will fill the shape and cover your data. Use the slider next to the transparency to set the percentage that allows the data to be displayed behind the texture. In the screenshot below, we have used 75% transparency.

How to Add and Print Excel Background Images

How to Add and Print Excel Background Images

With this method, the background will be displayed when printed.

How to Add and Print Excel Background Images

When adding a background to an Excel spreadsheet, keep in mind that being able to read the data clearly is vital.

Adjusting the transparency of the background and changing the color or style of the font can improve the readability of your data while adding a little flair to your spreadsheet.

Have you had trouble adding a background image in Excel – or perhaps you have some advice on how to add other background functions? Join the conversation and let us know in the comments below.

–

MS Office Tips

Post navigation

Previous Post: The Best Versions of Tetris to Play Today
Next Post: Installing GIMP Plugins: A How-To Guide

Related Posts

  • How To Track Changes in Word (Online, Mobile, and Desktop) MS Office Tips
  • How to Create Fillable Forms in Word MS Office Tips
  • Link to Specific Slides in Other PowerPoint Presentations MS Office Tips
  • How to Find Matching Values in Excel MS Office Tips
  • How to Use Compare & Combine Documents in Word MS Office Tips
  • A Guide To All Excel File Extensions & What They Mean MS Office Tips

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Archives

  • June 2023
  • May 2023
  • April 2023
  • November 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • March 2021
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • December 2019
  • July 2019
  • May 2019
  • April 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018

Categories

  • Amazon Web Services
  • Apple Watch
  • Computer Tips
  • Cool Websites
  • Featured Posts
  • Free Software Downloads
  • Gadgets
  • Gaming
  • General Software
  • Google Software/Tips
  • Hardware
  • Help Desk
  • How-To
  • iOS
  • iPad
  • iPhone
  • Linux
  • Linux Tips
  • macOS
  • MS Office Tips
  • Networking
  • Office Tips
  • OS X
  • Product Reviews
  • Reviews
  • Safari
  • Smart Home
  • Smartphones
  • Software Reviews
  • technology
  • text
  • Tools Review
  • Troubleshooting
  • Tutorials
  • Uncategorized
  • Urdu Books PDF
  • Web Site Tips
  • Windows
  • Windows 10
  • Windows 7
  • Windows XP Tips
  • Wordpress

Recent Posts

  • Can I change the file type in Windows 10?
  • How to create line graphs in Google Sheets
  • Best Ways to Create Your Own 3d Printed Lithophanes?
  • Top 5 3D Modeling Apps for iPad Pro
  • How to Fix the “This site can’t be reached” Error in Google Chrome

Recent Comments

  1. How to reset Windows 10 from factory settings - How To Blog on The Easiest Way to Clean Install Windows 10
  2. How to reset Windows 10 from factory settings - How To Blog on 7 Best Programs to Immediately Install on Your New Computer
  3. How to reset Windows 10 from factory settings - How To Blog on What To Do If You Think Your Computer Or Server Has Been Infected With Malware
  4. 9 Best Ways to Fixing Safari Not Working on Mac? - How To Blog on How To Hard Reset a Mac OS X Computer & Reinstall The OS
  5. How to uninstall Avast antivirus on Mac - How To Blog on 4 Ways To Uninstall Apps On Mac
  • How To Import Your Contacts To Gmail Cool Websites
  • 15 Windows Diagnostics Tools to Improve Your PC’s Health Tools Review
  • 10 Tips on Getting the Most out of Github Tools Review
  • Google Forms Guide: How To Create A Google Form For Free Google Software/Tips
  • How to Block YouTube Channels
  • How to Send Articles to Kindle From Android How-To
  • Amazon Influencer Program 2022 technology
  • The splitting method the screen in Windows 10 Windows 10

Copyright © 2023 How To Blog.

Powered by PressBook News WordPress theme

Go to mobile version