Save Multiple Sheets as PDF in Excel & Google Sheets

In the Print window, (1) under Export, select Workbook. (2) Tick Sheet 1 and Sheet 2 for the selection, and (3) click Apply. Finally (4) click Export. SeeallHow-ToArticles ThistutorialwillshowhowtosavemultiplesheetsasPDFinExcelandGoogleSheets.     ExportMultipleSheetsasPDF Bydefault,whenyousaveanExcelfileasaPDF,onlythefirstworksheetissaved.However,youcanselectmultiplesheetstosaveasPDF.SupposeyouhavethefollowingExcelfilewiththreesheets(Sheet1,Sheet2,andSheet3)withthesamedata.     SelectalltheworksheetsyouwanttosaveasPDF.HolddowntheCTRLkeyandclickonthetabsofeachsheetyouwanttosave(Sheet1andSheet2).     IntheRibbon,selectFile >Export     SelectCreatePDF/XPSDocumentandclickCreatePDF/XPS.     IntheSearchwindow,enter(1)anameand(2)adestinationforthefile,andthen(3)clickPublish. Bydefault,thenewPDFfilehasthesamenameanddestinationastheoriginalExcelfile.     Asaresult,aPDFfileissavedwithalltheworksheets(Sheet1andSheet2)selectedintheExcelfile.EachsheetstartsonanewpageinthePDFfile.     SaveaPDFCopy Anotherwaytoachievethesameresultistochangethefiletypewhensaving. SelectalltheworksheetsyouwanttosaveasPDF.HolddowntheCTRLkeyandclickonthetabsofeachsheetyouwanttosave(forexample,Sheet1andSheet2).     IntheRibbon,selectFile >SaveCopy(SaveAs).     SelectthePDF(*.pdf)filetypeandclickSave.     Theresultisthesameasinthepreviousmethod:AnewPDFfileiscreatedfromtheExcelworksheets. SaveMultipleGoogleSheetsasPDF LikeanExcelworkbook,aGoogleSheetsfilecanalsobesavedasaPDF. GotoFile >Download >PDFDocument(.pdf)intheMenu.     InthePrintwindow,(1)underExport,selectWorkbook.(2)TickSheet1andSheet2fortheselection,and(3)clickApply.Finally(4)clickExport.     AnewPDFfilewiththeselectedworksheetsfromtheGoogleSheetsfileisnowsavedunderthesamenameintheDownloadsfolder. SeeallHow-ToArticles Postnavigation ←HowtoSavetotheOldExcelFormat(.xls)FromExcelHowtoConvertanExcelFiletoGoogleSheets→