Resize an Image in an Excel Header: Step-by-Step Guide

How-to basics · Updated November 20, 2026

To resize an image in an Excel header, open the sheet in Page Layout view, select the header section containing the picture, and choose Header & Footer > Format Picture. Set its height or width in the Size options, keeping Lock aspect ratio enabled if available, then check the result in print preview. You will need the desktop version of Excel and an image file; Excel for the web does not provide the same controls for adding and formatting header pictures.

What You’ll Need

  • A workbook open in Excel for Microsoft 365 on Windows. The Mac version has similar header tools, though their ribbon layout can differ.
  • The picture you want to use, saved somewhere you can browse to, such as your computer or an accessible folder. A compact logo or banner with little empty space around it is usually easier to size.
  • A printer or PDF is not required, but print preview is useful because header pictures are intended for page layout and printing rather than the normal worksheet grid.

Step-by-Step

  1. Choose the worksheet to edit. Open the workbook and select the sheet whose printed pages should show the picture. Header settings apply to the selected worksheet, not automatically to every sheet in the workbook. If several sheets need the same header, plan to repeat the steps for each one or group the sheets before editing, then check them individually afterward.
  2. Switch to a view where the header is visible. Choose View > Page Layout. The sheet will display page boundaries and header areas above the grid. You can also start from Insert > Header & Footer, which takes you into a page-layout view and lets you click a header area. In Normal view, the header itself is usually not displayed, so it can seem as if the picture has disappeared.
  3. Select the header section you want to use. Click the left, center, or right header area at the top of the page. Excel divides the header into these three sections. Choose one deliberately: a centered logo usually belongs in the center section, while a small company mark may fit better on the left. Avoid putting the image in a section that already contains text unless you want both items in that same area.
  4. Insert the picture if it is not there yet. With the header active, open the Header & Footer tab on the ribbon. In some Excel builds the contextual ribbon is labeled Header & Footer Tools and has a Design tab. Choose Picture, select the image source or file, and insert the image. Excel may show &[Picture] in the header while you are editing. That is a placeholder for the image, not an error or text that will print in place of it.
  5. Open the picture formatting controls. Click in the header section that contains the picture. Choose Format Picture on the Header & Footer ribbon. If the button is unavailable, click in the picture’s header section again and make sure a picture has actually been inserted. The Format Picture dialog contains size controls for the header image; it is separate from the usual Picture Format tools used for an image placed directly on a worksheet.
  6. Set a smaller or larger size. In the Format Picture dialog, open the Size options. Enter the desired Height or Width, or adjust the Scale values if your dialog offers them. Use the unit shown in the dialog, commonly inches, rather than estimating from screen pixels. For a proportional resize, keep Lock aspect ratio selected and change only one dimension; Excel will calculate the other dimension. If you need a precise printed size, enter that measurement and then verify it on the page.
  7. Apply the change and inspect the header. Confirm the dialog, then click another cell or outside the header to see the updated picture. If the result is too large, reopen Format Picture and reduce the size. If it looks distorted, recheck the aspect-ratio setting and replace the values with a proportional height or width. Do not use repeated trial-and-error stretching if the image is a logo, since that can make circles and lettering look visibly warped.
  8. Check the page and print result. Choose File > Print to inspect the print preview, or use the relevant print-preview option in your Excel build. Confirm that the image is not clipped at the top, hidden behind other header content, or too close to the page edge. Check more than one page if the worksheet spans multiple printed pages. If you use a different paper size or printer, preview that setup too, because page scaling and printable margins can change the apparent result.

Alternative route through Page Setup: You can also open Page Layout > Page Setup using the small dialog launcher in the Page Setup group, then open the Header/Footer tab and choose Custom Header. Select the left, center, or right section and use its picture control to insert an image. Return to the worksheet’s header editing controls to format the inserted picture. This route is useful when you are already adjusting print settings, but Page Layout view is often easier for seeing where the header sits.

On Mac: Excel for Mac also supports pictures in headers and footers in the desktop app. Look for Header & Footer on the Insert tab or use the Page Setup header and footer controls; labels and ribbon placement can vary by release. Select the picture’s header section and use its Format Picture or picture-formatting control to set the size. The Windows keyboard shortcut for switching views is not essential here; use the ribbon if a shortcut differs on your Mac. Excel for the web is more limited, so open the workbook in desktop Excel to add or resize a header picture.

Common Mistakes

  • Trying to resize the placeholder on the grid. A header picture is not an ordinary floating worksheet picture. It does not behave like an image inserted with Insert > Pictures on top of cells, so dragging worksheet-style corner handles is not the right method. Use Format Picture while editing the header.
  • Changing only one dimension with the ratio unlocked. If Lock aspect ratio is turned off, entering a width and height independently can stretch the image. This is particularly noticeable in logos, faces, and circular marks. Keep the ratio locked unless you intentionally need a non-proportional shape.
  • Judging the final size in Normal view. Normal view is designed around cells and typically does not show the printed header. Check in Page Layout view or print preview instead. A picture that seems absent in the grid may still be present in the header.
  • Expecting the header image to create more page space. Increasing image height does not necessarily move the worksheet content down enough to make room. The header margin and top margin affect where the header and grid print, so a large image can overlap or appear clipped if those margins are unsuitable.
  • Confusing a worksheet picture with a header picture. Inserting a picture onto the sheet places it over cells; inserting one through the header tools places it in the printed page header. Decide which behavior you need before editing. A picture over cells can be moved and resized directly, but it is not a substitute for a repeating print header.
  • Ignoring whitespace inside the image file. A logo can have a small measured width but look tiny because the file includes large transparent or white borders. Resizing the full image may not fix the visual imbalance. Crop or trim the source image in an image editor, then insert the cleaner version.

Tips

  • Start with a clean source image. Use a reasonably high-resolution image with the crop and orientation already set. Avoid enlarging a tiny image too far; it may print blurred even when the header dimensions are correct.
  • Choose a size based on the printed page. A logo that looks large on a monitor may occupy only a small part of a printed page, or the reverse. Use print preview and consider the paper size, orientation, margins, and scaling settings used by the workbook’s audience.
  • Keep the header uncluttered. Excel’s left, center, and right header sections are convenient for separating a logo from text such as a report name or date. If the picture and text compete for room in one section, put them in different sections or simplify the header.
  • Adjust margins when the image is clipped. Use Page Layout > Margins > Custom Margins to review the top and header margins. The header margin controls the header’s position from the top edge; the top margin controls where worksheet content begins. Change them carefully and recheck print preview, since a different margin can affect the whole printed page.
  • Save a copy before changing a shared template. Header edits are usually reversible with Undo, but a separate copy makes it easier to compare the original layout or restore a carefully formatted template if additional page settings are changed.
  • Test the workbook on its intended output. If the file will be printed, export or print a sample page using the expected paper size. If it will be shared electronically, check the PDF or print preview as well as the workbook. Excel’s screen display and a printer’s printable area are not always identical.

Troubleshooting

The picture is not visible. First switch to View > Page Layout and click the header section. If you see &[Picture], Excel has inserted a picture placeholder. If the placeholder is missing, select the section and insert the image again from Header & Footer > Picture. If the image is visible in Page Layout view but not on the worksheet grid, that is expected; check print preview to confirm that it will appear on the page.

Format Picture is missing or disabled. Make sure the active selection is inside the header section that contains the image, not in a worksheet cell. If necessary, click the section, confirm that the picture placeholder is present, and look for the contextual Header & Footer tools. If you are using Excel for the web, open the file in the desktop app, where the picture-formatting controls are available.

The picture is stretched or squashed. Reopen Format Picture and enable Lock aspect ratio if the option is shown. Enter a single dimension and allow Excel to calculate the other. If the current dimensions are already distorted, compare the proportions to the original image and reset them by inserting the original file again if needed.

The image is cut off or overlaps the worksheet. Reduce its height first, then inspect the header and top margins through Page Layout > Margins > Custom Margins. Make sure the header is not positioned too close to the printable edge and that the worksheet content has enough top margin. Preview every printed page, since a multi-page sheet may reveal a problem that is not obvious on the first page.

The logo still looks too small after increasing its size. Check whether the source file has large empty borders around the visible logo. Crop those borders in an image editor and insert the cropped file. Also check if the logo is placed in a narrow header section alongside text, and consider moving the text to another section rather than enlarging the picture until it crowds the page.

Frequently Asked Questions

Can I resize a header picture by dragging its corners?
No. A header picture is formatted through the header controls rather than the worksheet’s regular picture handles. Select the header section and open Format Picture to change its dimensions.

Will the header picture appear on every printed page?
Normally, a worksheet header repeats on each printed page of that worksheet. Check print preview, especially if the sheet uses different first-page headers, odd and even page settings, or multiple worksheets with different header configurations.

Why can I see the image in print preview but not in Normal view?
Headers and footers are page-layout elements, so Normal view generally does not display them. Switch to Page Layout view or print preview to inspect the header image.

Can I make the picture appear only on the first page?
Open the header and footer settings and look for Different First Page. When enabled, Excel provides a separate first-page header, so you can place the image there and leave the regular header blank. Preview the pages to confirm the setting behaves as intended.

Can I resize a header image in Excel for the web?
The web app does not offer the same full controls for inserting and formatting header pictures as desktop Excel. Open the workbook in Excel for Microsoft 365 on Windows or Mac to add or resize the image, then save the workbook.

Does changing header image size change its size on the worksheet?
No. Resizing the header picture changes its header appearance in page layout and print output. It does not resize worksheet cells or alter a separate picture placed over the grid.

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.