The PDF looks just like your InDesign document, and anyone with a free PDF reader can view it: Choose File Export. In the Export dialog box, change the name of the file, choose Adobe PDF (Print) for the format. The Adobe PDF (Interactive) format is for saving a PDF with interactivity added in InDesign, like links, buttons, video, and more. There are examples of how to save files as PDF/A from existing products you may have listed on the Introduction to PDF/A page. If you use tools that are not listed on our Introduction to PDF/A page, another generic method of saving or converting documents to PDF/A is to use converters or tools that you install as a 'printer'. If you want to edit them after saving to PDF you buy from Adobe or also save your original document before going to File-Export As-Export as PDF because PDF is supposed to be a final product export. JEDIMASTER ( 2019-06-09 12:55:27 +0100) edit.
What you would do is open up the page you want and proceed as if you're going to print the pages you'd like to split to your printer. Instead of selecting your physical printer, select your PDF printer. The PDF printer will take those pages and create a new PDF with a new file name. Type in the file name and save where you want to save it.
How to save multiple worksheets/workbooks as PDF file in Excel?
We can save a worksheet as a separate PDF file easily with the Save As feature in Excel, but how about saving multiple worksheets as a separate PDF file in Excel? And what if batch saving multiple worksheets as many separate PDF files quickly in Excel? The following methods will help you solve them.
- Save multiple worksheets as many separate PDF files
Save multiple worksheets as a single PDF file
This method is talking about saving multiple worksheets as a single PDF file in Excel. Please do as follows:
1. Open the workbook whose worksheets you will save as single PDF file, and select these worksheets in the Sheet Tab bar simultaneously. See screenshot:
Notes:
(1) Holding the Ctrl key, you can select multiple nonadjacent worksheets in the Sheet Tab bar by selecting them one by one.
(2) Holding the Shift key, you can select multiple adjacent worksheets in the Sheet Tab bar by selecting the first one and the last one.
2. Click the File (or Office button) > Save As.
3. In the opening Save As dialog box, select the destination folder you will save the PDF file into, type a name for the new PDF file into the File name box, and select the PDF (*.pdf) from the Save as type drop down list. See screenshot:
4. Click the Save button.
So far, all selected worksheets are saved into one PDF file, and each worksheet stays in a separate page.
Save multiple worksheets as many separate PDF files
Sometimes, you may want to save multiple worksheets as many separate PDF files in Excel. 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.
Kutools for Excel- Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required!Get It Now
1. Open the workbook whose worksheets you will save as separate PDF files, and click Kutools Plus > Workbook > Split Workbook.
2. In the Split Workbook dialog box, please do as follows:
(1) In the worksheet name section, please check the worksheets that you will save as separate PDF files;
(2) Check the Specify save format option;
(3) Click the drop down list under Specify save format option, and select PDF (*.pdf) from it. See screenshot:
(4) Click the Split button.
Notes:
(1) The Skip hidden worksheets option will prevent from splitting hidden worksheets and saving as separate files.
(2) The Skip blank worksheets option will prevent from splitting blank worksheets and saving as separate files.
3. In the opening Browse For Folder dialog box, select the destination folder you will save the PDF files into, and click the OK button.
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. See screenshot:
Demo: Save multiple worksheets as many separate PDF files
The Best Office Productivity Tools
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
- Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails..
- 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..
- Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns.. Prevent Duplicate Cells; Compare Ranges..
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select..
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more..
- Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments..
- Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic..
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF..
- More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
- To post as a guest, your comment is unpublished.Is there a setting that can make this not work? 95% of the time its fine, but occasionally I get Excel files from a certain client where it won't save multiple at once and I wondered if they have some setting I can overide
- To post as a guest, your comment is unpublished.When saving all worksheets as pdf files my system hangs after 50% 311 separate worksheets please assist
- To post as a guest, your comment is unpublished.Hi ben keet,
Did the error occur when applying the Split Workbook feature of Kutools for Excel? Any problems about Kutools for Excel come out, please contact support@extendoffice.com
- To post as a guest, your comment is unpublished.what version of micro excel is needed to do this method?
- To post as a guest, your comment is unpublished.Hi rachel,
Excel 2007 and higher versions.
Microsoft Excel supports to export as PDF file since Excel 2007. Therefore, the first method can work in Excel 2007 or higher version.
The second method use the Excel add-in – Kutools for Excel. And Kutools for Excel works in Excel 2007 and later version.
- To post as a guest, your comment is unpublished.OMG thank you so much. The save multiple sheets as one PDF thread saved me from destroying my computer. Why would microsoft not make a check box to do it for you?
- To post as a guest, your comment is unpublished.I laughed with this!! Only bc I have been in that position so many times!!! lol
- To post as a guest, your comment is unpublished.MUITO OBRIGADA! ADOREI, SALVOU MEU DIA!
You can save your changes to an Adobe PDF or PDF Portfolio in the original PDF or in a copy of the PDF. You can also save individual PDFs to other file formats, including text, XML, HTML, and Microsoft Word. Saving a PDF in text format allows you to use the content with a screen reader, screen magnifier, or other assistive technology.
If you don't have access to the source files that created an Adobe PDF, you can still copy images and text from the PDF to use elsewhere. You can also export the PDF to a reusable format, or export images in a PDF to another format.
Adobe Acrobat Reader users can save a copy of a PDF or PDF Portfolio if the creator of the document has enabled usage rights. If a document has additional or restricted usage rights, the document message bar under the toolbar area describes the assigned restrictions or privileges.
Usethis method to save PDFs, including PDF Portfolios,and PDFs in which you have added comments, form field entries, anddigital signatures.
Note:
How to save multiple worksheets/workbooks as PDF file in Excel?
We can save a worksheet as a separate PDF file easily with the Save As feature in Excel, but how about saving multiple worksheets as a separate PDF file in Excel? And what if batch saving multiple worksheets as many separate PDF files quickly in Excel? The following methods will help you solve them.
- Save multiple worksheets as many separate PDF files
Save multiple worksheets as a single PDF file
This method is talking about saving multiple worksheets as a single PDF file in Excel. Please do as follows:
1. Open the workbook whose worksheets you will save as single PDF file, and select these worksheets in the Sheet Tab bar simultaneously. See screenshot:
Notes:
(1) Holding the Ctrl key, you can select multiple nonadjacent worksheets in the Sheet Tab bar by selecting them one by one.
(2) Holding the Shift key, you can select multiple adjacent worksheets in the Sheet Tab bar by selecting the first one and the last one.
2. Click the File (or Office button) > Save As.
3. In the opening Save As dialog box, select the destination folder you will save the PDF file into, type a name for the new PDF file into the File name box, and select the PDF (*.pdf) from the Save as type drop down list. See screenshot:
4. Click the Save button.
So far, all selected worksheets are saved into one PDF file, and each worksheet stays in a separate page.
Save multiple worksheets as many separate PDF files
Sometimes, you may want to save multiple worksheets as many separate PDF files in Excel. 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.
Kutools for Excel- Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required!Get It Now
1. Open the workbook whose worksheets you will save as separate PDF files, and click Kutools Plus > Workbook > Split Workbook.
2. In the Split Workbook dialog box, please do as follows:
(1) In the worksheet name section, please check the worksheets that you will save as separate PDF files;
(2) Check the Specify save format option;
(3) Click the drop down list under Specify save format option, and select PDF (*.pdf) from it. See screenshot:
(4) Click the Split button.
Notes:
(1) The Skip hidden worksheets option will prevent from splitting hidden worksheets and saving as separate files.
(2) The Skip blank worksheets option will prevent from splitting blank worksheets and saving as separate files.
3. In the opening Browse For Folder dialog box, select the destination folder you will save the PDF files into, and click the OK button.
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. See screenshot:
Demo: Save multiple worksheets as many separate PDF files
The Best Office Productivity Tools
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
- Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails..
- 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..
- Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns.. Prevent Duplicate Cells; Compare Ranges..
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select..
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more..
- Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments..
- Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic..
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF..
- More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
- To post as a guest, your comment is unpublished.Is there a setting that can make this not work? 95% of the time its fine, but occasionally I get Excel files from a certain client where it won't save multiple at once and I wondered if they have some setting I can overide
- To post as a guest, your comment is unpublished.When saving all worksheets as pdf files my system hangs after 50% 311 separate worksheets please assist
- To post as a guest, your comment is unpublished.Hi ben keet,
Did the error occur when applying the Split Workbook feature of Kutools for Excel? Any problems about Kutools for Excel come out, please contact support@extendoffice.com
- To post as a guest, your comment is unpublished.what version of micro excel is needed to do this method?
- To post as a guest, your comment is unpublished.Hi rachel,
Excel 2007 and higher versions.
Microsoft Excel supports to export as PDF file since Excel 2007. Therefore, the first method can work in Excel 2007 or higher version.
The second method use the Excel add-in – Kutools for Excel. And Kutools for Excel works in Excel 2007 and later version.
- To post as a guest, your comment is unpublished.OMG thank you so much. The save multiple sheets as one PDF thread saved me from destroying my computer. Why would microsoft not make a check box to do it for you?
- To post as a guest, your comment is unpublished.I laughed with this!! Only bc I have been in that position so many times!!! lol
- To post as a guest, your comment is unpublished.MUITO OBRIGADA! ADOREI, SALVOU MEU DIA!
You can save your changes to an Adobe PDF or PDF Portfolio in the original PDF or in a copy of the PDF. You can also save individual PDFs to other file formats, including text, XML, HTML, and Microsoft Word. Saving a PDF in text format allows you to use the content with a screen reader, screen magnifier, or other assistive technology.
If you don't have access to the source files that created an Adobe PDF, you can still copy images and text from the PDF to use elsewhere. You can also export the PDF to a reusable format, or export images in a PDF to another format.
Adobe Acrobat Reader users can save a copy of a PDF or PDF Portfolio if the creator of the document has enabled usage rights. If a document has additional or restricted usage rights, the document message bar under the toolbar area describes the assigned restrictions or privileges.
Usethis method to save PDFs, including PDF Portfolios,and PDFs in which you have added comments, form field entries, anddigital signatures.
Note:
Saving a digitally signed PDF invalidates the signature.
To save changes to the current file, choose File > Save.
To save a copy of a PDF, choose File > Save As.
In Acrobat Reader, choose File > Save As or File > Save As Other > Text.
To save a copy of a PDF Portfolio, choose File >Save As Other > PDF Portfolio.
Note:
If you are viewing a PDF in a web browser, the Acrobat File menu is not available. Use the Save A Copy button in the Acrobat toolbar to save the PDF.
The Autosave feature guardsagainst losing your work in case of a power failure by incrementally,and at regular intervals, saving file changes to a specified location.The original file is not modified. Instead, Acrobat createsan autosave file of changes, which includes all the changes youmade to the open file since the last automatic save. The amountof new information that the autosave file contains depends on howfrequently Acrobat saves the autosavefile. If you set the autosave interval to 15 minutes, you couldlose the last 14 minutes of your work if a problem occurs. Frequentautomatic saving prevents loss of data, and is especially usefulif you make extensive changes to a document, such as by adding comments.
You can apply autosave changes to the original files when yourestart Acrobat. When you close, savemanually, or revert to the last-saved version of a file, the autosavefile is deleted.
Note:
If you use assistive technology, such as a screen reader,you may want to disable the Autosave feature so that you don't loseyour place when the file is reloaded.
The Autosave feature won't work in the following cases:
A document that has its security changed. You must save the document to re-enable automatic saving of document changes.
A document created using the Web Capture feature or extracted from a larger PDF (Tools > Organize Pages > Extract). You must save the document to enable automatic saving of changes.
A document displayed in a web browser or incorporated into a container document that supports Object Linking and Embedding (OLE). This document appears outside the default file system and cannot support automatic saving.
Toprevent lost changes after an unexpected interruption, enable theAutosave feature, which is the default setting.
- In the Preferences dialog box underCategories, select Documents.
- Select Automatically Save Document Changes To TemporaryFile Every xx Minutes (1-99), and specify the number of minutes.
Recover lost changes after an unexpectedshutdown
- Start Acrobat oropen the file you were working on last.
- When prompted, click Yes to open the autosave file orfiles. If multiple files were open, Acrobat opensall of the files for you.
- Save the file or files with the same names as the filesyou were originally working on.
How to edit in audacity. You can sometimes reduce the file size of a PDF simply by using the File > Reduce File Size, or File > Save As Other command. Reducing the size of PDFs improves their performance—particularly when they're being opened on the web—without altering their appearance.
The Reduce File Size command resamples and recompresses images, removes embedded Base-14 fonts, and subset-embeds fonts that were left embedded. It also compresses document structure and cleans up elements such as invalid bookmarks. If the file size is already as small as possible, this command has no effect.
How Do You Save As A Pdf
Note:
Reducing the file size of a digitally signed document removes the signature.
Note:
Adobe is testing the simplified optimize PDF experience with two different names - Reduce File Size or Compress PDF. Therefore, after updating to the latest release, you see either the Compress PDF option or the Reduce File Size option. From the functionality perspective, both the options are the same.
Choose the location to save the file and click Save. Acrobat DC displays a message showing the successful reduction in PDF size.
Note:
How Do You Save As A Pdf With Pages
To reduce file size of multiple files, see Reduce file size of multiple PDFs.
- Open a single PDF, or select one or more PDFsin a PDF Portfolio.
If you're certain that all your users use Acrobat or Adobe Acrobat Reader, limiting compatibility to the latest version can further reduce file size.
(Optional) To apply the same settings to multiple files, click Apply To Multiple, and add the files. Click OK, then in the Output Options dialog box, specify your folder and filename preferences.
Note:
The Apply To Multiple button is not available in PDF Portfolios.
To control changes and quality trade-offs, use PDF Optimizer in Acrobat Pro, which makes more options available.