And at the same time, a new workbook is created with some information about this conversion. Then multiple workbooks are converted to PDF files. In the File Format Converter dialog, do as below operations:Ī: Select Excel workbook to PDF option in Type drop down list ī: Select workbooks from File or Folder option by clicking Plus button Ĭ: Select a folder to output the converted PDF files.ģ. Enable a workbook, and click Kutools Plus > Workbook > Format Converter. If you want to convert multiple workbooks as PDF files, you also can use Kutools for Excel’s File Format Converter.ġ. So far the selection has been exported as a PDF file and saved into the specified save directory.Ĭlick here to know more about Export Range to File.Ĭlick here to free download Kutools for Excel Then specify a name for exported PDF file in the poppin g Export Range to File dialog box, and click the Ok button. Tip: If you check Open the file after exporting option, the PDF will be open after exporting.ģ. In the Export Range to File dialog, check PDF under File format section, and go to select the options as you need under Workbook options section, then select a save location. Select the range you want to save as PDF, and click Kutools Plus > Import & Export > Export Range to File. If you want to save a selection of a worksheet as PDF file, you also can install Kutools for Excel, and use its Export Range to File utility to handle with this job.Īfter free installing Kutools for Excel, please do as below:ġ. Kutools for Excel’s Split Workbook utility can split each sheet of a workbook into separate and independent files, and save them as text, PDF, xls, xlsx or csv. However, you can use Kutools for Excel’s Split Workbook utility to quickly split a workbook and then save each sheet as separate PDF file. With Save As method, you only can save one sheet as a PDF file at a time, that is too tedious if there are many sheets needed to save as separate PDF files. Click Save, then the current sheet has been saved as PDF file. In the Save As dialog, select a folder to save the PDF file, and specify a name in File name textbox for the PDF, and select PDF from the drop down list of Save as type. Enable a sheet and click File or Office button > Save As. In Excel, you only can save the current sheet as a PDF file with Save As function at once time.ġ. Save each sheet of a workbook as separate PDF file with Kutools for ExcelĮxport a selection as PDF file with Kutools for ExcelĬonvert multiple workbooks as PDF file with Kutools for Excel Save one sheet as a PDF file at once time with Save as In Excel, you can save active sheet as a PDF file, but have you ever tried to save each sheet of a workbook as a separate PDF file? Now I introduce the tricks that can quickly save each sheet of a workbook as separate PDF file at once time. How to save each sheet of a workbook as separate PDF in Excel?
0 Comments
Leave a Reply. |