#EXPORT EXCEL TO PDF PDF#

#EXPORT EXCEL TO PDF PDF#

Previous versions, including Adobe Reader X, allowed users to install an Adobe PDF printer for converting Excel files to PDF format. Exporting Excel files to PDF using Adobe ToolsĪdobe tools do not work as efficiently as Microsoft for 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 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 the file type will sometimes be on more than one sheet, which happens when the file’s content is more than a single PDF sheet’s fitting area. Now click ‘OK,’ which converts the Excel file to PDF format.Entire workbook: 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): This option would save the current active worksheet or all the selected worksheets in the file.Selection: 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 you consider the size of the converted PDF file more important than the print quality, you should select the ‘Minimum size (publishing online)’ option. If the converted PDF file is to be of high-quality print, then select ‘Standard (publishing online and printing)’, and The following option will 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, checkmark the option: ‘Open file after publishing’ in the ‘Save As’ dialog box. Click on ‘File’ and then click on ‘Save As’ as below:.This step will be ignored if the entire Excel file needs to be saved as a PDF file. To convert non-adjacent worksheets, press the ‘Ctrl’ button while clicking the tabs of each worksheet that you want to save as a PDF. If several adjacent worksheets are to be converted, 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, it must be made active by clicking on the sheet’s tab. If a table is to be exported, place the cursor on any cell within the table. Open the Excel file and select the range of sheets you want to convert to PDF format.Now, if we wish to export any selected range, table, worksheet, or the entire file to PDF format, then we follow the below steps: Let us say we have an Excel file that has 4 worksheets in it. In the below examples, we will show how an Excel file can be converted to PDF format: Some common ways to convert an Excel file to PDF format are: 1. Examples to Convert Excel Files into PDF Format

Export excel to pdf