![]() Paste into blank Word document, then copy all values (not the whole table, just the column) Back in Excel, select the original column values, and paste the new values copied from Word in their place To get just the hyperlinks from our formula, we can copy values from Excel and paste into Word, then copy from Word and paste back into Excel (keeping source formatting). Printing to PDF will require that your hyperlinks are properly written before conversion (http… or https…). If you’re using the hyperlink formula, as seen below, we’ll need to do some manipulation to our sheet first. ![]() You can also use the Acrobat tab in the ribbon and click “Create PDF”. Just use the Acrobat add-in to save as Adobe PDF.įile –> Save as Adobe PDF –> Convert to PDF. ![]() If you do have Adobe, it’s quite simple unless you’re using the HYPERLINK() formula (see below). If you don’t have it, please skip down to the bottom of this post to the “Don’t have Adobe Acrobat?” section. To be able to maintain hyperlinks you will need Adobe Acrobat. If you have hyperlinks in your excel files and need to save your file as a PDF, you’ve probably run into the error in which your hyperlinks in the PDF output are inactive.
0 Comments
Leave a Reply. |