1 How to Save Excel Files as PDF2 How to Use Excel to Export as PDF3 How to Add an Export to PDF Button to the Quick Access Toolbar4 How to Add the Email as PDF Attachment Button to the Quick Access Toolbar 5 How Convert an Excel File to a PDF with File Converter6 Extra: How to Convert a Word Document to PDF7 Extra: How to Lock Cells in Excel
How to convert Excel to PDF without losing formatting Before we start on the various methods to save Excel files as PDFs, it’s important to discuss how you can minimize the chances you’ll get a bad conversion. Converting .xls or .xlsx to PDF can cause problems with pages being cut off or misaligned. As a result, before you save to PDF, we recommend your margins, orientations, and size, as well as any headers of footers you’d like. You may also want to define your print area in the page layout tab and use page breaks to separate different tables. While you’re in the page layout tab, you should also change the width, height, and scale of your document to be suitable for printing. With those quick tips out of the way, let’s move on to how to convert Excel documents to PDF files and how you can modify Excel so you can do it faster in the future:
How to Save Excel Files as PDF
How to Use Excel to Export as PDF
How to Add an Export to PDF Button to the Quick Access Toolbar
How to Add the Email as PDF Attachment Button to the Quick Access Toolbar
How Convert an Excel File to a PDF with File Converter
Extra: How to Convert a Word Document to PDF
Now that you know how to convert an Excel file to PDF, you may be wondering how to do the same for Word. Thankfully, we already have a save Word document as a PDF tutorial up for you to follow. Clicking the “Save” button will then prompt the user to save the Excel file as a PDF.
Extra: How to Lock Cells in Excel
Alternatively, if you’d like to share your Excel file with others without making it a PDF, you can lock its cells so users can’t edit it. Here’s our existing guide on how to lock cells in Excel.