How do I print multiple Excel spreadsheets to a single PDF?
Solutions:
- Open the Excel workbook.
- On the PDF-XChange tab, click the Edit Settings button.
- Click Excel Options.
- Click Entire Workbook or Sheets in a Range.
- Click OK.
- Click Convert to PDF.
- Choose the location and name of the file to save, and then click Save.
Table of Contents
How do I save multiple worksheets as a PDF?
If you have multiple worksheets and want to save them all to the same PDF file, click Options in the Save As dialog box. The Options dialog box will appear. Select Entire Workbook, and then click OK.
How do I select all worksheets at once?
Right-click on a sheet tab, and then click the Select All Sheets option. TIP: After choosing multiple sheets, a [Grupo] in the title bar at the top of the worksheet. To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet.
Why does Excel print to multiple PDF files?
This happens because one (or more) sheets in your workbook have a different dpi setting for printing. Because of this, Excel assumes that each individual sheet needs to be sent for printing separately, so it will send it the same way to the PDF printer, which will ask you to create a PDF from each sheet.
How does it fit on a page of a PDF?
Acrobat can resize PDF pages to fit the selected paper size… Automatically scale to fit paper
- Choose File > Print.
- From the Page Scale pop-up menu, select one of the following options: Fit to Printable Area Scales small pages up and large pages down to fit the paper.
- Click OK or Print.
How do I jump to a specific sheet in Excel?
Jump to a specific worksheet
- Press F5. Excel displays the Go To dialog box.
- In the Reference box, enter Sheet83! A1. (Replace “Sheet83” with the name of the worksheet you want to jump to.)
- Click OK.