Export Excel to PDF with Hyperlinks (2 Quick Methods)

When we print or send any MS Excel file, we convert that file into a PDF and apply the required formatting to that file. When we share any MS Office file with another user, a change in formatting may occur if the receiver does not use the same MS Office version. We usually convert an Excel file into a PDF and send that file to avoid this problem. The PDF file keeps unchanged all the elements of the Excel file, like hyperlinks.

This article will discuss how to export Excel to PDF with Hyperlinks with proper explanation.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


2 Easy Methods to Export Excel to PDF with Hyperlinks

In this article, we will discuss how to export an Excel file into PDF with Hyperlinks. We can export the hyperlinks directly. Or we can use a function to convert it into a hyperlink and then export an Excel into PDF.

Here, we have taken a dataset of some popular websites.


1. Export an Excel File into PDF and Keep the Hyperlinks Unchanged

In our dataset, we have the input address of the most popular website. Now, we will this Excel file into a PDF.

Steps:

  • First, click on the File tab.
  • Now, choose the Save a copy option to export this into PDF.

  • A new window will appear to save the file. Choose PDF the Save as type. Then, click the Save button.

Export an Excel File into PDF and Keep the Hyperlink Unchanged

  • Now, open the PDF file.

Export an Excel File into PDF and Keep the Hyperlink Unchanged

  • Click on the cells of the Website column.

The hyperlinks work successfully after converting into PDF.

Read More: Excel VBA to Print As PDF and Save with Automatic File Name


Similar Readings


2. Use Excel HYPERLINK Function to Convert PDF with Hyperlinks

The HYPERLINK function creates a shortcut or jump that opens a document stored on your hard drive, a network server, or on the internet.

We will use this HYPERLINK function here. We can see in the dataset, that website addresses are present. Those are not hyperlinks. First, we will convert them into hyperlinks and then export them into PDF format.

Steps:

  • Go to Cell D4.
  • Put the following formula on that cell.
=HYPERLINK(C4,"Google")

Excel HYPERLINK Function to Convert PDF with Hyperlink

  • Now, press the Enter button.

Excel HYPERLINK Function to Convert PDF with Hyperlink The hyperlink is activated now.

  • In a similar way, we apply this Hyperlink function to other cells of the Nick Name column.

  • Now, export the Excel file into PDF and click any of the cells to enter the corresponding website.

Excel HYPERLINK Function to Convert PDF with Hyperlink

Read More: How to Convert Excel to PDF without Losing Formatting (5 Effective Ways)


Conclusion

In this brief article, we described how to export an Excel file into a PDF with hyperlinks. I hope this will satisfy your needs. Please have a look at our website ExcelDemy and give your suggestions in the comment box.


Related Articles

Alok

Alok

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo