To replace a picture in an Excel header, open the worksheet in desktop Excel, click the header section containing the image, delete its &[Picture] placeholder, then use Header & Footer > Picture to insert the new image. The change affects the worksheet’s printed pages, not the usual grid view. Have the replacement image saved somewhere you can find it before you begin.
What You’ll Need
- Desktop Microsoft Excel. These instructions are for Excel for Microsoft 365 on Windows. Excel for the web does not provide the same controls for inserting a picture into a header; open the workbook in the desktop app to make this change.
- The replacement image file. Save it on your computer or somewhere accessible through the file picker. A logo or other small, clear image is usually easier to fit than a large photograph.
- Permission to edit the worksheet. If the sheet or workbook is protected, you may need the password or an unprotected copy before you can change its header.
Step-by-Step
- Open the right workbook and worksheet. Open the file in Excel for Microsoft 365 on Windows and select the sheet whose printed pages have the header picture you want to replace. Headers belong to individual worksheets, so changing one sheet does not automatically change every other sheet in the workbook.
- Check whether sheets are grouped. Look at the sheet tabs. If more than one tab is selected or the title bar indicates a group, right-click a selected tab and choose Ungroup Sheets before editing. When sheets are grouped, a header change can be applied to all selected worksheets. Ungrouping helps prevent an unintended change across the workbook.
- Switch to a view that shows the header. Choose View > Page Layout. You can also use the Page Layout view button near the lower-right corner of the Excel window. This view displays the page area and its header and footer regions. Normal view generally does not show a header picture, so the image may appear to have vanished even though it is still part of the print layout.
- Open the header for editing. Scroll to the top of the page and click in the header area. Excel divides the header into left, center, and right sections; click the one containing the image. If the header has several pages, you only need to edit the worksheet header, not each visible page individually, unless different first-page or odd-and-even settings are enabled.
- Identify the picture placeholder. While a header is being edited, Excel represents an inserted picture with the code
&[Picture]. The picture itself may be visible when you click away from the header, while the code is visible during editing. If the section also contains wording, such as a company name, take care to select only the picture code so that the text remains in place. - Remove the old picture code. Click and drag across
&[Picture]in the header section, then press Delete. Check that the picture code has disappeared and any neighboring text is still there. If the section contains only the picture and you are unsure how to select the code, you can clear that section’s contents and re-create any text in it afterward. Do not use Remove Header unless you intend to remove the entire header, including its other text and fields. - Insert the replacement image. With the cursor in the same header section, select the contextual Header & Footer tab on the ribbon, then choose Picture in the Header & Footer Elements group. In the picture picker, choose the option to browse your device if prompted, locate the replacement file, select it, and confirm. Excel inserts a new
&[Picture]code in the header section. - Check the result outside edit mode. Click in the worksheet body or another area outside the header. Excel should display the new image in the page layout. If you still see the placeholder code, click away once more; the code is the editing representation, not necessarily an error. If the old image remains, return to the header and confirm that its picture code was removed before you inserted the replacement.
- Adjust the picture if necessary. Click the header section again and select Format Picture on the Header & Footer tab. Use the available picture-format options, such as setting a specific height or width, to make the image fit. Keep the proportions in mind: a logo that is stretched too wide or tall can look distorted. After changing its size, click outside the header to review it again.
- Preview the printed page and save. Select File > Print to check how the header looks on the page. Confirm that the image is positioned correctly, fits on the paper, and does not crowd nearby text. Return to the workbook, make any needed adjustments, and save with Ctrl+S. On Mac, use Command+S.
If you need the same replacement on several worksheets, edit each sheet separately after ungrouping the tabs. Alternatively, if you deliberately want the same header on multiple sheets, select and group only those sheets first, make the change once, and then ungroup them immediately. Check each sheet’s print preview afterward, since different page settings can make the same image look different.
Common Mistakes
- Editing the wrong header section. A picture in the left section will not be replaced by changing the center or right section. Click the section where the current image appears, and confirm its position again after inserting the new file.
- Deleting text along with the picture code. A header section can contain both a picture and text or other fields. Select only
&[Picture]when possible. If you clear the section, note its other contents first so you can restore them. - Expecting the image to show in Normal view. Headers are page-layout and print elements. Use Page Layout view or File > Print to inspect them rather than relying on the standard worksheet grid.
- Changing more sheets than intended. Grouped worksheet tabs can cause a header edit to affect multiple sheets. Ungroup tabs for a one-sheet change, and check the other sheets if you are uncertain whether grouping was active.
- Using Remove Header as a quick way to replace one image. That command removes the header’s other contents too. Remove only the picture placeholder if you want to preserve titles, dates, or other header fields.
- Judging size only by the worksheet window. The printed page has margins and a printable area that can make an image appear differently placed or scaled. Always check Print preview, especially before printing a multi-page report.
Tips
- Keep a copy of the original image. Replacing a header picture changes the image stored in the workbook, but retaining the source file makes it easier to reinsert or revise later.
- Choose a suitable image before opening the header. A simple logo with a transparent or plain background is often more legible than a detailed image. If the replacement is very large, resize a copy in an image editor first to make file handling easier.
- Use the picture-format settings for precise sizing. The Format Picture dialog is preferable to guessing at the size from the screen. After setting dimensions, review the image in Page Layout and Print preview to make sure it is still readable and not clipped.
- Keep header content in its own section when practical. Placing a logo in the left or right section and a title in another section can make future replacements less likely to disturb the text. Use the section that gives the best fit for your page design.
- Remember that first-page and odd/even headers can differ. Excel allows separate header settings for the first page and for odd and even pages. If the replacement appears on some pages but not others, inspect the header settings and edit the relevant version as well.
- Use the desktop app for edits. On Mac, the ribbon labels and dialog layout can differ slightly, but use the sheet’s header area and the Header & Footer picture control. Excel for the web may show printed layout features differently and does not offer the same picture-in-header editing workflow.
Troubleshooting
The picture code is visible instead of the new image. Click outside the header to leave edit mode, or switch to View > Page Layout. If the code remains in the header area after you leave it, reopen the section and check that the picture was inserted using the Picture command rather than typed as ordinary text.
The old picture is still there. The old placeholder may not have been removed, or the replacement may have been inserted into a different section. Click the section where the old image appears, edit it, and remove its &[Picture] code. Then insert the new image in that same section. If the workbook has different first-page or odd/even headers enabled, check whether you are looking at a separate header configuration.
The image is too large, too small, or distorted. Reopen Format Picture from the Header & Footer tab and adjust its dimensions. Avoid changing width and height independently in a way that alters the image’s proportions. Check the result in Print preview, because a size that looks acceptable on screen can still crowd the page or be clipped when printed.
The picture picker cannot find the file. Confirm that the image is saved locally or in a location you can access, then browse to that exact folder. If you are working with a file stored online, download a copy or make sure it is available offline before selecting it. If the picker is blocked by a permissions prompt, follow the prompt or ask your organization’s administrator.
You cannot edit the header. Check whether the worksheet or workbook structure is protected, and whether the file is open read-only. You may need to unprotect the sheet, obtain editing permission, or save an editable copy. If the header controls are unavailable in Excel for the web, open the workbook in desktop Excel and try again.
The new picture does not print as expected. Check File > Print and verify the paper size, orientation, margins, and header placement. If the image is missing only on a particular page, look for a different first-page or odd/even header. Also confirm that you inserted the image in the header, rather than placing it as a regular worksheet picture near the top of the grid.
Frequently Asked Questions
Can I replace a header picture without removing the rest of the header?
Yes. Edit the section containing the image and remove only the &[Picture] placeholder, then insert the replacement in that section. Leave any adjacent wording or fields untouched.
Why can’t I see the header picture in my worksheet?
Headers are designed for page layout and printing, so they generally do not appear in Normal view. Switch to View > Page Layout or open File > Print to inspect the header.
Will replacing the picture change every worksheet in my workbook?
Normally, a header change applies to the active worksheet. If several sheet tabs are grouped, the change can affect all grouped sheets. Ungroup sheets before making a one-sheet change, or intentionally group the sheets if you want them to share the edit.
Can I change the picture’s size after inserting it?
Yes. Select the header section and choose Format Picture on the Header & Footer tab. Adjust the picture dimensions and review the result in Page Layout view and Print preview.
Can I edit a picture in an Excel header on a Mac?
Yes, in the desktop version of Excel for Mac. Open the header area and use the Header & Footer controls to insert or format the picture. The ribbon and dialog layout may differ from Windows, so look for the picture command within the contextual header controls.
Can I replace the header picture in Excel for the web?
For this picture-in-header task, use the desktop Excel app. Open the workbook there, make the change, and save it; the updated workbook can then be reopened online.
Related
- How to Paste in Excel in Multiple Cells at the Same Time
- How to Paste an Excel Table into Yahoo Mail Cleanly
- How to Paste an Image in an Excel Cell
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Create a Table in Excel: Steps, Formatting, and FixesTo create a table in Excel, select a cell in your data, press Ctrl+T on Windows, confirm the…
- How to Flip Data Order in ExcelTo flip data order in Excel, add a temporary numbered helper column, sort the entire data range from…
- Open an Excel File in Read-Only Mode: Step-by-Step GuideTo open a workbook without saving changes over the original, start Excel for Microsoft 365 on Windows, go…
- How to Disable Autofit Row Height in Excel ManuallyTo keep Excel row heights from changing, select the rows, turn off Wrap Text if you need a…
- Excel Not Letting You Insert an Image? Causes and FixesIf Excel will not let you insert an image, first check whether the sheet is protected or the…
- Excel Data Validation Lists: Can They Include Formatting?No. In Excel, a data validation list controls which values users can choose or enter; it does not…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.