✦Template Printable Ideas Insights

How to Save an Excel File as PDF

By

In today's digital age, Excel files are ubiquitous in businesses, education, and personal finance. While Excel has become a staple for data management and analysis, there are times when you need to share or preserve your work in a format that's universally accessible and easy to view. This is where PDF comes in. Here, we'll guide you through the process of saving an Excel file as a PDF, ensuring your data stays intact and is easily readable.

Before we dive into the steps, let's understand why you might want to convert your Excel file to PDF. PDFs maintain their formatting regardless of the device or platform being used to view them. They're also tougher to edit, making them a great choice when you want to share sensitive data or ensure readers can't change your work.

Saving an Excel File as a PDF on Windows

Microsoft Excel has a built-in feature to save your work as a PDF. Here's how to do it:

Convert Excel sheet to PDF
Convert Excel sheet to PDF
How to teleport PDF data into Excel. 🤯
How to teleport PDF data into Excel. 🤯
How to change a PDF to an Excel file
How to change a PDF to an Excel file

1. Open your Excel file and ensure it's the version you want to convert. Make any necessary edits or adjustments.

Using the 'Save As' Option

2. Click the 'File' tab in the ribbon, then select 'Save As'.

Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
How to Convert Excel to PDF & PDF to Excel
How to Convert Excel to PDF & PDF to Excel
How to Convert PDF to Excel using Excel Power Query
How to Convert PDF to Excel using Excel Power Query

3. In the 'Save as type' drop-down list, choose 'PDF (*.pdf)', then click 'Save'. Your file will be converted and saved as a PDF in the same location as your original Excel file.

Using the 'Print' Option

4. If you want more control over the appearance of your PDF, you can use the 'Print' option. Click the 'File' tab, then 'Print'.

5. In the 'Print' window, click the 'PDF' button, then choose 'Save as PDF'. This will open the 'Save As' window, where you can select the location to save your PDF and customize settings like page size, margins, and other properties.

Copy Data From One Sheet to Another in Excel
Copy Data From One Sheet to Another in Excel
How to Import PDF data into Excel. #excel
How to Import PDF data into Excel. #excel
How to separate information on Excel
How to separate information on Excel
6 Ways To Create and Import a PDF in Excel
6 Ways To Create and Import a PDF in Excel
How to Record a Macro in Excel - A Step by Step Guide
How to Record a Macro in Excel - A Step by Step Guide
How to Copy from Excel to Word Without Losing Formatting (4 Easy Ways)
How to Copy from Excel to Word Without Losing Formatting (4 Easy Ways)

Saving an Excel File as a PDF on Mac

The process is slightly different on a Mac, but it's just as easy.

1. Open your Excel file and ensure it's the version you want to convert.

Using the 'File' Menu

2. Click on the 'File' menu, then select 'Export' (or 'Export To' in older versions).

Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
receipts to excel with the text receipt in green and white on top of it, next to an image of a calculator
receipts to excel with the text receipt in green and white on top of it, next to an image of a calculator
Copy Only Visible Cells in Excel
Copy Only Visible Cells in Excel

3. Choose 'PDF' from the list of export formats, then click 'Export'.

Using the 'Print Dialog Box'

4. Alternatively, you can use the 'Print' function for more customization. Click on 'File', then 'Print'.

5. In the 'Print' window, click on 'PDF' at the bottom of the window, then choose 'Save as PDF'. This will open the 'Save As' window, where you can adjust settings and save your file.

Additional Tips for Saving Excel Files as PDFs

If your Excel file contains sensitive data, be sure to password-protect your PDF.

To do this, right-click on the PDF file after saving, select 'Properties', then 'Advanced'. Here, you can set a password for opening the document, as well as for changing the permissions.

Keeping Formulas Visible

By default, Excel hides formulas when converting to PDF. If you want to keep formulas visible, you'll need to adjust the Print Settings.

Here's how: Go to 'Page Layout' in the ribbon, then click on 'Print Area'. Select the cells you want to include, then under 'Print', click 'Print Area'. This will ensure only the selected cells print, keeping formulas visible.

Combining Multiple Excel Sheets into One PDF

If your Excel file contains multiple sheets, you can merge them into a single PDF. In the 'Save As' or 'Print' dialog box, under 'PDF Options', select 'Multiple pages per sheet' and adjust the number of pages per sheet to match the number of sheets in your workbook.

And there you have it! You now know how to save an Excel file as a PDF, no matter which platform you're using. This simple process can help you share your work more effectively, preserving data integrity and enhancing readability.