How to Create Clickable Image Links in Google Sheets Using HYPERLINK and IMAGE

Google Sheets is widely recognised as an exceptional platform for data manipulation, financial modelling, and collaborative tracking. Beyond traditional numerical tables, modern spreadsheets frequently serve as interactive project dashboards, visual e-commerce product catalogues, and asset management inventories. In these visual workflows, representing items with clickable thumbnail graphics rather than plain text URLs substantially enhances usability. By nesting the native IMAGE function inside the HYPERLINK formula, Google Sheets allows you to convert any cell-rendered picture into a fully functional, clickable hyperlinked button.

Understanding the Syntax: Combining HYPERLINK and IMAGE

To produce a clickable graphic inside a single spreadsheet cell, we combine two fundamental Google Sheets functions:

• HYPERLINK(url, [link_label]): Generates an active hyperlink pointing to the designated target destination web address.
• IMAGE(url, [mode], [height], [width]): Renders a hosted web graphic directly inside the cell boundaries.

When combined, the IMAGE() formula replaces the standard textual link_label argument inside the HYPERLINK() wrapper:

=HYPERLINK("https://example.com/target-page", IMAGE("https://example.com/image.png"))

When an end-user clicks or hovers over the cell containing this formula, Google Sheets displays a link preview badge that navigates directly to the specified destination URL upon clicking.

Step-by-Step Implementation

Follow these steps to construct an interactive image link inside your worksheet:

1. Ensure your image asset is publicly accessible over HTTPS (e.g. hosted on your corporate CDN, Imgur, GitHub raw content, or a public storage bucket).
2. Select the target cell in your spreadsheet (e.g. B2).
3. Enter the formula incorporating your destination URL and image link:

   =HYPERLINK("https://digitash.com", IMAGE("https://digitash.com/assets/logo.png"))

4. Press Enter. Google Sheets will download the graphical asset and scale it cleanly within the cell borders.

Controlling Image Scaling with IMAGE Modes

The IMAGE function accepts an optional second parameter that dictates how the graphic scales within cell dimensions. You can adjust column widths and row heights to fit thumbnails comfortably:

Mode Value	Scaling Behaviour	Best Used For
1 (Default)	Automatically fits the image inside the cell whilst preserving aspect ratio.	Standard product thumbnails and icon catalogues.
2	Stretches or compresses the image to fill the exact cell boundaries, ignoring aspect ratio.	Full-bleed cell backgrounds or decorative bars.
3	Retains the original pixel dimensions of the image, clipping any overflow.	Fixed-size pixel art and 1:1 badges.
4	Enables custom pixel dimensions specified by explicit height and width parameters.	Precision dashboard buttons and custom navigation bars.

Example: Custom Pixel Dimensions (Mode 4)

To lock an image link to an exact size of 64 pixels high by 64 pixels wide, specify height and width arguments in Mode 4:

=HYPERLINK("https://example.com/item/101", IMAGE("https://example.com/thumb.png", 4, 64, 64))

Building Dynamic Formulaic Catalogs

In real-world business scenarios, manually typing URLs into every cell is inefficient. You can make image hyperlinks fully dynamic by referencing adjacent data columns.

Suppose column A stores product target URLs and column B contains public image URLs. In cell C2, enter:

=HYPERLINK(A2, IMAGE(B2))

You can drag the fill handle down to generate hundreds of clickable product thumbnails instantly. Alternatively, leverage MAP and LAMBDA to generate an entire array without manual dragging:

=MAP(A2:A50, B2:B50, LAMBDA(target, img, IF(target="", "", HYPERLINK(target, IMAGE(img)))))

Important Formatting and Practical Tips

• Row Height Adjustment: By default, Google Sheets row height is 21 pixels. For thumbnail clarity, select your rows, right-click, choose Resize rows, and set height to 60 or 80 pixels.
• Public HTTPS Access: The image URL must be unauthenticated and serve over HTTPS. Internal intranet links or local file paths (such as C:\images\) cannot be rendered by cloud-based Google Sheets servers.
• Google Drive Workaround: If storing images in Google Drive, ensure file sharing is set to Anyone with the link can view and convert the Drive URL to direct thumbnail format: https://drive.google.com/uc?export=view&id=FILE_ID.