How to Convert Excel to PDF

PDF download Download Article
Easy ways to convert Excel to PDF
PDF download Download Article

Converting an Excel file to a PDF makes it easier for people to open the and view the file on various platforms—even if they don't have Microsoft Office. PDFs are also easier to print and distribute than Excel spreadsheets. If you have Microsoft Excel , you can easily convert your spreadsheet to a PDF by saving or exporting it within the app. If you don't have Excel, you can use Google Sheets , a tool on Google Drive, to make the conversion for free.

Method 1
Method 1 of 3:

Using Excel for Windows

PDF download Download Article
  1. If there's only a certain part of the Excel file that you want to turn into PDF format, select it now. Otherwise, move on to the next step.
    • Note that PDF conversions cannot be easily reverted back into an Excel sheet, but this method will preserve your original copy.
    • If you're on a Mac, jump to our method on Excel for Mac .
  2. It's at the top-left corner.
    Advertisement
  3. This opens the Export panel.
  4. Look for the icon that looks like a sheet of paper wearing a belt.
  5. This will allow you to adjust the settings for the PDF file you are about to create.
    • 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.
  7. Above the "Options" button, you can select how you want to optimize the PDF. Most people can stick with "Standard" unless the spreadsheet is very large. "Minimum size" will reduce the size of a larger file to something more manageable.
    • If you want to change the location to which you're saving the file, you can navigate to that folder in the window now.
  8. This exports the selected information to a new PDF file with the name you've entered.
  9. By default, the PDF file will open automatically for your review. If it doesn't open by automatically, just double-click the name of the file in the folder to which you saved it..
    • 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.
    10. Advertisement
Method 2
Method 2 of 3:

Using Google Drive

PDF download Download Article
  1. Go to https://drive.google.com . If you need to convert an Excel spreadsheet to PDF but don't have Excel, don't fret—you can use tools built in to your Google account to do the conversion for free.
    • If you're not already signed in to your Google account, sign in when prompted.
  2. It's at the top-left corner of your Google Drive.
  3. This opens your computer's file browser.
  4. This uploads the spreadsheet to your Google Drive.
  5. This opens the spreadsheet in Google Sheets, Google's free spreadsheet editor.
  6. A list of download options will expand.
  7. This displays a preview of your PDF in the Google Sheets printing window.
  8. If the print preview doesn't look the way you want, use the right panel to make any changes you need before you continue.
    • 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.
  9. It's the blue button at the top-right. This prompts you to save your new PDF to your computer.
    • If the download doesn't begin automatically, choose a location to which you'll save the PDF, and then click Save to download it.
    10. Advertisement
Method 3
Method 3 of 3:

Using Excel for Mac

PDF download Download Article
  1. If you're using Excel 2011 and want to save multiple worksheets in a single PDF, each worksheet will need to have identical headers and footers. If they aren't, each sheet will be created as a separate PDF document, but you can also easily merge these afterwards.
    • 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.
  2. If there's only a certain part of the spreadsheet that you want to turn into a PDF, select it now. Otherwise, go to the next step.
    • PDF conversions cannot be easily converted back into an Excel sheet, but this method will preserve your original copy.
  3. You could also press Command + Shift + S to open the Save As option. [1]
    • 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]
  4. This menu may have a slightly different name depending on your version of Excel.
  5. At the bottom of the window, you can select Workbook (to convert the entire workbook), Sheet (to save only the active sheet as a PDF), or Selection (to save just the selected area as a PDF).
  6. You'll see a different option depending on your version of Excel.
    • If the headers don't match on a multi-sheet file, a separate file will be created for each sheet.
  7. If saving the Excel file as a PDF resulted in multiple PDF files, you can quickly join them together using Preview. Here's how:
    • Open the first PDF file by double-clicking its name in its folder.
    • Click the View menu and select Thumbnails . [3]
    • 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 .
    8. Advertisement

Expert Q&A

Search
Add New Question
  • Question
    How can I send a large Excel spreadsheet if I don't want to convert it to a PDF?
    Luigi Oppido
    Computer & Tech Specialist
    Luigi Oppido is the Owner and Operator of Pleasure Point Computers in Santa Cruz, California. Luigi has over 25 years of experience in general computer repair, data recovery, virus removal, and upgrades. He is also the host of the Computer Man Show! broadcasted on KSQD covering central California for over two years.
    Luigi Oppido
    Computer & Tech Specialist
    Expert Answer
    If you're sending a large Excel sheet, or if you want to send multiple files at once, you can compress the files as a zip folder. Then, the other person can unzip the folder and see all of the original files.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 0 Helpful 1
  • Question
    How do I get a one-page worksheet as a one-page PDF? It keeps trying to save as several pages.
    Community Answer
    In Excel go to Page Layout. In the Scale to Fit section, make sure Width and Height are both set to one page, then save the Excel document as a PDF.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 10 Helpful 46
  • Question
    How can I get full xlsx worksheets to convert to PDF?
    Community Answer
    In Microsoft Office Suite 2016. There's an option to export under File. From there, you can choose the Export to PDF option.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 13 Helpful 22
See more answers
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Read Video Transcript

      Tips

      • If you're sending a large Excel sheet to someone who also has Microsoft Excel, or if you need to send multiple files, try compressing the files instead of converting them to a PDF.
        Thanks
        Helpful 0 Not Helpful 0
      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      You Might Also Like

      How to
      Format an Excel Spreadsheet
      How to
      Convert a Microsoft Word Document to PDF
      Converting PDF to Word: The Best Options for PC & Mac
      3 Free & Easy Ways to Convert a Photo to PDF on iPhone
      How to
      Convert JPGs to PDFs on Any Device or Computer
      How to
      Convert Images to PDF
      6 Quick Ways to Scan Documents to PDF on Mobile or Desktop
      Create a PDF of a Webpage in Any Browser
      How to
      Copy Text from a PDF to a Microsoft Word Document
      How to
      Convert a File Into PDF
      3 Free Ways to Convert PDF to JPEG: PC, Mac, Android, & iPhone
      Easy Ways to Turn a PDF into an Image File
      How to
      Convert PDF to Solidworks
      How to
      Install a PDF Printer for Mac
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-us/office/save-a-file-in-office-for-mac-421a5172-9bc6-4ef0-b452-c0939bdce786#pdf&ID0EAACAAA=Newer_versions
      2. ↑ https://support.microsoft.com/en-us/office/save-or-convert-to-pdf-on-your-mac-aa183751-1f09-4b8b-88a4-099a0c7528da
      3. ↑ https://support.apple.com/en-us/HT202945

      About This Article

      Article Summary X

      1. Click the File menu and select Export .
      2. Click Create PDF/XPS .
      3. Click Options .
      4. Choose your options and select OK .
      5. Select an optimization level.
      6. Name the file and click Publish .

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 1,603,925 times.

      Reader Success Stories

      • Anonymous

        Feb 7, 2017

        "I tried to save as a PDF and did not realized that you can only save it if the version is 2010 or earlier, ..." more
      More reader stories Hide reader stories
      Share your story

      Is this article up to date?

      Advertisement