However, the latest version Adobe Reader XI does not have this feature available. Adobe Reader X and some previous versions had the option of installing an Adobe PDF printer that could be used for the conversion of Excel files to PDF format. Exporting Excel files to PDF using Adobe ToolsĪdobe tools do not work as efficiently as Microsoft for the Excel to PDF conversions however, they have the conversion feature incorporated in paid versions and subscriptions. The following screenshot illustrates this:Ģ. Then we can select ‘Fit Sheet on One Page’ under the settings and thereafter save the file as PDF. So to overcome this limitation, we can press Ctrl+P to open the print preview window before saving. Note: One limitation with this method is that using the ‘Save As’ option and choosing ‘PDF’ as file type will sometimes be on more than one sheet, which happens when the content of the file is more than a single PDF sheet’s fitting area. Now click on ‘OK, and this would convert the Excel file to PDF format.
Entire workbook: Selecting this option would convert the entire Excel workbook to PDF.Table: Selecting this option would convert the active table in the file to PDF.Active Sheet(s): Selecting this option would save the current active worksheet or all the selected worksheets in the file.Selection: Selecting this option will export or convert the currently selected range in the file.Now click on the ‘Options’ button in the ‘Save As’ dialog box and select one of the options as desired: The following screenshot illustrates this. If the converted PDF file’s size is considered more important than the print quality, select ‘Minimum size (publishing online). If the converted PDF file is to be of high-quality print, then select ‘Standard (publishing online and printing)’, and The following option is to be selected under ‘Optimize for’ in the ‘Save As’ dialog box. The following screenshot illustrates this: Now, after saving if we wish to view the converted PDF file, then checkmark the option: ‘Open file after publishing’ in the ‘Save As’ dialog box. Click on ‘File’ and then click on ‘Save As’ as below:.
If the entire Excel file needs to be saved as a PDF file, this step will be ignored. If non-adjacent worksheets are to be converted, press the ‘Ctrl’ button while clicking the tabs of each worksheet that need to be saved as PDF. If several adjacent worksheets are to be converted, then click the tab for the first worksheet, press the ‘Shift’ button, and then click the tab for the last worksheet. If a certain worksheet is to be exported, then it has to be made active by clicking on the sheet’s tab. If a table is to be exported, then place the cursor on any cell within the table.