To put a clickable link to an image in an Excel cell, select the cell and press Ctrl+K on Windows, enter the image’s web address or file location, then choose OK. If you want the image itself to be clickable, insert it as a picture object and add the hyperlink to the picture. To show an online image inside a cell, use Excel’s IMAGE function instead; that displays an image but does not make it a clickable link.
These are three different results, so choose the method that matches your goal: a text link in a cell, a clickable picture, or an image displayed in a cell. The steps below are for Excel for Microsoft 365 on Windows. Excel for the web and Mac have similar options, with a few differences noted.
What You’ll Need
- An Excel workbook you can edit. If it contains important data, save a copy before changing its layout.
- The destination for the link: either a complete web address, such as an image’s HTTPS URL, or a file you can access.
- For a picture that appears in the sheet, an image file such as JPG or PNG, or a direct image URL that Excel can access.
- For a web image, a stable, publicly accessible direct image address. A webpage address may open a page rather than show the image itself.
Step-by-Step
- Decide what the cell should do. If readers should click text in a cell to open an image, use a cell hyperlink. If they should click the visible picture, insert a picture and link the picture. If the image just needs to be visible in the grid, use Place in Cell or the IMAGE function. You can combine a displayed image with a separate link in a neighboring cell for a clear, dependable layout.
- Prepare and check the destination. For an online image, copy its full URL, including
https://, and paste it into a browser to check that it opens the image or a page where the image is available. For a local file, know its location and consider whether other people who open the workbook can access that same path. A link to a file on your computer may not work for someone using a different computer. - Create a text hyperlink in a cell. Click the cell where the link should appear. Press
Ctrl+K, or choose Insert > Link on the ribbon. In the Insert Hyperlink dialog, select Existing File or Web Page if that option is shown. Enter or paste the web address in the address field. In Text to display, type a useful label such as “Open product photo” rather than a long URL, then choose OK. Excel adds a clickable link to the selected cell. - Test the cell link. In desktop Excel, you may need to hold
Ctrlwhile clicking the linked cell to follow it; the exact behavior depends on Excel’s hyperlink settings. Check that the correct image or destination opens. If it does not, edit the link and compare the address with the one that worked in your browser. - Insert a picture if the image should be visible in the sheet. Choose Insert > Pictures, then select an image source such as This Device. Find the image and insert it. In current Microsoft 365 versions, you may see a Place in Cell option under Insert > Pictures. Choose it if you want the image to belong to a cell rather than sit on top of the grid. If you insert a regular picture, it is a floating object that can be resized and moved over cells.
- Make a floating picture clickable. Click the picture’s border so the picture object—not a worksheet cell—is selected. Press
Ctrl+Kor choose Insert > Link. Paste the image URL or other destination in the address field and confirm. Click away, then test the picture link. If Excel selects the picture instead of following the link, use the hyperlink-following behavior noted above or right-click the picture and choose the link option if it appears in your version. - Display an online image with IMAGE, if appropriate. If you have a direct image URL and want the image rendered in a cell, enter a formula in the target cell. For example, with no special cell layout assumed, enter
=IMAGE("https://example.com/photo.jpg","Product photo",0)and replace the example address with a direct, accessible image URL. The third argument,0, fits the image within the cell while preserving its proportions. Adjust the row height and column width if the image looks too small. This formula displays the image; it does not turn the image into a hyperlink. - Save and verify the workbook on its intended device. Save the file, then test the link or image again. If you are sharing the workbook, test a web link from another account or device when possible. Links to local files can break when the workbook is moved, and online images may be blocked by permissions or network settings.
On Mac, use Command+K instead of Ctrl+K to open the link dialog. The ribbon’s Insert and Pictures options may be arranged differently, and the exact Place in Cell availability depends on the Microsoft 365 build. In Excel for the web, use Insert > Link for a cell hyperlink; picture insertion and editing options can be more limited than in the desktop app.
Common Mistakes
- Expecting an image URL to display a picture automatically. A hyperlink opens a destination; it does not render the image in the cell. Use Place in Cell or IMAGE when the picture must be visible.
- Linking the cell when you meant to link the picture. A hyperlink added while a cell is selected belongs to the cell. To make a floating picture clickable, select the picture itself before opening the link dialog.
- Using a webpage URL where a direct image URL is needed. IMAGE requires a supported image source it can retrieve. A URL to a gallery, login page, or image-search result may not work as an image source.
- Relying on a local file path for a shared workbook. A link such as a file stored in your Downloads folder may point to a location that exists only on your computer. Use an accessible shared location or a web link if collaborators need access.
- Assuming the displayed image is automatically clickable. An image created with IMAGE is displayed as cell content, but the formula does not create a hyperlink. Put a link in a separate cell or use a linked picture object if clicking the visual is essential.
- Forgetting that row and column sizes affect pictures. An in-cell image may look tiny if its row or column is narrow. A floating picture may overlap nearby data if it is too large.
Tips
- Use descriptive link text, such as “View invoice scan” or “Open item photo.” This is easier to understand than a long URL and helps readers identify the destination before clicking.
- Keep the image link and its description together. For example, put a thumbnail in column A, an item name in column B, and a clearly labeled link in column C. This makes the action obvious even if a thumbnail cannot load.
- For IMAGE, use a direct HTTPS image address that does not require a sign-in. Some websites prevent other services from displaying their images, even when the URL looks correct.
- Choose whether a picture should move and resize with cells. For a floating picture, use its formatting options to control how it behaves when cells move or change size. For a picture that should remain part of the grid, use Place in Cell where available.
- Keep original images at a reasonable size before inserting many of them. Large images can increase workbook size and make scrolling or sharing slower.
- Use a clear visual cue for links, such as a short label or a note saying “Click image to open full size.” Do not rely only on color to show that something is clickable.
Troubleshooting
The link opens the wrong page or reports that it cannot be found: Select the linked cell or picture, open its link settings, and inspect the complete address for missing characters, spaces, or an outdated URL. Test the address in a browser. If it is a local file link, confirm that the file still exists and that the person opening the workbook has permission to reach it.
Clicking the link selects the cell or picture instead of opening it: In desktop Excel, try holding Ctrl while clicking. On Mac, try holding Command while clicking. You can also right-click the linked cell or object and choose the link-opening command if it is available. In Excel for the web, clicking behavior can differ, so use the link’s context menu or open the workbook in the desktop app to check the destination.
IMAGE shows an error or a blank result: Confirm that the formula contains a direct image URL, begins with https://, and is enclosed in straight double quotation marks. Open the URL in a browser without signing in. If the site blocks external image requests, use an image hosted somewhere accessible or insert a local copy with Insert > Pictures. IMAGE is available in Microsoft 365 and supported Excel versions; older editions may not recognize it.
The image is cropped, too small, or distorted: If you used IMAGE, check its sizing argument and adjust the cell’s row height and column width. Sizing value 0 fits the full image inside the cell; value 1 fills the cell and may crop part of the image. If you inserted a floating picture, drag a corner handle to resize it proportionally rather than dragging a side handle.
The picture does not move with the intended cell: It may be a floating object positioned over the grid, not an in-cell picture. Use Insert > Pictures > Place in Cell if your Excel build offers it, or adjust the floating picture’s properties so it moves and resizes with cells. If Place in Cell is unavailable, keep the picture aligned manually or use IMAGE with an accessible URL.
Frequently Asked Questions
Can I put a clickable image directly inside an Excel cell?
Excel can display images in cells with Place in Cell or IMAGE, and it can add hyperlinks to cells or picture objects. The most dependable way to make the visible picture itself clickable is to insert a floating picture and add the hyperlink to that object. If you use an in-cell image, test the behavior in the version your audience will use; a separate link cell is a reliable alternative.
How do I add a link to an image file on my computer?
Select a cell, press Ctrl+K, and browse to the image file or enter its location, then add display text and choose OK. The link may work only on your computer if the file is stored locally. For a shared workbook, move the image to a shared folder or an accessible online location and update the link.
Can I make an image open at full size when clicked?
Yes. Add a hyperlink to the full-size image address. If you want a smaller clickable picture in the worksheet, insert a thumbnail as a floating picture and link that picture to the larger image. Check that the full-size destination is accessible to workbook users.
Why does my image URL show text instead of a picture?
A URL entered into a cell is text or a hyperlink unless you use an image feature. To render an online image in a cell, use IMAGE with a direct image URL, or download the picture and insert it with Insert > Pictures. Some sites block external display, so not every web address will work.
Can I use IMAGE and HYPERLINK together to make one clickable picture?
Do not rely on nesting those functions to create a clickable image. IMAGE displays a picture, while HYPERLINK creates a link with a text or value label; this combination is not a dependable way to make the rendered picture clickable. Use a linked picture object, or put a clearly labeled hyperlink in an adjacent cell.
Related
- How to Hide Rows in Excel: Keyboard Shortcuts and Tips
- How to Hide Rows in Excel: Keyboard Shortcuts Guide
- Google Sheets: Highlight Duplicate Values with Color
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Find Duplicate Data in Excel: Step-by-Step GuideTo find duplicate data in Excel, select the cells you want to check, then choose Home > Conditional…
- Conditional Formatting for Absolute Values in ExcelTo conditionally format values by their absolute size in Excel for Microsoft 365 on Windows, create a formula…
- Excel Date to String: Format Dates as TextTo convert an Excel date to a text string, use the TEXT function: with a date in A2,…
- Remove a Dropdown from a Google Sheets TableTo remove a dropdown in Google Sheets, select the affected cell or range, open Data > Data validation,…
- Insert a Personal Signature in Word Online: Steps and TipsYes. In Word Online, the most reliable way to insert a personal signature is to add it as…
- Create a DAX Measure in Excel: Step-by-StepTo create a DAX measure in Excel for Microsoft 365 on Windows, add your data to the workbook’s…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.