If you want to change the save location or access other advanced PDF file options then you can click on the More options link just below the file type selection. Show This will open up a the Save As menu and you can navigate to a new save location as well as access the advanced Options for PDF files. Export as PDFI never really noticed this, but there’s an Export option in the File menu. It turns out, you can use this to export your file as a PDF! To Export your Excel file as a PDF.
This will open up the Publish as PDF or XPS menu, which is exactly like the Save As menu and you can choose the location to publish as well as access advanced PDF Options. Publish as PDF Quick Access Toolbar CommandYou can add the publish as PDF command to the quick access toolbar to avoid the step of going to the File tab. Right click anywhere on the quick access toolbar and choose Customize Quick Access Toolbar from the menu. This will open up the Excel Options menu and you can add the Publish as PDF or XPS command from here.
You can now use this command from the Quick Access Toolbar to publish your Excel file as a PDF document. Email as PDF Attachment Quick Access Toolbar CommandThis is one of my favourites on the list as it does two things for you. It will convert your Excel file to PDF and then create a new email message with the PDF attached. All without any code needed! This is super useful if you need to email your files as PDF’s. Again, right click on the quick access toolbar and choose Customize Quick Access Toolbar from the menu. In the Excel Options menu and you can add the E-mail as PDF Attachment command.
This will place the E-mail as PDF Attachment command into your quick access toolbar. When you press this command, it will automatically create a new Outlook email with a subject line of the Excel workbook name. The PDF of the converted Excel file will also be added as an attachment. This will save you many clicks. Convert File to PDF in Power AutomateAll the previous options to convert your Excel file to PDF are great and they will save you valuable clicks, but they are not automated. There is a Power Automate action that can convert files to PDF. This means you can convert PDF files as part of some automated process. You could use this to do things like automatically create and send PDF invoices by email at the end of the month. The file you want to convert will need to be saved in OneDrive. You’re going to need to add two actions to your automation. The first to convert the file and the second to create the file.
ConclusionsConverting your Excel files to PDF is a common task. Luckily it’s pretty easy and there are a few options available. There is also a Power Automate option for converting Excel to PDF which means you can create automated processes that convert your files to PDF. The Acrobat online Excel to PDF converter tool allows you to convert Microsoft Excel files entirely online, without needing to download any software onto your local device. Adobe Acrobat online PDF tools also offer a PDF editor, compress PDF functionality, the ability to convert files like JPG and PowerPoint to and from PDF, and other ways to help you optimize your PDF workflow. By default if you save from Excel to pdf, it just saves the worksheet you currently have selected. However, you can save the whole workbook as one pdf. If using Microsoft Excel 2007:
If using Microsoft Excel 2010:
If using Microsoft Excel 2013 or 2016:
Learn more about our Microsoft Excel training London, Surrey, Middlesex UK, or our Microsoft Excel training Dorset, Hampshire, Wiltshire, UK or our Microsoft Excel training Sydney, Australia. How do I save an entire Excel workbook as PDF without cutting it off?Convert Excel files to PDF without losing formatting.. Click Select A File and drag and drop your Excel sheet, or select the file and upload.. Watch as Acrobat online services convert your Excel sheet to PDF automatically.. Download the converted file as a PDF.. |