To show an image from a link in Excel for Microsoft 365, put the image’s direct URL in a cell, then use the IMAGE function in another cell to display it. The link must lead to an image file that Excel can access—not just a webpage containing the picture. This method keeps the image connected to the URL, so check that you have an internet connection and permission to access the image.
What You’ll Need
- Excel for Microsoft 365, updated to a version that includes the
IMAGEfunction. Excel for the web also supports the function; older perpetual versions such as Excel 2019 may not. - A direct, accessible image URL. A link beginning with
https://is preferable. The address should return an image file, such as a PNG or JPG, rather than a page with buttons, a preview, or a sign-in prompt. - A workbook cell for the URL and another cell for the displayed image. If you have many pictures, a simple two-column list makes the links easier to manage.
Step-by-Step
- Find and check the image link. Copy the image address from its source. If you are on a webpage, right-click the actual image and choose Copy image address or the equivalent option in your browser. The wording varies by browser. Paste the address into a new browser tab to check it: a suitable link should open the image itself, not a web page around it. If the link asks you to sign in, it may not work in Excel’s image function.
- Set up a cell for the URL. In Excel, select a blank cell, such as A2, and paste the link. Press Enter. Keep the URL in the cell rather than typing it into a formula: it is easier to inspect, replace, and reuse. If the address is long, widen column A or use the formula bar to review it. You can label A1 “Image URL” if you are organizing a list.
- Select where the picture should appear. Click the cell where you want the image, for example B2. The picture produced by the function is displayed in the cell; it is not a floating picture object that you can drag independently. Make sure the destination cell and its row have enough space to show the result.
- Enter the IMAGE formula. With the image URL in A2 and the picture intended for B2, enter this formula in B2 and press Enter:
=IMAGE(A2,"Product photo",0). The second argument is alt text, a short description for people using assistive technology. The final argument, 0, tells Excel to fit the image inside the cell while preserving its proportions. Replace “Product photo” with a description that matches your image. - Give the cell room. If the picture appears too small, increase the width of column B or the height of row 2. Drag the boundary between column letters to change a column width, or use Home > Format to set a row height or column width. With sizing mode 0, the image fits within the cell without being stretched out of proportion, so a narrow row or column can limit its displayed size.
- Check that the image is the right one. Confirm that the picture shown matches the URL and that it remains visible after recalculation. If you change A2 to a different direct image URL, the formula in B2 can display the replacement. For a list, put each URL in its own row and fill the formula down, updating the row reference as needed.
- Save and share with the right expectations. Save the workbook as an Excel file. Because the image is sourced by a URL, viewers may need internet access and permission to reach that image. If recipients need a picture that does not depend on an external link, use a static inserted image instead; see the note below.
The IMAGE function has optional sizing choices. The default and the example above use mode 0: fit the picture in the cell and keep its aspect ratio. Mode 1 fills the cell, which can crop part of the image; mode 2 displays it at its original size and may extend beyond the cell; mode 3 lets you specify a custom height and width. For most tables, mode 0 is the safest choice because it avoids distortion. If you try another mode, adjust the row and column dimensions and inspect the result.
If you need a picture embedded in the workbook rather than linked to a source, download the image first. In Excel for Windows, choose Insert > Pictures > This Device, select the downloaded file, and choose Insert. This creates a regular picture object, not an IMAGE formula. It is useful when the workbook must display the picture offline or when a recipient cannot access the original URL. On Mac, use Insert > Pictures > Picture from File or the equivalent available in your Excel build; labels can vary by version.
Common Mistakes
- Using a webpage link instead of an image URL. A product page or social-media post may display a picture in a browser but still be an HTML page. Excel needs an address that serves the image itself. Open the pasted address in a browser tab to distinguish the two.
- Copying a temporary or private link. Links that expire, require a login, or grant access only to the person who copied them can fail for you later or for workbook recipients. Use an image host that provides a stable, publicly accessible image address, or insert a downloaded copy if sharing permissions matter.
- Expecting a floating picture. The IMAGE function returns an image in a cell. It is not the same as inserting a picture object, so dragging the picture independently or layering it over cells is not how this method works. Use Insert > Pictures for a movable object.
- Making the cell too small or choosing the wrong sizing mode. A short row can make a correctly loaded image look like a tiny thumbnail. Mode 1 may crop, while mode 2 can appear larger than the cell. Start with mode 0, then set a sensible row height and column width.
- Confusing a text link with a picture. A URL displayed as blue, underlined text is only a hyperlink. It will not show the image by itself; put the address in the IMAGE function as described above.
Tips
Keep URLs and images in clearly labeled columns—for example, an “Image URL” column followed by a “Preview” column. That arrangement makes it simple to spot a missing address and update the source without editing the display formula. If you have a long catalog, test a few links first before filling the function down the whole sheet.
Write useful alt text rather than repeating a filename or saying only “image.” A short description such as “Blue ceramic mug, side view” is more informative. If the picture is purely decorative and conveys no information, consider whether descriptive alt text is needed for your workbook’s audience.
Use appropriately sized source images. A very large photo can take longer to load and may not look sharper when displayed in a small cell. Keep the original proportions; avoid resizing a row and column to force a picture into a shape that changes how it looks. For consistent thumbnails, make preview cells the same dimensions and use the same sizing mode.
IMAGE is available in Microsoft 365 and Excel for the web, but a workbook opened in an older Excel version may show an unsupported-function error instead of the picture. Mac users can use the same cell formula when their Excel version supports IMAGE; the ribbon labels and update timing may differ. If collaborators use mixed versions, check the workbook on the versions they rely on, or embed static pictures for a more portable result.
Troubleshooting
- The cell shows an error or no image. Check that the URL is complete, has no extra spaces, and opens the image directly in a browser. Confirm that you are online and that the image host is available. A link that redirects to a sign-in page, requires authentication, or blocks external requests may not be usable by IMAGE.
- You see
#BLOCKED!. Excel can block an image source for security or privacy reasons. Check whether the workbook or Excel’s connected-content settings restrict external content, and only allow content from a source you trust. If your organization manages these settings, ask its Microsoft 365 administrator rather than trying to bypass the block. - You see
#CONNECT!. Excel could not retrieve the image. Recheck the URL and your connection, then try opening the link in a browser. If the image host is temporarily unavailable, try again later. A URL that works only after you sign into a website may still fail in the worksheet. - You see
#VALUE!or the image format is rejected. Make sure the address points to a supported image file and not to a page, document, or unsupported format. Try a direct JPG or PNG link if the source offers one. Also check that the formula’s parentheses and quotation marks are paired correctly. - The formula name is not recognized. Your Excel build may not include IMAGE. Install available Microsoft 365 updates, or check the workbook in Excel for the web. If you use an older, non-subscription edition that does not support the function, download the picture and insert it with Insert > Pictures instead.
- The image is clipped, tiny, or distorted. First set the sizing mode to 0 and adjust the row height and column width. If the picture is still hard to see, verify that the source image itself has the expected dimensions and that the URL has not returned a thumbnail instead of the full-size file.
Frequently Asked Questions
Can I insert an image using a normal webpage link?
A webpage link usually points to a page, not the image file, so it may not display. Find the direct image address and test it in a browser. If the site does not provide a usable direct link, download the image and insert it as a picture.
Does the IMAGE function download the picture into my workbook?
It displays an image from the supplied URL; it is not the same as inserting an embedded picture file. The source must remain reachable when Excel needs to retrieve it. For a workbook that should carry the picture with it, insert a downloaded image using the Pictures command.
Can I make the picture fit inside a cell?
Yes. The example uses sizing mode 0, which fits the image within the cell while preserving its proportions. Increase the row height or column width if the result is too small. Mode 1 fills the cell but may crop the picture, so inspect it before using that option.
Can I use a link that requires a password or sign-in?
Usually, a link that requires a separate sign-in is not a reliable source for IMAGE. Excel may be unable to access the image even when it opens for you in a browser. Use an accessible direct link, check with the file owner about sharing permissions, or insert a downloaded copy where appropriate.
Will the image display for someone who opens the workbook?
It can, if their Excel version supports IMAGE, they have an internet connection, and they are allowed to access the image URL. Test the workbook with the intended recipient’s access in mind. For recipients who need offline access or cannot use the source link, embed the picture instead.
Can I use this method in Excel for Mac or Excel for the web?
Yes, when the version includes the IMAGE function. Enter the formula in a worksheet cell just as you would in Excel for Windows. Menu labels for inserting a downloaded picture can differ, and older Excel builds may not support the function.
Related
- Hide in Excel: Keyboard Shortcuts for Rows, Columns & Sheets
- How to Hide Long Text in Excel Cells Without Deleting It
- Hide Gridlines in Excel: Keyboard Shortcut and Steps
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- XLOOKUP in Google Sheets: How It Works and When to Use ItYes. XLOOKUP is a built-in Google Sheets function that searches a row or column for a value and…
- How to Print Gridlines in ExcelTo print gridlines in Excel for Microsoft 365 on Windows, open the worksheet, go to Page Layout, and…
- Data Cleaning Tools in Excel: What to Use and WhenExcel’s main data-cleaning tools are Power Query, Remove Duplicates, Text to Columns, Flash Fill, Find and Replace, and…
- Excel Date Converter: Turn Text, Numbers, and TimestampsAn Excel date converter turns date-like text or numbers into usable Excel dates, or converts Excel dates into…
- How to Change the Background View in Outlook on Any DeviceTo change Outlook’s appearance, open its appearance or theme settings and choose a light, dark, or colored theme;…
- Combine Multiple XML Files Into One Excel WorkbookYes. In Excel for Microsoft 365 on Windows, use Power Query to import XML files, select the repeating…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.