How to Add Hyperlinks to Embedded PNG Images in WPS Office Spreadsheets
Question details
The user needs to attach external URLs to PNG images already embedded in an Excel worksheet so the images can be clicked to open web pages or cloud-based files.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user has one or more PNG images placed in a worksheet and wants each image to link to a specific URL.
- Observed behavior
- Embedded PNG images do not carry external hyperlinks by default, so each URL must be added manually or through a VBA macro.
Make sure the PNG image is already inserted in the worksheet and that you have the target URL ready. If you plan to link many images at once, enable the Developer tab or VBA editor access in WPS Spreadsheets.
Add a Hyperlink to a Single PNG Image in WPS Spreadsheets
Use this quick method when you only need to link one image or a few images individually.
The hyperlink is attached to the selected image object, not to the underlying cell. This means moving the image keeps the link with the image itself.
Click the embedded PNG image in the worksheet so that selection handles appear around it.
Press Ctrl + K, or right-click the image and choose Link or Hyperlink from the context menu.
In the Insert Hyperlink dialog, select Existing File or Web Page, then enter the full URL in the Address field.
Click OK to close the dialog and apply the hyperlink to the selected image.
Batch-Add Hyperlinks to Multiple PNG Images Using a VBA Macro
Use this method when many images require links and you want to automate hyperlink creation based on selected cells or objects.
Add Clickable URLs to PNG Images in WPS Office Spreadsheets
Use WPS Office Spreadsheets to insert PNG images, attach hyperlinks directly with Ctrl+K, and save the workbook in .xlsx format so the links remain intact when opened in Microsoft Excel or shared through cloud storage.
- 1. Insert the PNG image: Open WPS Spreadsheets and go to Insert > Picture to place the PNG image in the worksheet.
- 2. Open the hyperlink dialog: Select the image and press Ctrl + K to open the Insert Hyperlink dialog.
- 3. Enter the target URL: Choose Existing File or Web Page and type the full URL in the Address field, then click OK.
- 4. Save and test: Save the workbook as .xlsx and Ctrl+Click the image to confirm the hyperlink opens correctly.
Frequently Asked Questions
Can I add a hyperlink to a PNG image in WPS Spreadsheets without using VBA?
Yes. Select the embedded PNG image, press Ctrl + K or right-click and choose Link, then enter the URL under Existing File or Web Page and click OK.
Why does clicking the PNG image not open the URL after adding a hyperlink?
A regular click may only select the image. Hold Ctrl while clicking the image to open the linked URL, and make sure the address is valid and the workbook is saved.
How can I hyperlink multiple embedded PNG images at once?
Use a VBA macro that loops through the selected cells or objects and calls ActiveSheet.Hyperlinks.Add with the URL assigned to each item. Test the macro on a copy before applying it to the full workbook.
Will the image hyperlink still work if I save the file as .xlsx?
Yes. WPS Office Spreadsheets preserves hyperlinks attached to images in Excel .xlsx format, so the link should remain clickable when the file is opened in Microsoft Excel.
Can I link an embedded PNG image to a cloud-based file?
Yes. Enter the shareable cloud file URL in the hyperlink Address field. Recipients must have the necessary access permission to open the cloud location.
