Excel: How to Insert an Image in a Header on Every Page

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, open Page Layout > click the small launcher in the Page Setup group > Header/Footer > Custom Header. Choose the left, center, or right section, click Insert Picture, select an image, and confirm; Excel will place it in the worksheet’s printed header.

What an image in an Excel header does

A header is a printable area above the worksheet grid. Adding a picture there is useful for a company logo, a report mark, or a small identifying graphic that should appear on printed pages without occupying worksheet cells. Excel treats the picture as part of the header rather than as an ordinary image object sitting over cells.

That distinction matters: the header image generally appears in Page Layout view, Print Preview, and printed or PDF output, but not in the standard Normal worksheet view. It repeats on the printed pages for that worksheet unless you configure different headers for the first page or for odd and even pages. The setting belongs to an individual worksheet, not automatically to every tab in the workbook.

Insert a picture through Page Setup

The Page Setup dialog is a dependable route when you want to choose exactly where the image goes. In the dialog, the three header sections correspond to the left, middle, and right portions of the page. Follow these steps:

  1. Select the worksheet where the header should appear. If you want the same logo on several sheets, you will need to set up each sheet, or group the sheets and apply the setting carefully.
  2. Open Page Layout. In the Page Setup group, click the small diagonal-arrow dialog launcher. This opens the Page Setup window.
  3. Choose the Header/Footer tab, then click Custom Header. Choose Custom Footer only if the image should be at the bottom of the printed page.
  4. Click inside the Left section, Center section, or Right section, depending on where you want the picture.
  5. Click the Insert Picture button in the header dialog. Browse to the image file and select it. After inserting, Excel may show a code such as &[Picture] in the section; that code represents the picture and is not an error.
  6. Choose OK to close the header dialog, then OK again to close Page Setup. Switch to Page Layout view or open Print Preview to inspect the result.

A common choice is the left section for a logo, leaving the center or right section available for a report title or page number. You can also place text and the picture in the same section, but check the preview: long text and a large logo can compete for the limited header width.

Use the Page Layout view as an alternative

You can also add a header picture while looking at the page itself. Choose View > Page Layout, then click the header area at the top of the page. Click the left, center, or right header box where the picture should go. Excel displays the contextual Header & Footer tab; choose Picture in its Header & Footer Elements group and select the image file.

This method can feel more direct because the page and its header sections are visible while you work. The Page Setup method is useful when you are already adjusting margins, orientation, or other print settings. Both methods create a header picture, not a floating worksheet picture. If you click in the grid instead of the header box, you may insert a regular picture onto the sheet by mistake.

Choose an image that prints cleanly

Use a clear, compact image with enough contrast to remain recognizable at the size it will occupy on paper. A logo with a transparent background can blend more naturally with the page than one saved on a solid white rectangle, while a very detailed image may become difficult to read when reduced. PNG and JPEG files are common choices for this task; use a version of the artwork that looks sharp at the intended print size.

Consider how the header will look on both color and black-and-white printers. A pale logo or thin lines may fade in grayscale, and colors can print differently from how they appear on a monitor. If a document will be distributed as a PDF, inspect the PDF itself as well as Excel’s preview, especially when precise branding or alignment matters.

  • Prefer a simple logo or mark over a large, information-heavy graphic.
  • Leave enough blank space around the logo so it does not collide with nearby header text.
  • Check that the picture is appropriate for the audience and does not contain confidential details that should not appear on every printed page.

Adjust picture size and placement

After inserting the picture, use the Format Picture button in the Custom Header or Custom Footer dialog to adjust its dimensions. Depending on the dialog available in your Excel build, you can set picture height and width or change scaling. If you set both dimensions independently, the image may look stretched; preserve its proportions where the controls allow, or use dimensions that match the source image’s shape.

Header pictures are positioned through the left, center, or right section and the page’s header area. They do not behave exactly like normal worksheet pictures: you cannot rely on dragging them freely over the grid to fine-tune their location. If the logo feels too low, too large, or crowded, reduce its dimensions, choose another section, or adjust the header margin in Page Layout > Page Setup rather than moving cells around.

Keep in mind that paper size, page orientation, scaling, and printer settings affect the available space. A logo that fits on a landscape page may crowd a portrait page. Make changes in small increments and recheck the preview after each adjustment.

Preview the header and configure page variations

Use View > Page Layout or File > Print to check the result. Print Preview is particularly helpful for seeing whether the header repeats as expected across multiple pages and whether the worksheet’s print area, page breaks, and margins leave enough room. The header may not be visible in Normal view, so its absence there does not by itself mean the image failed to insert.

In the Header/Footer tab of Page Setup, options can let you use a different first-page header or different odd- and even-page headers. These are useful for reports with a cover page or book-style printing. If you turn on a different-first-page option, do not assume the regular header picture will also appear on page one; set the first-page header separately if that is what you want. Similarly, odd/even settings can make the logo appear only on the header configuration you specify.

Common problems and fixes

  • The image is missing on the worksheet: Check in Page Layout view or Print Preview. Header content is not normally shown in the standard Normal view.
  • The picture is too large or overlaps text: Reopen Page Layout > Page Setup launcher > Header/Footer > Custom Header, select the relevant section, and use Format Picture to reduce its size. Also check the neighboring sections for text.
  • The logo is on only one worksheet: Header settings are worksheet-specific. Apply the header on each sheet that needs it and preview each sheet’s print layout.
  • The header disappears on the first page: Check whether a different first-page header is enabled. If it is, add the picture to that separate header or turn off the option.
  • The logo looks blurry or prints poorly: Try a sharper source image and inspect a print or PDF preview. A small source image enlarged substantially is more likely to look soft.
  • The picture does not appear in a shared workbook view: Confirm the file was saved after the change and inspect it in desktop Excel. A header picture is a page-layout element, not content placed in the visible cell grid.

Also distinguish a header picture from a regular picture placed above the worksheet cells. A cell-area picture can be positioned visually on the sheet and may print with the grid, but it can shift or overlap data as the layout changes. A header picture is more appropriate when the graphic should stay in the page header across printed pages.

Excel for Mac and Excel for the web

In Excel for Mac, use the page-layout tools to open the header area: Insert > Header & Footer, then choose the header section and use the picture control on the contextual Header & Footer tab. Ribbon arrangement can differ by Mac version, but the key is to insert the image while editing a header section, not as a normal worksheet picture. The Page Setup dialog may also be available through the page-layout controls.

Excel for the web does not provide the same complete desktop workflow for inserting a picture into a header. Open the workbook in the desktop Excel app to add or format the header image, then save it. The web version may not expose every print-layout editing control, so use desktop Excel when the header itself needs to be changed.

Frequently Asked Questions

Can I put a logo in an Excel header?
Yes. Open the Custom Header dialog, choose a section, and insert the logo as a picture. Use Format Picture and Print Preview to check its size and placement.

Why can’t I see my header image in Normal view?
Excel does not normally display header and footer content in Normal view. Switch to Page Layout view or open Print Preview to see how it will appear on printed pages.

Will the header picture appear on every worksheet?
No. Header and footer settings are assigned to worksheets. Add the picture to each worksheet that needs it, and check for different-first-page or odd/even-page settings that change which header appears.

Can I add the picture to the footer instead?
Yes. Choose Custom Footer in the Page Setup dialog and insert the image in its left, center, or right section. The same basic sizing and preview checks apply.

Can I use an image in an Excel header online?
For inserting and formatting a header picture, use the desktop Excel application. Excel for the web does not offer the full picture-in-header editing workflow available in the desktop app.

Related

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.