How to Highlight a Picture in Excel with a Custom Border

To highlight a picture in Excel for Microsoft 365 on Windows, select the picture, open the Picture Format tab, and use Picture Border to choose a color and line weight. You can also apply a glow or shadow from Picture Effects. These options make an image stand out on a worksheet; they are different from simply selecting it, which only shows handles while you edit.

The instructions below are for a picture placed on the worksheet. Before you begin, decide whether you want a neat outline, a more noticeable effect, or a temporary selection indicator. A border is usually the clearest choice for reports and printed sheets because it stays visible without obscuring the image.

What You’ll Need

A workbook open in the desktop version of Microsoft Excel for Microsoft 365, preferably with the picture already inserted.
A floating picture that you can click and format. If the image is inside a cell, some formatting and positioning options may be different.
A color and approximate border thickness that will contrast with both the picture and the worksheet background.

You do not need an add-in or a formula. If the image is not in the workbook yet, use Insert > Pictures, choose the appropriate source, and insert it before following the steps. The available picture-source choices can vary by account and Excel version.

Step-by-Step

Select the picture. Click once near the middle of the image. Small circles or squares should appear around its edges, and the contextual Picture Format tab should appear on the ribbon. If you see a cell cursor instead, you have selected the cell rather than the picture; click the image itself. Avoid clicking a resize handle unless you intend to change its size.
Open the picture-formatting tools. Click Picture Format on the ribbon. This tab appears when a picture is selected, so it may not be visible before you click the image. Look for Picture Border in the Picture Styles area. Depending on the width of the Excel window, some ribbon commands may be condensed into smaller buttons or menus.
Choose a border color. Click the arrow beside Picture Border and select a color from the theme or standard colors. Pick a shade that contrasts with the picture’s edges and the worksheet. A dark border can work well around a light image; a restrained accent color can draw attention without making the worksheet look crowded. If you use a theme color, it is more likely to coordinate with other workbook formatting.
Set the line weight. Open Picture Border again, point to or select Weight, and choose a line thickness. Start with a thin line for a small picture or a worksheet with lots of content. A thicker line can help a larger image stand out when the sheet is viewed at normal zoom or printed. The exact weight choices shown can depend on the Excel build.
Adjust the border style if needed. Under Picture Border, use Dashes to choose a dashed or dotted outline if that suits the design. For most business worksheets, a solid line is easier to read and looks more deliberate. A dashed border is better used sparingly, such as to mark a temporary example or a picture that needs review.
Check the result at a useful zoom. Click a blank cell to remove the selection handles and view the border as it will appear during normal worksheet use. If you only inspect the picture while it is selected, the handles can make the outline look heavier or obscure part of it. Zoom out or use Print Preview if the workbook is intended for printing.
Add an effect only if a border is not enough. Select the picture again, open Picture Format > Picture Effects, and inspect the available options, such as Shadow or Glow. Choose a subtle preset rather than stacking several effects. A glow can create a halo around an image, while a shadow can separate it from a plain background; both can look distracting in a dense table.
Save and verify the workbook. Save your changes, then deselect the image and confirm the formatting remains. If other people will open the file, check that the image and its border are still clear at the expected screen size. For a printed worksheet, use Print Preview to catch borders that appear too faint or too heavy on the page.

On a Mac, select the picture and use the contextual Picture Format tab and its border or effect controls; the ribbon layout and names can vary slightly by Excel release. In Excel for the web, select the image and look for the picture-formatting tab and border controls. Some effects and detailed formatting options may be limited compared with the Windows desktop app, so open the workbook in desktop Excel if a setting is missing.

Common Mistakes

Clicking the cell instead of the image. If the formula bar or cell selection is active and Picture Format does not appear, Excel probably has the cell selected. Click directly on the picture, or use the Selection Pane described in Troubleshooting.
Using a border that blends in. A pale outline on a white worksheet may disappear, while a very dark border can overwhelm a light picture. Check the image’s outer edge and the sheet background together, not just the color swatch.
Making the line too thick. A heavy border can hide a narrow part of the image and take attention away from the information it contains. Start thin, then increase the weight only if the outline is hard to see at the size readers will use.
Confusing selection handles with a highlight. The small handles around a selected picture are editing controls, not a permanent border. They disappear when you click elsewhere and are not a reliable way to mark an image for other readers.
Applying too many visual effects. A colored border, glow, shadow, and decorative preset together can make a worksheet look cluttered. Choose one primary treatment and keep it consistent with other pictures in the workbook.
Expecting an in-cell image to behave like a floating picture. Excel can handle pictures placed in cells differently from pictures that float over the grid. If the usual Picture Format controls are unavailable, check how the image was inserted and try selecting it directly; desktop Excel may offer more options.

Tips

Use a consistent style. If several pictures need emphasis, give them the same border color and weight. Consistency helps readers understand that the pictures have the same role, rather than suggesting that one image is more important by accident.
Keep the outline outside the subject. A picture border sits along the image boundary. If the subject is already close to the edge, consider cropping or resizing the picture before adding a thick line, so the outline does not make the subject feel cramped.
Think about accessibility and meaning. Color alone may not communicate why the picture is highlighted. Add a nearby label or explanatory text when the outline signals an important status, such as an image that needs checking. Keep enough contrast for readers who may not distinguish the chosen colors easily.
Use a shape when you need a custom callout. For a more visible frame than the picture-border controls provide, use Insert > Shapes and draw a rectangle around the image. Set the shape fill to No Fill and choose a line color and weight under the shape-formatting controls. Make the rectangle slightly larger than the image, and ensure it is in front of the picture; otherwise it can be hidden behind it. A shape is a separate object, so it may move independently from the image.
Plan for printing. Colors can look different on paper, and very thin lines may be difficult to see. Preview the printed page and consider a slightly stronger line if the border fades at the intended print size. Do not assume a bright on-screen glow will reproduce the same way on every printer.
Keep the original image intact. A border or picture effect changes how the image is displayed in the workbook; it does not improve the source image’s resolution. If the picture looks blurry, use a higher-resolution source rather than enlarging it and relying on a heavier outline.

Troubleshooting

Picture Format is missing: First click the picture once. If the tab still does not appear, open Home > Find & Select > Selection Pane in Excel for Windows. Select the picture’s entry in the pane, then return to the ribbon. This is useful when an image is behind a shape or difficult to click. If the entry is not listed, the selected object may not be a picture, or the image may be part of a different object.

The border command is unavailable or has no effect: Confirm that the picture itself is selected rather than a cell, chart, or shape. If the workbook is open in a browser, try opening it in the desktop app, where more formatting controls are available. If the picture is in a cell, test with a regular floating picture to see whether the limitation is related to its placement.

The border looks uneven or disappears on one side: Deselect the image and inspect it at a different zoom. Check whether another shape or picture overlaps the edge. If you used a separate rectangle, it may be behind the picture or positioned slightly off-center. Select the rectangle and adjust its size and order, or remove it and use Picture Border for a border attached directly to the image.

The outline is hard to see: Choose a more contrasting color and increase the weight one step at a time. Check the picture against the actual worksheet background, including any cell fill behind it. If the image itself has a dark edge, try a lighter border or a contrasting glow instead of making the line very thick.

The formatting seems to vanish: Click the image again and check whether the border is still selected in the Picture Border menu. Make sure you saved the workbook in a format that preserves its picture formatting, such as an Excel workbook. If you exported or copied the sheet into another program, the appearance may differ there.

Frequently Asked Questions

How do I highlight a picture without changing the image?
Use Picture Format > Picture Border to add an outline, or add a subtle glow. These are display-formatting choices; they do not paint over the picture itself. Keep the original image file if you also need an untouched copy outside the workbook.

Can I highlight a picture with a colored box around it?
Yes. Apply a picture border, or draw a rectangle with no fill around the image using Insert > Shapes. A border stays attached to the picture, while a separate rectangle may need repositioning if the picture moves.

Can I make the highlight transparent?
Picture Border offers color and line-style choices, but its controls are not the same as setting cell fill transparency. For a softer visual treatment, choose a lighter color or thinner line. Shape transparency settings apply to the shape fill, not automatically to a picture border.

Why can I see handles around the picture?
The handles indicate that the picture is selected and can be resized or moved. They are not part of the saved highlight. Click a blank cell to see the image without editing handles.

Does highlighting change the picture when I print?
Picture borders and effects are part of the worksheet’s formatting and generally appear in print output, but the result can vary with printer settings and scale. Check File > Print and review the preview before printing.

Can I highlight a picture in Excel for the web?
You can select an image and use the formatting controls available in the web app, but not every desktop effect or option is necessarily available. If you cannot find the border or effect you need, open the workbook in Excel for Microsoft 365 on Windows or Mac.

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.