How To Put Background Picture In Excel

How to gear up background image in Excel

Background image is as well known as Watermark. Microsoft Excel allows you to add Background image, logo, and groundwork colors in your document to make the document more than bonny, beautiful, and eye-catching.

Annotation: In a Microsoft Excel document, you tin can not add a groundwork paradigm to multiple Microsoft Excel documents at in one case.

Methods to set a Background image

Follow the beneath methods to set groundwork in Excel -

Add groundwork in Excel using Page Layout tab
Add background image using the keyboard shortcut keys
Add together a background with the fill up colour tool
Add backgroud image with Kutools for Excel

Method 1: Add background in Excel using Folio Layout tab

Steps to Add groundwork in Excel

There are the following steps to Add groundwork in Excel -

Notation: Using the below steps, yous tin can set background images in Microsoft Excel 2007, 2010, 2013, and 2019.

Stride 1: Open a new Microsoft Excel certificate (File -> New -> Blank document -> Create) or an existing Microsoft Excel document (File -> Open -> Browse document location -> Open button) in which you wish to add the background.

Pace 2: Click on the Page Layout tab on the ribbon. Click on the Background next to the Breaks option in the Folio Setup section. See the screenshot given beneath.

Note: In Microsoft 2003, click on the Format -> Sail -> Groundwork.

Step 3: A small Sheet Background dialog box volition appear on the spreadsheet. Browse the Background paradigm that you desire to set and click on the Insert button at the bottom of the dialog box, every bit shown in the beneath screenshot.

Now, the screenshot below shows that your desired background image volition appear in the Microsoft Excel document.

Method 2: Add a background image in Microsoft Excel using the keyboard shortcut keys

Microsoft Excel likewise allows us to Add or prepare a groundwork image chop-chop and easily using the keyboard shortcut keys.

Steps to ready background

A listing of beneath mentions steps shows that how to set a background image in a Microsoft Excel document -

Step i: Double-click on the Microsoft Excel icon to open a Microsoft Excel document.

Pace 2: Open a new or an existing Microsoft Excel document.

Click on the File -> New -> Blank certificate -> Creat to Open a new blank Microsoft Excel document.
Click on the File -> Open -> Browse document location -> Open button to open an existing Microsoft Excel certificate.

Notation: In our case, we are going to open an existing Microsoft Excel document.

Pace 3: Press the Alt + P + G keys together from the keyboard to open the Canvass Groundwork dialog box. Browse the groundwork that you want to be attack the Excel certificate and click on the Insert button at the lesser of the Sheet Background dialog box.

Step 4: Now, you can see that your preferred groundwork is added to the Microsoft Excel document.

Step five: Get to the Page Layout tab on the ribbon and untick the checkbox associated with the View in the Sheet Options group to remove gridlines from the background and makes background more attractive. Encounter the screenshot given below.

Method iii: Add a groundwork with the Make full color tool

Microsoft Excel besides allows you to add together a background with a fill color tool. In this method, a Fill color picker is used to add the backgroud color.

Steps to add a background in Microsoft Excel document

A list of steps to add a background in Microsoft Excel document given below -

Step 1: Open a new or an existing Microsoft Excel certificate in which you lot want to add a groundwork with the fill color tool.

Step 2: Printing the Ctrl+A keys from the keyboard to select the whole Microsoft Excel document.

Step 3: At the top left corner of the Microsoft Excel document, click on the vertical arrow nether the cell choice card as shown below given screenshot.

Step 4: At present, click on the Home tab and click on the Make full color drop-down icon under the Font group. A color picker will appear on the document. Select the color that you lot want to apply as a groundwork on your Excel document.

The screenshot below shows that your selected groundwork color is practical to the Microsoft Excel document.

Method 4: Add printable background in Excel

Microsoft Excel helps you lot to add the printable background images in the Microsoft Excel certificate with its Insert Watermark feature. This is quickest the method to insert the background image or text Watermark in the spreadsheet based on your requirement.

Steps to add a printable background in Excel

A list of steps to add a printable background in Excel is discussed below -

Step one: Open up a new or an existing Microsoft Excel spreadsheet in which you want to add a printable background.

Step 2: Click on the Insert tab side by side to the Home tab and and so click on the Shapes drop-down icon in the illustrations group. A list of shapes will appear on the document, select a rectangle shape, meet the below screenshot.

Footstep iii: Draw a shape in your spreadsheet equally large every bit you required.

Step 4: The Cartoon Tools is active and appears at the top of the spreadsheet. Click on the Shape Fill up button, and select the color that yous want to fill in the shape.

Note: In our case, we fill the shape with the white color.

Step 5: Now, click on the Shape Outline pick. A colour picker will appear on the screen in which select your desired outline color that you want to employ to the shape.

Step six: Right-click on the shape, a minor dialog box pops up with the list of options. Click on the Format Shape option.

Step 7: A Format Picture show dialog box volition appear on the screen in which do the following -

Click on the Fill option from the left pane.
Click on the Movie or texture fill radio button.
Click on the File push in the Insert from: department to browse the image that you want to use as a background prototype.
Tick on the Tile moving picture as texture checkbox.
Add Transparency based on your requirement.
At present, click on the shut button at the lesser of the Format Picture dialog box.