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.
How to Export Excel to PDF with Hyperlinks: 2 Handy Methods
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.
- Now, open the PDF file.
- Click on the cells of the Website column.
The hyperlinks work successfully after converting into PDF.
Read More: How to Convert Excel to PDF without Converter
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")
- Now, press the Enter button.
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.
Read More: How to Convert Excel to PDF without Losing Formatting
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
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, give your suggestions in the comment box.
Related Articles
- How to Convert Excel to PDF with All Columns
- How to Save Excel as PDF on One Page
- How to Save Multiple Excel Sheets as One PDF
- How to Create a Fillable PDF from Excel
- How to Deal with Margin Problem While Converting Excel to PDF
- [Fixed!] Excel to PDF Size Problem While Printing
- [Fixed!] Excel to PDF Hyperlinks Not Working
- How to Save Excel as PDF without Cutting Off
<< Go Back to Export Excel to PDF | Export Data from Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
I am using =hyperlink method but acrobat still not brining my links to the documents. So strange. I think we should change some settings in preferences in Acrobat app.. (
Greetings, Fethiye Kiralik Villa. I am responding on behalf of ExcelDemy. I’ve tested the =hyperlink method, and it works perfectly for me. Make sure you have the latest version of Acrobat. Alternatively, you can try to reset all the settings in Adobe Acrobat Reader.