The quickest way to save Excel as PDF

Open your Excel file, then go to File > Save As. In the dialog box that appears, click the dropdown next to "Save as type" and select PDF. Choose where you want to save the file, name it, and click Save. Excel converts the spreadsheet to PDF format in seconds.

This method works in Excel 2010 and newer on both Windows and Mac. The PDF will look exactly as it appears on your screen — all formatting, colors, and cell borders stay the same. If you have multiple sheets in your workbook, Excel asks whether you want to save the active sheet only or the entire workbook.

The PDF file is now a static document. Nobody can edit the data or formulas inside it without converting it back to Excel or another editable format. This makes PDF useful when you want to share a spreadsheet but prevent accidental changes.

Key Takeaways

  • Use File > Save As, select PDF from the file type dropdown, and click Save to convert any Excel spreadsheet in under a minute.
  • Excel asks whether to save only the current sheet or all sheets in the workbook — choose based on what you need to share.
  • The PDF preserves all formatting, colors, and layout exactly as they appear in Excel.
  • PDF files cannot be edited without special tools, so use this format when you want to lock the data in place before sending it to others.
  • If your spreadsheet is wider than a standard page, Excel automatically shrinks it to fit — check the preview before saving to confirm the result looks right.

Choosing between saving one sheet or the whole workbook

When you click Save in the PDF dialog, Excel shows a second prompt asking whether you want to save the active sheet or the entire workbook. The active sheet is whichever tab you are currently viewing. If you only need one sheet in the PDF, select Active sheet — this keeps the file smaller and focused.

Choose Entire Workbook if you want all sheets included in a single PDF file. Excel creates a multi-page document with each sheet on its own pages. This is useful when you are sharing a complete project or report that spans multiple tabs, but the file size will be larger.

You can always save the same Excel file as PDF multiple times with different choices. Save it once with just the summary sheet, then save it again with all sheets if you need both versions.

What happens to wide spreadsheets when you convert to PDF

Excel spreadsheets are often wider than a standard printed page. When you save to PDF, Excel automatically shrinks the content to fit on the page width. This means your columns become narrower in the PDF, and text inside cells may become harder to read.

Before you save, check the print preview to see how Excel will scale your spreadsheet. Go to File > Print and look at the preview on the right side. If the text is too small, you have two options: adjust the zoom level in the print settings, or rotate the page to landscape orientation by going to Page Layout > Orientation > Landscape.

Another approach is to delete columns you do not need before saving, or hide them temporarily. Select the column header, right-click, and choose Hide. The hidden columns will not appear in the PDF, but they remain in your original Excel file.

Saving specific rows or columns as PDF

If you only want part of your spreadsheet in the PDF, select the range of cells you need before opening Save As. Click and drag to highlight the cells, or click the first cell, hold Shift, and click the last cell in the range you want.

Then go to File > Save As, select PDF, and look for an option that says Selection or Print selection. Not all versions of Excel show this option — if you do not see it, use the print preview method instead. Go to File > Print, set the print range to your selection, and use the Print to File option to save as PDF.

This approach is helpful when you have a large spreadsheet but only need to share one table or a few rows with someone else.

Controlling page breaks and margins in the PDF

Excel automatically decides where to break pages when converting to PDF. If your spreadsheet spans multiple pages, Excel breaks it based on the page size and margins. You can control where these breaks happen by inserting manual page breaks before you save.

Click the row or column where you want the break to start, then go to Insert > Page Break. Excel adds a line showing where the page will split. When you save to PDF, the document respects these breaks. To remove a page break, right-click the row or column and select Delete Page Break.

You can also adjust margins to fit more content on each page. Go to Page Layout > Margins and choose a preset size like Narrow, or click Custom Margins to set exact measurements. Smaller margins fit more data per page but may make text harder to read.

File size and quality when saving as PDF

Excel PDFs are usually small files because spreadsheets contain mostly text and straightforward formatting. A typical spreadsheet with hundreds of rows converts to a PDF under 1 megabyte. If your spreadsheet includes images or charts, the file size grows, but rarely exceeds a few megabytes.

The quality of the PDF depends on your screen resolution and the fonts installed on your computer. Excel embeds fonts in the PDF so the document looks the same on any device. If you use uncommon fonts, the PDF may substitute a similar one on computers that do not have that font installed.

If you need to reduce file size, delete unnecessary images or charts before saving, or use the Minimum size option if your version of Excel offers it in the Save As dialog.

Frequently Asked Questions

Can I edit a PDF after I save it from Excel?

Not without special software. A PDF created from Excel is a static image of the spreadsheet — you cannot edit the numbers or formulas inside it the way you can in Excel. You would need to convert the PDF back to Excel format or use a PDF editor, which may not preserve the original layout. If you need to make changes, edit the Excel file first, then save it as PDF again.

What if my Excel file has formulas — do they show up in the PDF?

The PDF shows only the results of the formulas, not the formulas themselves. If a cell contains a formula that calculates 50, the PDF displays 50. The formula bar and all behind-the-scenes calculations are hidden. This is actually useful when you want to share results without revealing how you calculated them.

Can I save a chart or graph from Excel as a PDF?

Yes. Select the chart by clicking on it, then go to File > Save As and choose PDF. Excel saves only the chart, not the underlying data. This works for any type of chart — bar, line, pie, or scatter plots all convert cleanly to PDF format.

Does the PDF include hidden rows or columns?

No. When you hide rows or columns in Excel and then save as PDF, the hidden content does not appear in the PDF file. This is useful if you want to share a spreadsheet but exclude certain data. The hidden rows and columns remain in your original Excel file — hiding them does not delete them.

What is the difference between saving as PDF and printing to PDF?

Saving directly as PDF through File > Save As is faster and gives you more control over what gets included. Printing to PDF goes through the print dialog, which means you can set specific page ranges and print settings first. Both methods produce a PDF, but Save As is simpler for most spreadsheets.