How to Convert Excel to PDF. Converting an Excel file to a PDF will allow anyone to open it, even if they don’t have Office installed. It can also make for easier printing and distribution of your Excel spreadsheet. Excel allows you to create PDF versions from directly inside the program, but you can also use online conversion services if you need to convert a file but don’print to pdf excel 2010 have Excel installed.
If there’s only a certain part of the spreadsheet that you want to turn into a PDF, select it now. Otherwise, move on to the next step. Note that a PDF cannot be easily converted back into an Excel sheet, but this method will preserve your original copy. If you’re using an older version of Excel, click the “File” menu. If you are using Excel 2010 or earlier, select “Save As” instead. If you are using Excel 2010 or earlier, select “PDF” from the “Save as type” drop-down menu in the “Save As” window instead.
This will allow you to adjust the settings for the PDF file you are about to create. Select what gets included in the PDF. In the Options window, you can select the range of pages included, whether the PDF includes your selection, the entire workbook, or just the active sheet, and if it will include the original document’s properties. Most people can stick with “Standard” unless the spreadsheet is very large.
Name and save the file. By default, the PDF file will open after it is created so that you can review 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 Excel and then create a new PDF. Excel 2011 will only save all of your sheets as one PDF file if the headers and footers for each sheet are identical. 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 sheets in your workbook. Click the tab for the first sheet, hold down Shift, and click the tab for the last sheet to select all of them. Click the File menu and select “Save As”. Browse to the location that you want to save the file at, and give it a name. Click the Format pull-down menu and select “PDF”. This will save a copy of the spreadsheet as a PDF file. At the bottom of the window, you can choose between “Workbook”, “Sheet”, or “Selection”.
If the headers don’t match, a separate file will be created for each sheet. Note that this will occasionally happen even if the headers and footers all match exactly. If the conversion process resulted in multiple PDF files, you can quickly join them together using Finder. Open the folder that contains the PDF files and select all of the files that you want to merge. Combine Files into Single PDF”.
Open the PDF file by double-clicking it. This will open it in Preview, allowing you to review it before you send it off. How can I get full xlsx worksheets to convert to PDF? In Microsoft Office Suite 2016. There’s an option to export under File. From there, you can choose the Export to PDF option.
How do I make it digitally singable? What is wrong if I convert an Excel document to PDF and the column that has hyperlinks is now off, and the file opens the wrong hyperlinks? What do you need to know? We’ll do our best to find the answer. Change the Default File Extension from .
Thanks to all authors for creating a page that has been read 833,271 times. Is this article up to date? Free PDF printer you can use to create PDF from any printable document. Download this free PDF creator right now and use it to print to PDF. PDF stands for Portable Document Format and it was created by Adobe to ease document exchange.