Note that PDF conversions cannot be easily reverted back into an Excel sheet, but this method will preserve your original copy.

If you selected an area of your spreadsheet to save as a PDF, choose Selection under “Publish what. " This ensures that only that selected area is saved as a PDF. If you’d rather save the entire visible worksheet as a PDF, choose Active sheet(s) instead. If you want to choose specific pages from the workbook to save as a PDF, use the “Page(s)” drop-down menus to define the first and last pages. Click OK to continue.

If you want to change the location to which you’re saving the file, you can navigate to that folder in the window now.

It’s not really possible to edit the PDF now, so if you need to make changes you’ll want to make them in the Excel document and then create a new PDF.

If you’re not already signed in to your Google account, sign in when prompted.

The PDF will save in the same orientation as the spreadsheet (usually landscape mode). If you’d rather it be in portrait (vertical) mode, select Portrait under “Page orientation. " Change the scale (the size/fit on the page) and margin size if necessary. Click Formatting to choose whether to display gridlines and/or notes, adjust the page order, and change the alignment. To add headers and footers to the tops and bottoms of pages, click Headers & footers, and then check the boxes to choose which information to display. If your spreadsheet contains a lot of data and cuts off in odd places, click SET CUSTOM PAGE BREAKS in the right panel. Here, you can drag the blue lines to adjust where each page begins and ends. Click CONFIRM BREAKS at the top-right to save your changes.

If the download doesn’t begin automatically, choose a location to which you’ll save the PDF, and then click Save to download it.

Select all of the worksheets in your entire workbook. To do this, click the tab for the first sheet at the bottom of excel, hold down the Shift key, and then click the last sheet’s tab to select all. Click the Layout tab and then click Header & Footer. Click the Customize Header. . . and Customize Footer. . . buttons to edit the headers and footers for all of the sheets.

PDF conversions cannot be easily converted back into an Excel sheet, but this method will preserve your original copy.

If you want to save the PDF to a new folder, you can select that folder now.

Type a different name for the file.

The name of the current Excel file appears in the “Save As” field. You will need to enter a different name (even if it’s just slightly different) to avoid accidentally overwriting the spreadsheet file. [2] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source

If you want to save the PDF to a new folder, you can select that folder now.

Type a different name for the file.

The name of the current Excel file appears in the “Save As” field. You will need to enter a different name (even if it’s just slightly different) to avoid accidentally overwriting the spreadsheet file. [2] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source

If the headers don’t match on a multi-sheet file, a separate file will be created for each sheet.

Open the first PDF file by double-clicking its name in its folder. Click the View menu and select Thumbnails. [3] X Research source Click the last thumbnail to select it. This tells Preview to add the next PDF to the end of the current document. Click the Edit menu and select Insert > Page from File. Select the next PDF in the range and click Open. Repeat this process until you’ve added all PDFs. Click File and select Export as PDF.