Select Duplicate or Unique Rows Select Blank Rows (all cells are empty) Super Find and Fuzzy Find in Many Workbooks Random Select.

Merge Cells/Rows/Columns without losing Data Split Cells Content Combine Duplicate Rows/Columns.Super Formula Bar (easily edit multiple lines of text and formula) Reading Layout (easily read and edit large numbers of cells) Paste to Filtered Range.Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by See screenshot:ĭemo: Save multiple worksheets as many separate PDF files So far all selected worksheets are saved as separate PDF files in the specified destination folder, and each PDF is named with corresponding worksheet name. In the opening Browse For Folder dialog box, select the destination folder you will save the PDF files into, and click the OK button. (2) The Skip blank worksheets option will prevent from splitting blank worksheets and saving as separate files.ģ. (1) The Skip hidden worksheets option will prevent from splitting hidden worksheets and saving as separate files. (3) Click the drop down list under Specify save format option, and select PDF (*.pdf) from it. (2) Check the Specify save format option (1) In the worksheet name section, please check the worksheets that you will save as separate PDF files In the Split Workbook dialog box, please do as follows: Open the workbook whose worksheets you will save as separate PDF files, and click Kutools Plus > Workbook > Split Workbook.Ģ. Full feature free trialģ0-day, no credit card required! Get It Nowġ. Apart from repeating save each worksheet as a separate PDF file, Kutools for Excel’s Split Workbook utility can help you get it done with only several clicks in Excel.ģ00 handy tools for Excel.

Sometimes, you may want to save multiple worksheets as many separate PDF files in Excel.

Excel in mac creates pdfs of all tabs