The result is the same as in the previous method: A new PDF file is created from the Excel worksheets. Select the PDF (*.pdf) file type and click Save.In the Ribbon, select File > Save Copy ( Save As).Hold down the CTRL key and click on the tabs of each sheet you want to save (for example, Sheet 1 and Sheet 2). Select all the worksheets you want to save as PDF.Each sheet starts on a new page in the PDF file.Īnother way to achieve the same result is to change the file type when saving. In the Search window, enter (1) a name and (2) a destination for the file, and then (3) click Publish.īy default, the new PDF file has the same name and destination as the original Excel file.Īs a result, a PDF file is saved with all the worksheets (Sheet 1 and Sheet 2) selected in the Excel file.Select Create PDF/XPS Document and click Create PDF/XPS.Hold down the CTRL key and click on the tabs of each sheet you want to save (Sheet 1 and Sheet 2). Suppose you have the following Excel file with three sheets (Sheet 1, Sheet 2, and Sheet 3) with the same data. However, you can select multiple sheets to save as PDF. Type a name for the disc into the “Disc Title” field, select “With a CD/DVD Player” and click “Next.”ĭouble-click the ZIP file on your system once it finishes downloading.Ĭlick the “Organize” menu and click “Select All” to select all files inside the ZIP file.ĭrag and drop the files from the ZIP file onto the disc folder window.Ĭlick the “Burn To Disc” button and click “Next” to start burning the CD.This tutorial will show how to save multiple sheets as PDF in Excel and Google Sheets.īy default, when you save an Excel file as a PDF, only the first worksheet is saved. Insert a blank CD into your disc drive and click “Burn FIles to Disc Using Windows Explorer” in the AutoPlay pop-up Window that appears. Use the drop-down menus to select the file type you want to download the document type as.Ĭlick the “Download” button to download the selected files in a ZIP file. Click the “More” menu at the top of the file list and select “Download.”Ĭlick the “All Items” tab if you want to download all the files in your Google Docs account, or leave the “Selected Items” tab enabled if you want to download only the selected items.
0 kommentar(er)
