Resize a Picture in an Excel Header: Step-by-Step

How-to basics · Updated November 20, 2026

To resize a picture in an Excel header, open the header in Page Layout view, insert the picture, select its picture placeholder, and use the Format Picture controls to set its height and width. In Excel for Microsoft 365 on Windows, this changes the picture’s printed size; it does not resize a picture placed over worksheet cells. Have the image file ready, and use the desktop app because Excel for the web does not provide the full header-picture editing controls.

What You’ll Need

  • A workbook open in the desktop version of Excel for Microsoft 365. The steps below use Windows; Mac differences are noted where relevant.
  • The picture file you want to use, such as a logo or small graphic. A clear image with a simple background is usually easier to read when printed.
  • A printer or PDF preview if you want to check the final printed appearance. You can also use Excel’s Print Preview before printing.

Step-by-Step

  1. Save the workbook and open the right sheet. If the workbook contains multiple worksheets, select the sheet whose printed pages should have the picture. Headers and footers are set separately for each worksheet, so adding a logo to one sheet does not automatically put it on every other sheet. Saving first gives you a safe point to return to if the layout needs adjustment.
  2. Open the header editing controls. On Windows, select Page Layout > Page Setup and click the small dialog box launcher at the lower-right corner of the Page Setup group. In the dialog, open the Header/Footer tab. You can also switch to Page Layout view and click the header area at the top of the page, but the Page Setup dialog is a reliable way to reach the custom header options.
  3. Choose the header section for the image. Click Custom Header. The dialog has three boxes: Left section, Center section, and Right section. Click in the section where you want the image to appear. For example, choose the Left section for a logo aligned to the left margin, or Center section for a centered mark. A header can contain content in more than one section, but avoid crowding the same line.
  4. Insert the picture. With the intended section active, click the Insert Picture button, which looks like a small landscape, and select the image file. Depending on the Office build, Excel may open a file picker or an online picture source. Choose the local file or appropriate source, then confirm the selection. The section will show the code &[Picture]. That code is a placeholder for the image, not a mistake or text that will print as-is.
  5. Open the picture formatting dialog. Confirm the header section still contains the picture placeholder, then select Format Picture. In many Windows builds, this button is available on the contextual Header & Footer tab after you return to the sheet and select the picture placeholder. If you are still in the Custom Header dialog, click OK to return to Page Setup, click OK again, and then click the header area in Page Layout view. Select the placeholder before choosing Format Picture.
  6. Set a new size. In the Format Picture dialog, open the Size tab. Enter the desired Height and Width, using the units shown in the dialog. If you want to keep the image proportional, make sure Lock aspect ratio is selected before changing one dimension. For instance, if the logo is too tall, reduce its height and let Excel adjust its width rather than entering two unrelated measurements.
  7. Apply the changes and inspect the sheet. Click OK in Format Picture, then click outside the header to see the page. The image might not appear while you are editing the header because Excel can show the placeholder code instead. Switch to View > Page Layout if needed, or use File > Print to inspect the preview. Check that the image is visible, positioned correctly, and not clipped by the page edge.
  8. Adjust margins or placement if necessary. If the picture is the right size but too close to the top of the page, open Page Layout > Page Setup again and review the Margins tab. Adjust the Header margin or top margin carefully, then check Print Preview again. If the image is too large for the available header area, reduce its size in Format Picture rather than trying to drag it around like a worksheet image.

On Excel for Mac, the names and positions of the Page Setup and header controls can vary slightly by release, but use the sheet’s Page Setup options to open Header/Footer, choose Custom Header, insert the picture, and edit its size through the picture-formatting controls. Excel for the web may display a workbook’s existing print settings, but use desktop Excel to add or resize a header picture.

Common Mistakes

  • Resizing a picture on the worksheet instead. An image inserted with the regular Insert Picture command sits over cells. It is not part of the page header, so changing its size will not update the header. Use the picture button inside the Custom Header dialog for a true header image.
  • Typing over the picture code. The &[Picture] placeholder is how Excel represents a header image while the header is being edited. Deleting it removes the image from that section. To change the picture’s size, select the placeholder and use Format Picture; do not replace the code with a typed filename or dimensions.
  • Changing width and height without preserving proportions. Setting both values independently can stretch a circular logo or make a person look wider or narrower. Keep Lock aspect ratio enabled when possible. If the checkbox is unavailable or you need a specific shape, use an image editor to crop or prepare the artwork before inserting it.
  • Expecting the header picture to show in Normal view. Headers are print-layout elements. Excel’s standard grid view may not display them, even though the picture is present and will print. Check Page Layout view or Print Preview before assuming the image has disappeared.
  • Confusing the page header with column headings. The header is the area at the top of printed pages and can contain text, page numbers, dates, or a picture. Column headings such as A, B, and C are worksheet labels. Resizing a header image does not alter those labels or the cells below them.
  • Ignoring the printer’s printable area. A picture can fit inside the header settings but still look cut off in a printout if it is close to a page edge or the printer has large nonprinting margins. Use Print Preview and leave breathing room around the image.

Tips

  • Measure the result in print context. The Format Picture dialog may show dimensions in inches or another unit, while the on-screen preview is affected by zoom. Use the dialog values to make deliberate adjustments and judge the final result in Print Preview, not by screen size alone.
  • Use the correct header section for alignment. The left, center, and right sections align content within their respective parts of the header. If a logo should sit beside a report title, consider putting the logo in one section and the text in another, then preview the page to ensure they do not overlap.
  • Prepare an image with suitable whitespace. Transparent or white space inside the source image can make a logo look smaller than its measured picture box. Crop excess blank space in an image editor before inserting it, or account for it when deciding the size.
  • Keep the original image proportions. If you know the desired height but not the matching width, select Lock aspect ratio and change only the height. Excel calculates the corresponding width from the image’s original shape, helping avoid distortion.
  • Check multiple printed pages. A header repeats on pages printed from the same worksheet, but page orientation, scaling, and margins can make it look different across layouts. If you use landscape pages, different paper sizes, or a print area, verify the preview for each relevant setup.
  • Remember that headers are sheet-specific. If several worksheets need the same logo, repeat the header setup on each sheet or group the worksheets before making an appropriate change. Be cautious when sheets are grouped: edits can affect every selected sheet, and the sheets may have different page layouts.

Troubleshooting

The picture does not appear after insertion. First check that you inserted it from Custom Header, not from the worksheet’s Insert tab. Then click OK to close the dialogs and inspect the sheet in Page Layout view or Print Preview. In the header editing area, the &[Picture] code may appear instead of the graphic. If the code is missing, reopen Custom Header and insert the picture again in the section you intend to use.

Format Picture is unavailable or you cannot select the image. Click directly in the header section containing the placeholder, rather than on a cell or blank part of the page. If necessary, reopen the Custom Header dialog and confirm that the section contains the picture. Close the dialog with OK, select the header area in Page Layout view, and look for the contextual Header & Footer tab. If the desktop ribbon is collapsed, expand it so its controls are visible.

The picture looks stretched, squashed, or blurry. Reopen Format Picture and check Lock aspect ratio, then correct the dimensions. Distortion can also come from a source image that was already stretched before insertion. A blurry result usually means the original image is too small for the printed size; insert a higher-resolution version rather than enlarging a low-resolution file repeatedly.

The picture is clipped or overlaps other header content. Reduce its height or width, move it to a different header section, or remove unnecessary text from the same section. Then inspect the Header margin and Top margin in Page Setup. A graphic can occupy more vertical space than its visible artwork suggests, especially if its file includes blank margins.

The picture looks correct on screen but prints at the wrong size. Check File > Print and verify the selected paper size, orientation, margins, and scaling settings. Print scaling can change the appearance of page elements, and printer margins may differ from the worksheet preview. If the workbook is sent to another computer, ask the recipient to check the same settings before printing.

You are using Excel for the web. Open the workbook in the desktop Excel app to create or edit a header picture. If you cannot switch apps, ask someone with desktop Excel to make the change, or place a regular image in the worksheet as an alternative—but note that a worksheet image is not a true repeating print header and may need separate positioning on each page.

Frequently Asked Questions

Can I resize a header picture by dragging its corners?
Usually, no. Header pictures are edited through the Format Picture dialog rather than the normal worksheet-image handles. Select the header picture placeholder and enter its height or width in the Size tab.

Will the picture appear on every worksheet in my workbook?
No. Header and footer settings generally belong to individual worksheets. Add the picture to each sheet that needs it. If you group sheets to apply the same change, check that the sheets have compatible layouts and ungroup them afterward.

Why do I see &[Picture] instead of the actual image?
Excel can show the picture placeholder code while you are editing a header. Click outside the header, switch to Page Layout view, or open Print Preview to see the rendered image. If it remains absent there, reinsert it in the correct header section.

Can I use a different picture in the left and right header sections?
Yes. Each section can contain its own content. Insert a picture in the left section, then repeat the process in the right section for another image. Preview the page because large graphics in separate sections can overlap when the printable width is limited.

Can I resize a header picture in Excel for the web?
Use Excel for Microsoft 365 on Windows or Mac for the full header-picture editing workflow. The web version has limited support for page layout and headers, so open the workbook in the desktop app to insert or resize the image reliably.

Does changing the picture size change the header margin?
No. The picture’s dimensions and the page’s header margin are separate settings. If the picture is the right size but sits too high, low, or close to the edge, adjust the margins in Page Setup and verify the result in Print Preview.

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.