This isn’t ideal but in a pinch will save you some stress. In this article, you will be shown the symptoms and causes of Excel memory error how to avoid seeing the error message Excel not enough memory and how to. How can i add a button to my excel sheet to print a specific area of my sheet and also another button for saving that area as pdf. Save the Excel Sheet as a web page and links will work. Adding Buttons to excel sheet to save as pdf and print those selected area. Now when you save as Adobe PDF, your links will remain active: Don’t have Adobe Acrobat? 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. Here are the steps you need to follow: Select the range of cells that you want to save in the PDF file. Is there a way that the PDF file can create a folder on the users desktop and save the file with a file name based on specific cells in the sheet If multiple copies of the same sheet are saved/printed to PDF can each copy have a number eg. It takes advantage of Excel’s built-in PDF converter. This method is suitable for you if you are using Excel versions 2007 and higher.

If you do have Adobe, it’s quite simple unless you’re using the HYPERLINK() formula (see below). Method 2: Saving a Selection to PDF using the Publish As Dialog Box. 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.

Kutools excel won't print to pdf