How to save an Excel worksheet or workbook as a PDF

To save an Excel file as a PDF, open File → Save As in desktop Excel for Windows and choose PDF as the file type. Use Options to select what to include before saving. The PDF is divided into pages based on the worksheet’s print settings.

Check the print layout first

Save the original workbook and press Ctrl+P to open Print Preview. Check the paper size, orientation and margins. If the last columns spill onto another page, try landscape orientation. Fitting the width to one page while leaving the height automatic can help keep the text readable. In Page Layout → Scale to Fit, set Width to 1 page and Height to Automatic.

Choose PDF and select what to include

  1. Press F12 or use File → Save As → Browse, then choose PDF. Use Save a Copy if that is what the File menu shows. Choose a folder and file name and check before replacing an existing PDF.
  2. Open Options and choose Selection, Active sheet(s), or Entire workbook. To share only B2:G20, select those cells before opening the save dialog and choose Selection. If you want a single sheet, make sure you have not selected other sheet tabs as well.
  3. Confirm and save. Choose Standard when print quality matters or Minimum size when a smaller file matters more. File → Export → Create PDF/XPS offers another route to the same scope and output options.

Microsoft’s guide to saving PDFs from Office desktop apps

Open and inspect the saved PDF

Check the first and last pages, page count, last column of tables and any charts. Keep the workbook for later changes to cells and formulas. Before sharing, verify the content that actually made it into the PDF and test any links the reader needs.

Fix blank pages or tiny text

An oversized print area or extra selected sheets can add pages you did not intend to send. Check the selected sheets and print area, or export only the required cells. If fitting everything onto one page makes the text hard to read, fit the width only and review the result in Print Preview.

Print only selected cells in Excel