Data Import & Export

Fix Excel Text Box Hyperlinks Losing URL Anchors in PDF Export

Natalie TaylorNatalie Taylor Nov 18, 2026 868 views

Question details

The user needs an Excel text box hyperlink to retain its URL anchor when the workbook is exported to PDF.

Fix Excel Text Box Hyperlinks Losing URL Anchors in PDF Export
Product
Microsoft Excel
Device & OS
not provided
Scenario
A text box links to a web page with a fragment identifier, such as adresse.htm#textnotinclude, and the workbook is exported to PDF.
Observed behavior
The exported PDF may omit the fragment identifier from the text box link, while the same link in a worksheet cell works.
Before you start

Open the workbook and test the full URL, including the # fragment, in a browser and in Excel. If the link uses a relative address, confirm that the destination will be accessible from the exported PDF.

Solution 1Recommended

Move the hyperlink to a worksheet cell before exporting

Use a cell hyperlink when the text box link loses its anchor in the exported PDF.

1
Select a cell

In Excel, select a worksheet cell where the clickable text can appear and enter a descriptive label.

2
Add the full hyperlink

With the cell selected, choose Insert > Link and enter the complete destination in the Address field, including the # fragment.

3
Export and test

Choose File > Export or File > Save As and select PDF. Open the PDF and click the cell link to confirm that it reaches the intended section.

Move the hyperlink to a worksheet cell before exporting
Check the destination: A named location or internal Excel link can be useful for navigation within a workbook, but it is not a substitute for an anchor on an external web page.
Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel formats, making it easy to move existing workbooks into WPS. Test exported PDF hyperlinks before sharing, as link behavior may differ between applications.

Open and edit Microsoft Excel XLS and XLSX filesWork with hyperlinks in spreadsheets and export sheets to PDFUse a familiar interface for a smoother transition from OfficeAccess a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does the PDF link open the page but not the intended section?

The PDF link annotation may have lost the fragment after the # character during export. Edit the link in Acrobat and enter the complete URL, including the fragment.

How do I add a hyperlink to an Excel cell?

Select the cell, choose Insert > Link, and enter the full destination in the Address field. Export to PDF and test the link.

Can I keep the text box clickable in the PDF?

Yes. In Acrobat, use Edit PDF > Link > Add/Edit Web or Document Link to edit the existing annotation or create a link area over the text box, then enter the full URL.

Will an internal Excel link replace a web page anchor?

No. An internal link points to a location in the workbook, while a URL fragment identifies a section of an external page. Use the full web address and fragment when the destination is a web page.