How to Center an Image in Excel on a Worksheet or Page

How-to basics · Updated November 20, 2026

To center an image on a printed page in Excel for Microsoft 365 on Windows, open Page Layout > Margins > Custom Margins and select Horizontally, Vertically, or both under Center on page. To center it on the worksheet itself, position the picture relative to a defined cell area; Excel treats most pictures as floating objects, not as text inside a cell. The steps below cover both results, plus how to check the printout.

What You’ll Need

  • An Excel workbook and the picture you want to position. Save a copy before making substantial layout changes.
  • A clear idea of what you mean by centered: in a cell or cell range, in the visible worksheet area, or on the printed page. These are different layouts.
  • For precise worksheet placement, identify the cell range that should act as the target area. For print centering, know which cells should appear on the printed page.
  • Excel for Microsoft 365 on Windows is used for the ribbon paths below. Excel for Mac has similar picture and page setup controls, though names and locations can vary slightly. Excel for the web has fewer print-layout controls; use the desktop app for the print-centering options.

Step-by-Step

  1. Insert the picture and decide what area it belongs in

    In the worksheet, select the cell near the picture’s intended upper-left corner. Choose Insert > Pictures, then pick the source, such as This Device, and select the image. Excel inserts a floating picture over the grid in most cases. It can cover several cells, and selecting a cell underneath it does not select the picture.

    Before adjusting its position, decide which boundaries define the center. For example, you might want the image centered between columns B and G and rows 3 and 15, or centered on the page when printed. A picture can be centered in one sense and off-center in another.

  2. Set the picture’s size and proportions

    Click the picture. On the Picture Format tab, use the Height and Width boxes in the Size group to set a consistent size if you know the dimensions. To avoid distortion, keep the aspect ratio: open the Format Picture pane, choose Size & Properties, expand Size, and select Lock aspect ratio if it is available. You can also resize using a corner handle; avoid dragging a middle handle if you do not want to stretch the image.

    Size the image before fine positioning. Changing its width or height later moves its edges and changes its center, so you may need to repeat the alignment afterward.

  3. Center the picture precisely over a worksheet cell area

    Excel does not generally center a floating picture inside a selected range of cells with a single cell-alignment command. A practical method is to use a temporary rectangle as a target. First, choose Insert > Shapes > Rectangle and draw a rectangle over the cell area whose center you want to use. Hold Alt while drawing or resizing on Windows to help the rectangle edges snap to cell boundaries. Make the rectangle match the target area as closely as possible.

    With the rectangle selected, open Home > Find & Select > Selection Pane if needed. Use the pane to select both the rectangle and picture: click one object, then Ctrl-click the other. On the Picture Format or Shape Format tab, choose Arrange > Align > Align Center, then repeat and choose Align Middle. These commands line up the objects’ centers, placing the image in the center of the rectangle. If the Align menu offers Align Selected Objects, make sure that option is active rather than an option that aligns to a page or margin.

    Once the picture is positioned, select only the rectangle in the Selection Pane and press Delete. The picture stays in place. If selecting the two objects is awkward, leave the rectangle temporarily, use it as a visual guide, and drag the image until its center matches the rectangle’s center.

  4. Center the picture approximately in the visible worksheet area

    If you only need the picture to look centered while someone views the sheet, use the visible grid as your guide. Zoom to the level people will normally use, scroll to the desired area, and drag the image until its left and right margins appear equal and its top and bottom margins appear equal. Use the row and column headings or cell borders as reference points. The center of the visible window changes when the user scrolls, zooms, hides headings, or resizes Excel, so this is a visual placement—not a fixed screen position.

    For more repeatable placement, define a cell range as the target and use the temporary-rectangle method in the previous step. You can also keep the picture near a consistent cell location by choosing a picture property such as Move but don’t size with cells. Select the picture, open Format Picture > Size & Properties > Properties, and choose the behavior that suits the sheet. Move but don’t size with cells keeps the picture associated with its location as cells move, without resizing it when row heights or column widths change.

  5. Center the printed worksheet content on the page

    To center the printable area horizontally or vertically, choose Page Layout > Margins > Custom Margins. In the Page Setup dialog’s Margins tab, find Center on page and select Horizontally, Vertically, or both, then choose OK. This centers the printed worksheet content within the page margins; it does not necessarily center one picture independently of other printed cells.

    If the image is the only content you intend to print, set the print area to the cells behind and around it. Select those cells, choose Page Layout > Print Area > Set Print Area, and then set the page-centering options. Adjust the print area so it does not include distant cells with content that would make the page appear off-center or cause extra pages. In Page Layout > Scale to Fit, check the scaling settings, and use File > Print to preview the result before printing.

  6. Check the result in the right view

    For worksheet placement, return to Normal view and inspect the image against the intended cell area. For print placement, use File > Print and examine the preview. Page Layout view can also help you see page boundaries while editing. If the image looks centered in the sheet but not in the preview, adjust the print area, margins, or scaling rather than relying on its screen position.

    On Mac, use the Picture Format controls to resize and arrange the image, and look under Page Layout or the Page Setup dialog for margins and centering options. The precise dialog layout depends on the Excel version. Excel for the web may allow basic picture positioning, but for reliable page setup, print-area, and print-preview adjustments, open the workbook in Excel desktop.

Common Mistakes

  • Confusing screen centering with print centering. Dragging a picture to the middle of the visible grid does not make it print in the middle of the page. Use the print settings and preview for a page-centered result.
  • Expecting cell alignment to move a floating picture. The horizontal and vertical alignment buttons on the Home tab format cell contents. They do not center a picture that floats over cells. Use object alignment or move the image directly.
  • Aligning multiple objects without choosing the right reference. Align Center and Align Middle can align pictures with other selected objects. If you select two pictures by mistake, they may align with each other rather than the intended cell area. Use the Selection Pane to confirm which objects are selected.
  • Resizing unevenly. Pulling a side handle can squash or stretch the image. Resize from a corner or lock the aspect ratio, then reposition it if necessary.
  • Including unrelated cells in the print area. Distant content, blank formatted cells, or an old print area can change scaling and make the picture look off-center or print on an unexpected page.
  • Forgetting that grid edits affect placement. Inserting columns, changing row heights, or resizing columns can shift or resize a picture depending on its Properties setting.

Tips

  • Use the temporary rectangle method when you need a picture centered over a specific block of cells. It gives you a visible target and works even when the target area is not the whole worksheet.
  • Use the Selection Pane to rename objects, such as Picture 1 and Centering guide. Renaming makes it easier to select the correct item when objects overlap.
  • Keep the image’s edges inside the target area if you want a balanced margin around it. Equal center points do not guarantee equal-looking margins when the picture or target shape has been resized unexpectedly.
  • Check the placement at more than one zoom level. Zoom changes the view, not the picture’s actual worksheet position, but it can reveal a placement that only looked centered at one magnification.
  • For a simple printout, choose the print area first, then configure margins and scaling. This reduces the chance that Excel will fit a larger-than-expected range onto the page.
  • Keep an editable copy of the source image. Cropping and resizing in Excel can be changed, but preserving the original file makes it easier to restore the intended appearance.

Troubleshooting

The picture will not move. Click its edge rather than the image’s interior if the picture contains transparent areas, then drag. If a cell is selected instead, press Esc and click the picture border. Check whether the worksheet is protected; if it is, use Review > Unprotect Sheet if you have permission and the required password.

The image jumps or will not sit exactly where expected. Excel may be snapping the object to cell boundaries or other objects. Try holding Alt while dragging to align edges with grid boundaries, or turn off snapping if the relevant option is available in your version. Use the arrow keys for small nudges after selecting the picture. If a helper rectangle is involved, confirm that both the picture and the rectangle—not other pictures—are selected.

The picture moves or changes size after editing cells. Select it and open Format Picture > Size & Properties > Properties. Choose Move but don’t size with cells if it should follow its location without changing size, or Don’t move or size with cells if it should remain fixed relative to the sheet. These settings affect how the image responds to row and column edits; they do not lock it against deliberate dragging.

The preview is still off-center. Check the print area and remove unrelated cells from it. Reopen Custom Margins and verify the Horizontally or Vertically checkboxes. Also inspect orientation, paper size, margins, and Scale to Fit; scaling a wide or tall range can change the visual balance. The print preview is the most reliable check because worksheet position alone does not determine printed placement.

The alignment controls are unavailable. Confirm that the picture or shape is selected, not a cell. When selecting multiple objects, use the Selection Pane if overlapping objects make direct selection difficult. If the workbook is open in Excel for the web and the required arrangement or page setup controls are missing, open it in Excel for Microsoft 365 on Windows or Mac.

Frequently Asked Questions

Can I center a picture inside one Excel cell?

A floating picture can be positioned over a cell, but it is not automatically treated like text inside that cell. For precise placement, resize the cell area or use a temporary rectangle as a target and align the picture to its center. In versions that provide a Place in Cell option, that feature puts the image in the cell, but it changes how the image behaves and is not the same as centering a floating picture over a range.

Does Home > Center align a picture?

No. Home > Center changes horizontal alignment for the contents of selected cells. It does not move a floating image. Select the picture and use the Picture Format or Shape Format arrangement tools, or drag it into position.

How do I center an image on a printed page without centering the whole sheet?

Excel’s Center on page setting centers the printable worksheet content, not an individual picture in isolation. Make the intended image area the print area and avoid including other content that affects the page layout. Then use Custom Margins and check the print preview.

Why does the image look centered on screen but not when printed?

The worksheet view and printed page use different boundaries. Print area, margins, orientation, paper size, and scaling all affect the output. Set those options and judge the result in File > Print rather than by its position in the grid.

Can I center an image on both the worksheet and the page at once?

You can position the image over the center of a chosen cell range and separately center the print area on the page. The two centers match only when the selected range, print area, and page layout are arranged consistently. Verify both the worksheet view and print preview.

Will the picture stay centered if I change column widths?

Not necessarily. Its Properties setting determines whether it moves or resizes with cells. After changing row heights or column widths, check the position again; if you need the image centered within a resized range, repeat the alignment using the range as your target.

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.