We may be compensated for your purchase of any of the products featured on this page – it helps us keep the lights on :) Show
There are many reasons why it’s important to know how to save an Excel file as PDF. You may need to preserve your sheet’s layout, fonts, images or other formatting after sharing. You might share a file with someone who may not have Excel. Or, perhaps, it’s a submission requirement. Whatever the reason, there are a few ways that you can save your Excel sheet as a searchable PDF. 3 Ways to Convert Your Excel File to a Searchable PDFWatch the tutorial: How to Save an Excel File as a PDF 1. Convert a portion of your Excel file to a PDFYou may only want to save part of your Excel sheet as a PDF. To convert only a portion of your worksheet to PDF:
This will save the section you selected along with any items in your Headers or Footers. 2. Convert an Entire Excel File to PDFTo save your entire Excel sheet as a PDF, you have a few options. To start:
NOTE: it’s a good idea to try and format your document the way you want it to look once you convert it to PDF before you convert it. Doing this will reduce the likelihood that you’ll need to go back and fix it. Clicking Save now will create a PDF of the printable area from your active worksheet or, if you grouped multiple sheets together, a PDF with all the sheets. Save as PDF or Select More OptionsOR Click on Options for, well, more options. Here are some things you can do from the Options menu: Select the Page Range to Convert to PDFIf the printable area of your active sheet spans multiple pages, select All to convert all pages in your active sheet into a PDF. PDF Options / Select All Pages in Active SheetSelect Pages to choose specific pages from your active sheet to convert to PDF. PDF Options / Select Page Range to Convert to PDFIn the Publish What section, you can select the portions of your sheet or workbook you’d like converted to PDF. Your options are: Selection: choosing Selection will convert only the currently selected areas of your sheet to a PDF, along with any headers or footers. Active Sheet: will convert the printable area of your active sheet(s) into a PDF. Group your sheets together to convert them all into the same file. Entire Workbook: converts all printable areas in your workbook into PDF. Table: If your spreadsheet has a Table, select this to convert it to a PDF. Ignore Print Areas: if your sheet(s) has custom print areas, selecting this will ignore them and print everything on the sheet. PDF Options / Publish What optionsOnce you’ve made your selections, click OK and Save to generate your PDF. If the option to Save as PDF is missingIf you don’t see an option to Save your file as a PDF, chances are that you do not have Adobe Acrobat installed. The Adobe Acrobat Reader option is free to use. It allows you to view, share, and save your files as PDF. For more flexibility in editing and creating PDFs, you’ll want to try the Adobe Pro DC version. 3. Windows 10 Options to Convert Your File to PDFIf you are using Windows 10, you have a couple more options to save your Excel file as a PDF. Convert your Excel file to PDF from the Print menuIf you are running Windows 10, you can use the Print menu to convert your Excel file into a PDF. Funny enough, this won’t send the file to your printer, but, instead, allow you to save your file in PDF format. How do I get Save as Adobe PDF in Excel?How to convert an Excel file to a PDF: Select file and open it in Microsoft Excel. Convert Excel spreadsheet to PDF: On Windows, click the Acrobat tab, then click “Create PDF.”
Why is save as PDF not an option in Excel?If you don't see an option to Save your file as a PDF, chances are that you do not have Adobe Acrobat installed. The Adobe Acrobat Reader option is free to use. It allows you to view, share, and save your files as PDF.
How do I add PDF as Save as type in Excel?Go to File menu > Export > Create PDF/XPS.
In Microsoft Office Excel, click on the File menu, select Export, and then Create PDF /XPS. In the Publish window, you can customize which part of the sheet you want to save as a PDF by clicking the Options button.
Why won't Adobe Acrobat Let me save as PDF?Change your storage settings.
To fix the problem, follow these steps: Open the file in Acrobat. Click File and choose Preferences at the bottom. In the Preferences panel, select General and check the box beside Show online storage when saving files.
|