For example, a sales manager setting up a spreadsheet of products may want to include an extra column with product images, a real estate professional may wish to add pictures of different buildings, and a florist would definitely want to have photos of flowers in their Excel database. While Microsoft Excel is primarily used as a calculation program, in some situations you may want to store pictures along with data and associate an image with a particular piece of information.
It also explains how to copy, move, resize or replace an image in Excel. Hope you would have liked this post.The tutorial shows different ways to insert an image in Excel worksheet, fit a picture in a cell, add it to a comment, header or footer.
First open the spreadsheet, where you have already added an image as background.To remove the background in the image follows the below steps: For Excel 2003: How to Remove the Background Image in Excel To add printable backgrounds to your spreadsheet use the second option. It should be noted that when you add an image background to your spreadsheet using the above method then it won’t show up when you print the sheet.Remove gridlines on your spreadsheets when you are using a background image, this makes them look smooth.You can only add the background to one worksheet at a time. You cannot add a background image to multiple worksheets at once.So, only select those images that have small sizes. The image in your spreadsheet background can increase the overall size of the spreadsheet.You can also use the shortcut Alt + P G to add an image background to your worksheets.For example- if you use a dark color font on a light color background image, it will be easier to read. Try to use contrast colors to make your spreadsheets more readable.The resultant will look somewhat like the above image.įew Important tips about spreadsheet backgrounds.Now the image that you just selected will be used in the background of your worksheet.This will open a sheet background window, select the image that you wish to use as a background and then click the insert button.Next, navigate to the ‘Page Layout’ tab in the ribbon and click the ‘Background’ option.First, open the worksheet where you have to add the background.This will add the picture that you just selected as the sheet background.Now, browse through all the available images, select the image that you wish to add and click the insert button as shown in the below image.After this navigate to ‘Format’ > ‘Sheet’ > ‘Background’.First of all, open the worksheet where you wish to add the background.Option 1: Adding a Background Image to your worksheet For Excel 2003 Option 2: Adding a Printable image to your worksheet.How to Remove the Background Image in Excel.Few Important tips about spreadsheet backgrounds.Option 1: Adding a Background Image to your worksheet.