Add a Border to an Image in Excel: Step-by-Step

How-to basics · Updated November 20, 2026

To add a border to an image in Excel for Microsoft 365 on Windows, select the picture, open the Picture Format tab, choose Picture Border, and pick a color. Use Picture Border > Weight to change the thickness, or Picture Border > Dashes to choose a line style. The border is applied to the picture itself, so it moves and resizes with the image.

This is useful for separating a photo from worksheet cells, making a logo stand out, or giving several images a consistent appearance. The steps below apply to a picture placed over worksheet cells. If your image was inserted inside a cell, see the troubleshooting section because cell images may not offer the same picture-formatting controls.

What You’ll Need

  • A workbook in Excel for Microsoft 365, preferably the desktop app on Windows. Ribbon labels and available picture tools can differ slightly on Mac or in Excel for the web.
  • A picture in the worksheet. To add one, use Insert > Pictures and select an image from your device or an available picture source.
  • Optional: a preferred border color and thickness. Consider the worksheet background and whether the image will be printed or shared on screen.

Step-by-Step

  1. Select the picture. Click once on the image in the worksheet. You should see selection handles around its outside edge, and a contextual Picture Format tab should appear on the ribbon. If you see a cell selection instead, click the image again or choose it from the Selection Pane.
  2. Open Picture Format. Click Picture Format on the ribbon. Depending on the Excel window width, some controls may be grouped or shown as icons. This is a contextual tab, so it appears only while a picture or supported graphic is selected.
  3. Open the border menu. In the Picture Styles group, click Picture Border. Be sure to choose Picture Border rather than Shape Outline. Picture Border formats the image object, while Shape Outline is intended for shapes and can produce a different result.
  4. Choose a color. Select a theme color or a standard color from the menu. For a custom shade, choose More Outline Colors if it is available, then select a color in the dialog and confirm. A dark gray or black line often works on a light worksheet; a white line can separate an image from a dark background.
  5. Set the line weight. With the picture still selected, open Picture Border again, point to Weight, and choose a thickness. Start with a subtle line for a document or report. Increase the weight if the image is small, will be viewed at a distance, or needs to be clearly separated from nearby content.
  6. Choose a dash pattern if needed. Open Picture Border, point to Dashes, and select a pattern such as a solid or dashed line. Solid is the clearest general-purpose choice. Use a patterned border only when it supports the design; small dashes can look crowded around a compact image.
  7. Check the result at normal viewing size. Click a blank cell to deselect the picture, then inspect the border. Selection handles can make an outline look heavier or harder to judge. Zoom in briefly if you need to check the corners, then return to the zoom level people will normally use.
  8. Adjust the picture without losing its border. Drag a corner handle to resize the picture proportionally, or move it by dragging from its interior. The border follows the picture. Avoid dragging a side handle unless you intend to stretch the image, because that can distort the picture and its outline.
  9. Save and check the workbook in its intended format. Save the file as an Excel workbook if you need to keep editing it. If you plan to print, use File > Print to preview the page layout and confirm the border remains visible at print size. For a PDF, check the exported or printed result as well.

To remove the border later, select the picture, open Picture Format > Picture Border, and choose No Outline. This removes the picture outline without deleting the image. If you only want to change its appearance, choose a different color, weight, or dash style instead.

Common Mistakes

  • Choosing Shape Outline instead of Picture Border. The ribbon may show outline controls for other selected objects. Confirm the picture itself is selected and use Picture Format > Picture Border. If the wrong object is selected, click the image or select it by name in the Selection Pane.
  • Expecting the border to frame the visible subject. The outline follows the picture’s rectangular boundary, including any empty or transparent area around the subject. It does not trace the shape of a person, product, or other object inside the image.
  • Using an overly thick line. A heavy border can dominate a small picture or make a page feel crowded. Start with a light weight, inspect it at the worksheet’s normal zoom, and increase it only if the outline is difficult to see.
  • Assuming a color change has failed because the picture is deselected. A thin line in a similar color to the worksheet can be hard to notice. Select the image again and temporarily choose a contrasting color to confirm the outline is there, then set the final color.
  • Confusing a cell border with a picture border. Home > Borders applies formatting to cells, not to a picture placed over the grid. It can frame the cells beneath an image, but that frame will not necessarily move or resize with the picture.
  • Stretching the image while resizing it. Pulling a side handle changes the image’s proportions. Use a corner handle to keep the original proportions, particularly when the image contains a logo, face, or text.

Tips

  • Use consistent formatting for a group of pictures. Apply the same border color and weight to related images so they look like part of one set. Select and format each picture, then compare them together in the worksheet rather than judging each one in isolation.
  • Choose contrast for the viewing context. A border that is visible on a white worksheet may disappear against a colored cell or a dark photo. Check the outline against the area immediately around the image, not only against the overall sheet background.
  • Use a border to clarify layout, not to replace spacing. Leave some room between nearby pictures and text. A border can define an image’s edge, but it cannot prevent a crowded layout from feeling cramped.
  • Check print output separately from screen display. Thin lines can look clear on a monitor but faint on paper, especially with a low-quality printer or a reduced print scale. Use Print Preview and adjust the weight if the border is hard to see.
  • Keep an unmodified copy of important source images. Picture Border changes the Excel object’s formatting, not the original image file, but preserving the source makes it easy to reuse the image elsewhere with different styling.
  • Use the Selection Pane when images overlap. Go to Home > Find & Select > Selection Pane to view objects in the sheet. Select the relevant picture from the list, then apply its border from Picture Format.

Troubleshooting

Picture Format does not appear. The picture may not be selected, or you may have selected a cell or another object. Click the image once and look for selection handles. If objects overlap, use Home > Find & Select > Selection Pane and select the picture by its listed name. If you are using Excel for the web, the ribbon may show fewer picture controls than the desktop app; open the workbook in the desktop version if the needed border settings are unavailable.

Picture Border is missing or disabled. Check that the selected object is a picture that can be formatted, rather than a cell containing an image, a chart, or a grouped object. For an image inserted in a cell, try selecting a picture placed over cells instead: use Insert > Pictures, then choose an option that places the image on the worksheet rather than in a cell. The precise insertion choices can vary by Excel version and platform.

The border appears invisible. Reopen Picture Format > Picture Border and select a contrasting color. Also check whether the weight is very thin or the picture has transparent margins. Click outside the picture to remove selection handles and inspect the actual outline. If you are viewing the sheet at a small zoom, enlarge the display temporarily.

The border does not print as expected. Use File > Print to inspect the page preview and confirm the picture is inside the print area. If the image is scaled down to fit the page, a thin outline may become difficult to see. Adjust the picture size, print scaling, or border weight, then preview again. Check the printer or PDF output rather than relying only on the worksheet display.

The border is attached to the wrong object. Undo immediately with Ctrl+Z on Windows (Command+Z on Mac), select the image, and apply Picture Border again. If the border was applied to cells, it may remain after changing the picture; select the affected cells and use Home > Borders to remove or revise those cell borders.

Frequently Asked Questions

Can I add a border to an image in Excel without changing the picture file?
Yes. Picture Border adds formatting to the picture object in the workbook. It does not edit the source image file on your computer, so the original remains unchanged.

Can I make the border thicker or change it to a dashed line?
Yes. Select the image and use Picture Format > Picture Border > Weight for thickness or Picture Format > Picture Border > Dashes for a different line pattern. The available choices can vary slightly across Excel versions.

How do I add a border to every image in a worksheet?
Format each picture individually, or select multiple picture objects together if your Excel version allows you to select them with Ctrl-click (Command-click on Mac). Then apply the border. Check the result carefully, because selecting multiple objects can be difficult when images overlap or are grouped.

Can I use a custom border color?
In desktop Excel, open Picture Format > Picture Border and choose More Outline Colors if it appears. Choose a color in the dialog and confirm. If the option is not available in your version or in Excel for the web, use a nearby theme or standard color instead.

Why does my image have no Picture Format tab?
The image may not be selected, or it may be an in-cell image rather than a floating picture object. Select the picture itself and look for handles. If it is stored in a cell, insert or convert it to a picture placed over cells, then check whether the picture-formatting tab becomes available.

Does a picture border move when I move the image?
Yes. A border applied with Picture Border belongs to the picture object, so it moves and resizes with it. A border applied to worksheet cells is separate and stays with those cells instead.

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.