Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft Excel > How to Save Excel as PDF? 5 Useful Ways

How to Save Excel as PDF? 5 Useful Ways

(Note: This guide on how to save Excel as PDF is suitable for all Excel versions including Office 365)

Imagine a scenario where you have to send your Excel workbook to other recipients within or outside your organization. In some cases, the end user might not be able to view the workbook. In other cases, your workbook might appear with different formatting when the file is opened with different software or operating system. 

In such cases, you can convert your Excel workbook into a PDF file and save them. In this article, I will tell you how to convert and save Excel as a PDF file.

You’ll Learn:

  • How to Convert and Save Excel as PDF?
    • Using the Print Option
    • Using the Save As Option
    • Using the Export Option
    • Using the Quick Access Toolbar
    • Using Online Converters

Watch our video on how to save an Excel file as a PDF

Related Reads:

How to Convert Excel to Word? 2 Easy Methods

How to Add Page Numbers in Excel? 2 Easy with Options

How to Hide Formula Bar in Excel (and Show)? 3 Easy Ways

How to Convert and Save Excel as PDF?

You can easily convert Excel into a PDF file using Excel or you can use any third-party online converters. Let us now see how to convert and save your Excel workbook in detail. 

Using the Print Option

The File menu in Excel has a variety of ways to convert a workbook to a PDF. One of them is by using the Print option. This is one way to convert and save them. 

  • To convert your Excel workbook to PDF, navigate to File.
  • Click on Print in the main menu headers.
  • From the Printer drop-down in the Print window, select Microsoft Print to PDF.
Save Excel as PDF using the Print option
Save Excel as PDF using the Print option

This way of converting an Excel file offers you a variety of customizations and modifications that only apply to the saved PDF and not to the original Excel file.

From the options, you can choose to convert only the active sheet or other worksheets. Additionally, you can also adjust the margin and scaling of the Excel sheet. You can also see the preview of your settings in the preview pane to the right. 

  • Choose the customization which suits your purpose and click on Print.
  • This opens a dialog box asking you to select the location and name of the file. Click on Save.
Click on Save
Click on Save
  • This saves the Excel file as a PDF. 

Now, you can navigate to the saved location to view the PDF file or share them with your desired recipients.

The saved PDF File
The saved PDF File

Note: One additional advantage when using this method is that you can convert and save Excel as PDF without actually having to save the workbook. 

Using the Save As Option

Another way to save Excel as PDF is by using the Save As option.

  • After creating the Excel worksheet using necessary data, navigate to File.
  • Click on Save As. This shows the Save As pane towards the right. 
  • Navigate to the location you want to save the file and rename the file.
  • In the file format dropdown below the name text box, click on it, and select *.pdf.
How to save Excel as PDF using Save As option
How to save Excel as PDF using Save As option
  • Now, click Save. This saves the Excel file as a PDF in your desired location.

Note: When you use this option, the Excel files are converted into PDF with the default formatting assigned to the pages/print settings. 

Since there is no way to preview the layout and customization of the converted file, it is better to check the page layout formatting and change them manually if needed. 

To change them, navigate to the Page Layout main menu. Under the Page Setup section, customize the worksheet to your desired specifications based on margin, orientation, print area, and other personalization options.

Change the Page Layout settings
Change the Page Layout settings

For additional settings, click on the extend button which opens a Page Setup dialog box. You can change the orientation of the page, set margins, number the page, and set the gridlines to appear in your converted PDF file.

Additional Page Setup options
Additional Page Setup options

Also Read:

How to Hide Formula Bar in Excel (and Show)? 3 Easy Ways

How to Find and Replace in Excel? A Step-by-Step Guide

How to Randomize a List in Excel? 2 Different Methods

Using the Export Option

Another way to convert and save Excel as PDF is by using the Export option. The export option too, like others can be found in the File main menu.

  • To convert an Excel to PDF, go to File. 
  • Click on Export. In the Export pane, click on Create PDF/XPS Document. 
How to save Excel as PDF using Export option
How to save Excel as PDF using Export option
  • This opens a new dialog box. Choose the location and rename the file. Make sure the Save as type: is PDF. You can choose to open the file after publishing and the quality of the PDF file you need.
Save the File
Save the File
  • Click on Publish. This exports the selected Excel sheet into a PDF file.

Using the Quick Access Toolbar

Converting an Excel file to PDF is a very common instance that is used for various purposes, ranging from institutional to corporate levels. If you regularly need to convert and save Excel as PDF, there is an even easier way compared to the above options. By using the Quick Access Toolbar, you can straightaway add the option that helps you convert Excel as PDF with the click of a button.

  • First, enable your Quick Access Toolbar by clicking the Ribbon Display Options and selecting the Show Quick Access Toolbar. 
  • Now, click on the Customize drop-down and select More Commands.
Select More Commands from Quick Access Toolbar
Select More Commands from Quick Access Toolbar
  • This opens the Excel Options dialog box. From the Choose commands from: drop-down, select All Commands. Scroll down and select Publish as PDF or XPS.
  • Click on Add. You can see the buttons added to the Quick Access toolbar in the right pane. 
  • Click OK.
Add the Publish as PDF option
Add the Publish as PDF option
  • This adds the selected button to the Quick Access Toolbar. 
Click on the Publish button in the Quick Access Toolbar
Click on the Publish button in the Quick Access Toolbar

Instead of navigating to the File menu and exporting every time you want to convert a file, just click on the PDF button in the Quick Access Toolbar to save the Excel file as a PDF.

Using Online Converters

In case your operating system does not have the right version of Excel to open the file, you can use third-party websites to convert them into PDFs easily. All you need is an internet connection.

The process to convert and save Excel as PDF using online converters is straightforward. 

  • Just open their website and navigate to the Convert Excel to PDF section. 
  • Drag and drop the file or open the file location and select the Excel file.
  • Click on Convert. 
  • This saves and downloads the PDF file to your local drive.

Some of the online converters to help convert your Excel to PDF are:

  • Adobe 
  • Freepdfconvert
  • Smallpdf
  • pdf2go
  • ilovepdf
  • pdf4me

Suggested Reads:

How to Use Excel Split Screen? 3 Simple Ways

How to Rotate Text in Excel? 3 Effective Ways

How to Copy Only Visible Cells in Excel? 3 Easy Ways

Frequently Asked Questions

How to save Excel as PDF with the same formatting?

When you use the Save As option or Export option from the File main menu, Microsoft Excel converts the file into PDF with the same formatting as the original Excel sheet. This includes the margins, orientations, and layouts.

How to save the Excel File as a PDF with gridlines?

When you convert an Excel file to PDF, by default they appear without any gridlines. To enable the gridlines, click on the Page Setup option in the Print main menu or the Page Layout main menu. In the Page Setup dialog box, under the Sheets tab, check the checkbox for Gridlines.

How to save the Excel file converted to PDF in landscape orientation?

In the Page Layouts main menu, under the Page Setup section, click on the dropdown from Orientation and select Landscape. By default, your orientation will be Portrait. But, when it comes to an Excel file, choosing your orientation as landscape houses more cells and gives an overall aesthetic look to the pages.

Closing Thoughts

In this article, we saw how to convert and save Excel as PDF in 5 easy ways. You can use the print option, the save as option, or the export option to help you convert the Excel sheet from the file menu. 

If you need to convert them frequently, you can add the export option to Quick Access Toolbar. And, you can also use online converters to help you convert an Excel file to PDF. Choose the method that suits your purpose the best.

Please visit our free resources center for more high-quality Excel guides. 

Ready to take the next step and hone your skills in Excel?

Simon Sez IT has been teaching Excel for over ten years. For a low, monthly fee you can get access to 140+ IT training courses. Click here for advanced Excel courses with in-depth training modules.

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Similar Posts

How to Setup a Chart of Accounts in Quickbooks Pro 2012

How to Insert a Placeholder in Word? 2 Different Types

How to Add Line Numbers in Word? A Step-by-Step Guide

Formatting Pictures in PowerPoint 2016

How to Insert Multiple Rows in Excel? The 4 Best Methods

The 3 Essential Scrum Artifacts You Must Know in 2022

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)