How to Insert a Background Image in Excel for a Worksheet

In Excel for Microsoft 365 on Windows, open the worksheet and select Page Layout > Background, choose an image, and select Insert. Excel tiles the image behind the cells; this worksheet background is for on-screen viewing and does not print. If you need an image on a printout, use a header or footer picture or insert a picture as an object instead.

What You’ll Need

An Excel workbook saved in a format that preserves workbook features, such as .xlsx or .xlsm. CSV files do not preserve worksheet backgrounds.
A picture file you are allowed to use. A modest-size PNG or JPEG is often a practical choice; a very large image can make a workbook slower to open or share.
Excel for Windows with the Page Layout tab. Excel for Mac may offer the same command, depending on the version. Excel for the web does not provide the worksheet-background command, so use the desktop app to add or remove one.

Step-by-Step

Open the workbook and choose the right sheet. Open the file in the Excel desktop app and click the worksheet tab where the background should appear. A background belongs to an individual worksheet, not to the entire workbook. If you want the same image on several sheets, you will need to apply it to each one separately.
Check the sheet before adding the image. Decide whether the picture will make the data harder to read. A busy photograph or a high-contrast pattern can compete with cell contents, gridlines, and charts. If the sheet contains important figures, consider using a very pale, low-detail image or a simple logo with empty space around it.
Open the background command. Select the Page Layout tab on the ribbon, then choose Background. This command is for the worksheet canvas; it is not the same as changing a cell’s fill color. You do not need to select a cell range first.
Choose where the picture comes from. In the picture selection window, choose the option that matches your file. For a picture saved on your computer, use the local file or browse option, find the image, select it, and choose Insert. If your Excel version offers online or cloud picture sources, you can use one of those instead, but the choices shown can vary by version and account.
Check the result on the worksheet. Excel places the picture behind the cells and repeats it in tiles across the sheet. It does not automatically stretch one copy to the edges of the visible window or print page. Scroll horizontally and vertically to see how the pattern repeats, and check a few areas where text or numbers appear.
Adjust the image file if the pattern is not right. The worksheet-background command does not give you handles to resize, crop, or reposition the image as a single object. If the tiles are too large, too small, or visually distracting, edit or resize the source image in an image editor, save a revised copy, and insert that copy as the background. You can also choose a less detailed image.
Make the cell contents readable. If the picture makes entries difficult to see, use a lighter image or add a solid fill to the cells that contain key information. Cell fill colors can hide the background in those cells, so apply them selectively and check that the worksheet still looks consistent. Do not rely on the image alone to communicate information.
Save and check the workbook again. Save in .xlsx or .xlsm format, close and reopen the file if you want to confirm that the background is retained, and check that the intended sheet still has it. If you will send the workbook to someone else, tell them that the background is decorative and does not appear in printed output.

To remove the image later, return to the affected sheet and choose Page Layout > Delete Background. The command appears in place of, or in the same ribbon area as, the add-background command after a background has been applied. Removing it from one sheet does not remove backgrounds from other sheets.

Common Mistakes

Expecting the background to print. Excel worksheet backgrounds are not printed, even if they are visible in Normal view or Page Layout view. A print preview without the image is expected behavior, not a printing error.
Assuming the image will fill the page once. Excel repeats the selected picture as a tiled pattern. It does not provide a fit-to-page or drag-to-position control for this type of background. Make a source image with dimensions and a pattern that suit the sheet.
Using a detailed image under dense data. High contrast, tiny text in the picture, or a busy texture can reduce legibility. A decorative background should stay subordinate to the information in the cells.
Adding the background to the wrong sheet. The command affects the active sheet. Before using it, check the worksheet tab name; if you have several sheets selected as a group, take care not to apply changes more broadly than intended.
Trying to format it like an inserted picture. A worksheet background is not a selectable object. You cannot click it to open Picture Format, change its transparency, or move it independently. Use Insert > Pictures when you need a picture object you can select and format.
Saving as CSV and expecting the image to remain. CSV stores plain text data, not workbook formatting or worksheet background settings. Keep a copy in an Excel workbook format if the image or other sheet features need to be retained.

Tips

Use a quiet design. Pale colors, broad shapes, and low-detail textures usually interfere less with numbers than photographs or patterns with sharp edges. If you are using a logo, an image with generous blank margins may tile less awkwardly than a tightly cropped logo.
Preview at the zoom level people will use. Zoom changes how the worksheet is displayed on screen, so review both a normal working zoom and a closer view. Check that numbers, labels, and chart elements remain easy to distinguish from the background.
Consider accessibility and contrast. Do not use color or imagery as the only way to distinguish categories or explain a result. Keep text readable, and provide labels or other cues in the worksheet itself.
Keep an original copy of the picture. If you make a lighter or smaller version for Excel, save it as a separate file. That lets you revise the background later without losing the source image.
Use the right method for the intended output. For a screen-only visual, use the worksheet background. For a logo or picture that should print, insert it as a picture object or add it in a header or footer. Test the result with print preview before distributing a printed worksheet.
Think about workbook size. Large, high-resolution pictures can add unnecessary weight, especially if the workbook is shared or contains several sheets with images. Resize a copy to a sensible pixel size for its intended use rather than inserting an enormous original photograph.

Troubleshooting

The Background command is missing or unavailable. Confirm that you are using the desktop version of Excel and have the intended worksheet active. Excel for the web does not include the worksheet-background feature. In Excel for Mac, check the Page Layout tab for Background; ribbon labels and feature availability can vary by release. If the command is absent, open the workbook in a supported desktop version of Excel or use an inserted picture object for a different visual treatment.

The image appears in the sheet but not in print preview. That is how worksheet backgrounds work: they are not part of printed output. If you need a printed watermark-like image, try a header or footer picture. In desktop Excel, open Page Layout, open the Page Setup dialog using its dialog launcher, choose the Header/Footer tab, and select Custom Header or Custom Footer. Use the picture control in the chosen section to add the image, then check print preview. A header or footer picture is placed in that printable header or footer area; it is not a freely positioned, full-page background.

The image is tiled in an unattractive way. This is expected: the background feature repeats the source image rather than stretching it to fit. Choose a source image whose dimensions and edges work as a repeating tile, or create a new image with a solid or transparent margin. If you need one image at a specific size and position, choose Insert > Pictures and position the picture object on the worksheet instead.

The picture obscures information or makes the sheet hard to read. Remove the background with Page Layout > Delete Background, then try a lighter or simpler source image. Alternatively, give important cells a solid fill. An inserted picture object can be resized and positioned, but it floats above worksheet cells and may cover their contents; adjust it carefully and check the result at different zoom levels.

The background disappears after saving or sharing. Check that you saved as .xlsx or .xlsm rather than CSV, and that the recipient is opening the Excel workbook rather than a text export or preview. If a recipient uses Excel for the web and cannot see or manage the feature as expected, ask them to open the file in desktop Excel. For a document that must look identical on every device, export or print a reviewed copy to PDF, noting that the worksheet background itself will not be included in Excel’s printout.

Frequently Asked Questions

Can I add a background image to just part of a worksheet?
The worksheet-background command applies across the sheet and tiles the image; it does not let you select a cell range for the background. To place an image in one area, use Insert > Pictures and position the picture object over that area, or use cell fill colors for a simple block of color.

How do I remove a background image in Excel?
Activate the sheet that has the image, then select Page Layout > Delete Background. If the command is unavailable, the active sheet may not have a background, or you may be using Excel for the web. A picture inserted as an object is removed by selecting that object and pressing Delete instead.

Can I make the worksheet background transparent or faded?
There is no transparency slider for a worksheet background in the Background command. Edit the source picture to make it lighter or more transparent before inserting it. If you insert a picture as an object, available transparency controls depend on the picture-formatting options in your Excel version, and the object may cover cell content.

Will a background image appear when I print or export the sheet to PDF?
No. The worksheet background is not printed, so it will not appear in a PDF created through Excel’s print workflow. For a printed image, use a header or footer picture or another layout method, then inspect print preview and the exported PDF before sharing.

Can I use a picture as a page background that I can resize and move?
Not with the worksheet-background feature. It is tiled and cannot be selected or positioned as a single image. Use Insert > Pictures for a movable object, then resize and position it. Keep in mind that an inserted object sits over worksheet cells, so it can obscure data and needs careful placement.

Does the background apply to every sheet in the workbook?
No. It applies to the active worksheet. Add it separately to each sheet where you want it, and check the sheet tab before making the change. Removing a background also affects only the active sheet.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.