This brief tutorial describes 4 attainable methods to transform Excel recordsdata to PDF – by utilizing Excel’s Save As function, Adobe software program, on-line Excel to PDF converters and desktop instruments.
Changing an Excel worksheet to PDF is commonly vital if you wish to let different customers view your information however not edit it. You might also need to convert your Excel spreadsheet right into a neater PDF format for a media package, presentation and studies, or make a file that may be opened and skim by all customers, even when they do not have Microsoft Excel put in, for instance on a pill or telephone.
Lately PDF is arguably some of the common file codecs. In line with Google, there are over 153 mil PDF recordsdata on the internet, and solely 2.5 mil Excel recordsdata (.xls and .xlsx).
Additional on on this article, I’ll clarify a number of attainable methods of exporting Excel to PDF with detailed steps and screenshots:
- Convert Excel to PDF by Workplace means
- Export Excel to PDF utilizing Adobe software program
- Excel to PDF converters on-line
- Excel to PDF converters desktop
Save Excel paperwork as PDF recordsdata
Although the .pdf and .xls codecs have been round for fairly some time and each have all the time been common amongst customers, the likelihood to export Excel recordsdata on to PDF appeared in Excel 2007 solely. So, in case you have any trendy model put in, together with Excel 2016, 2013, 2010 or 2007, you may convert Excel to PDF within the following fast and easy manner.
Microsoft Excel permits exporting chosen ranges or tables in addition to saving one or a number of worksheets or the complete workbook as a PDF file.
- Open your Excel workbook and choose the ranges or sheets you need to convert to a PDF file.
- Should you want to export a desk, place the cursor to any cell inside a desk.
- To export a sure worksheet, merely make it energetic by clicking on this sheet’s tab.
- To transform a number of worksheets, choose all of them. To pick out adjoining sheets, click on the tab for the primary sheet, maintain down Shift and click on the tab for the final worksheet you need to choose. To pick out non-adjacent sheets, maintain down Ctrl whereas clicking the tabs of every sheet you need to save as PDF.
- If you wish to save the whole workbook as a single PDF file, skip this step : )
- In Excel 2013 and 1020, click on File > Save as. In Excel 2007, click on the Workplace button > Save as.
- Within the Save As dialog window, choose PDF (.*pdf) from the “Save as sort” drop-down listing.
If you wish to view the ensuing PDF file after saving, be sure that the Open file after publishing verify field is chosen.
Choose one of many following choices beneath Optimize for:
- If the ensuing PDF doc requires excessive print high quality, click on Normal (publishing on-line and printing).
- If the PDF file measurement is extra necessary than print high quality, then choose Minimal measurement (publishing on-line).
- Click on the Choices… button within the left-lower a part of the window (please see the screenshot above).
- The Choices dialog field will open and you choose one of many choices in accordance with your wants:
- Choice – this may export the presently chosen vary(s).
- Energetic sheet(s) – this may save both the present worksheet or all the chosen sheets in a single PDF file.
- Desk – this may export the energetic desk, i.e. a desk the place your mouse pointer resides in the meanwhile.
- Total workbook – self-explanatory : )
- Click on the OK button to shut the dialog and you might be achieved.
As you see, exporting Excel recordsdata to PDF utilizing the built-in Excel means is straightforward. In fact, Microsoft Excel supplies just a few fundamental settings, however with just a bit expertise, one can be taught to organize the supply recordsdata in such a manner that no additional changes can be wanted. Anyway, if you’re not pleased with the capabilities of Excel’s Save As function, let’s study Adobe’s choices.
Export Excel recordsdata to PDF utilizing Adobe instruments
Regrettably, Adobe is just not as beneficiant as Microsoft in terms of Excel to PDF conversions and doesn’t present any free means for this. Nevertheless, they do have this function integrated in paid instruments or subscriptions, which – one ought to give them their due – do the job rather well.
Adobe Reader X and earlier variations included the choice to put in the Adobe PDF Printer, which may very well be used to export Excel recordsdata to PDF. Nevertheless, this function is just not accessible within the newest model of Adobe Reader XI.
As an alternative, they launched the Create PDF tab that allows you to make PDF from .xls or .xlsx recordsdata in a single button click on, supplied that you’ve got a paid subscription.
Adobe Acrobat XI Professional
In case you are one in every of few fortunate customers of this highly effective suite, making a PDF file from an Excel worksheet is as simple as clicking PDF from File… beneath the Create toolbar.
Alternatively, Adobe Acrobat Professional helps you to create a PDF file straight from Excel in one of many following methods:
- Click on the Create PDF button on the Acrobat tab on the Excel ribbon.
- Change to the File tab and click on Save as Adobe PDF.
- Click on File > Print, choose Adobe PDF and configure the settings.
In case you are to get a 30-day trial model of Adobe Acrobat XI, you may obtain it right here. In case you are not keen to pay a $20 month-to-month payment for the Acrobat XI Professional subscription, let’s have a look at what free Excel to PDF converters have to supply.
Free Excel to PDF on-line converters
Fortunately for us, there are numerous free Excel to PDF Converters on-line that present numerous choices for changing Excel paperwork into PDF recordsdata. Under you will see the critiques of the 4 hottest on-line converters.
To check the talents of on-line PDF converters on completely different information sorts, I created the next two workbooks:
Check Workbook 1 – just a few tables in several codecs:
Check Workbook 2 – Microsoft’s Vacation Present Planner template:
Now that the preparations are full, let’s have a look at how the net Excel to PDF converters will address the problem.
Nitro Excel to PDF Converter
This on-line Excel to PDF converter accessible at bnok.vn can export Excel, Phrase and PowerPoint paperwork to PDF in addition to carry out the reverse conversions. Its interface is lucid and easy:
You select the unique and ensuing file codecs, then choose the file to transform, enter your electronic mail deal with and hit the Convert Now button. Superior, is not it? Sadly, I can’t say the identical concerning the outcomes : (
The format of practically all tables within the first take a look at workbook was severely distorted, the a part of the second desk was lower off and moved to a different web page:
The second take a look at workbook was transformed to PDF with a number of errors, as you may see within the screenshot beneath:
Nicely, I do not suppose I’ll use the Nitro conversion providers to export my Excel paperwork to PDF ever once more, so let’s transfer to the following one.
One other on-line Excel to PDF converter is obtainable at bnok.vn. Other than Excel sheets, this software can even convert Phrase paperwork, PowerPoint displays in addition to net pages and pictures to PDF.
As you see within the picture above, the interface can be very clear and hardly requires any explanations. You merely navigate between tabs to decide on a correct conversion sort, then browse for the unique file, choose the specified format and click on Convert.
When the conversion is completed, you may both obtain the ensuing PDF file to your laptop or put it aside to Google docs:
This Excel to PDF converter has a free variations and paid subscriptions. Listed here are the principle limitations of the free model:
- It’s important to anticipate half-hour to transform one other file.
- Restricted variety of conversions – 10 monthly.
In case you are curious to be taught extra about this software, you could find the entire function listing in addition to a listing of accessible subscriptions and costs right here.
Not like the earlier PDF converter, this one has produced very respectable outcomes on the first workbook, with none format distortions or errors.
As for the 2nd workbook, it was precisely and flawlessly transformed… right into a Phrase doc (.docx). My first although was that I mistakenly selected a mistaken format for the conversion, so I repeated the method and received the identical end result, as you may see within the screenshot beneath:
Giving it a second thought, I got here to the next conclusion. The converter couldn’t export the customized format of my Excel sheet to PDF correctly, so it transformed it to the closest format. It was truly a matter seconds to avoid wasting the Phrase doc as PDF utilizing Phrase’s Save As dialog and get a properly formatted PDF file because the end result.
Soda PDF On-line Converter
This on-line PDF converter permits you to create PDF paperwork from many codecs, together with Microsoft Excel, Phrase and PowerPoint, in addition to JPEG, PNG photos and HTML pages.
Soda PDF On-line Companies present free and paid memberships. At no cost, you will get limitless PDF creation and restricted PDF Conversions, one file each half-hour. If you need extra, you’ll have to improve to Premium (round $ 10 per 3 months). On this case, additionally, you will get the flexibility to merge and cut up PDF recordsdata.
This on-line Excel to PDF converter was virtually impeccable. The first workbook was transformed to PDF faultlessly, the 2nd workbook was additionally transformed with none errors, however the first letter in a single phrase was truncated:
Alas, nothing is ideal on this world…
Excel to PDF Converter
The Excel to PDF on-line converter accessible at bnok.vn is strongest with regard to options and choices. It helps you to select the vertical or horizontal sheet scaling, paper measurement and orientation in addition to whether or not to point out Excel grids within the ensuing PDF file or not.
Regrettably, the Excel to PDF conversions carried out by this service aren’t so spectacular. My PDF recordsdata have precisely the identical errors and format distortions as those produced by Nitro Excel to PDF Converter.
As you see, not one of the free Excel to PDF on-line converters is ideal, although Soda PDF may be very shut. Somebody might imagine the issue is with my authentic Excel paperwork. I agree, the second workbook has fairly a classy customized format. It’s because my function was to carry out some form of “stress testing” to disclose the actual potential of PDF to Excel on-line converters since your precise workbooks could also be much more complicated and complicated when it comes to contents and format.
For the sake of experiment, I transformed each take a look at workbooks to PDF utilizing Excel’s Save As dialog and it coped with the duty completely tremendous – the ensuing PDF recordsdata have been the precise replicas of the unique Excel paperwork.
Excel to PDF desktop converters
Moreover on-line Excel to PDF converters, there exists a wide range of desktop instruments for changing Excel recordsdata into PDF paperwork that present completely different choices relying on what you anticipate in a closing doc: from free one-click utilities to enterprise-level skilled packages. Since we’re primarily taken with free Excel to PDF converters, let’s have a better take a look at a few such instruments.
Foxit Reader – free desktop Excel to PDF converter
Foxit Reader is a small PDF viewer that permits you to view, signal and print PDF recordsdata in addition to create PDF paperwork from Excel workbooks. It helps you to convert Excel spreadsheets to PDF both from Foxit Reader or straight from Excel.
Changing Excel to PDF from Foxit Reader
That is the quickest option to convert an Excel workbook to PDF that requires solely 3 fast steps.
- Open your Excel file.
On the File tab, click on Create > From File, then From File once more and browse for the Excel doc you need to convert.
- Overview the PDF file.
As soon as you have chosen an Excel file, Foxit Reader instantly opens it within the PDF format. A very nice function is which you can have a number of PDF recordsdata open at a time, every residing by itself tab, as you see within the screenshot beneath:
Please listen that the Excel Vacation Present Listing, which was a tough nut to crack for a lot of the on-line Excel to PDF converters, current no issue in any respect for this desktop software!
- Save the PDF file.
If the whole lot is Okay, click on Save As on the File tab or press Ctrl + S to avoid wasting the file. Yep, it’s as simple as that!
Changing an Excel file to PDF from Excel
This method is beneficial if you need extra choices to preview and customise the ensuing PDF doc.
After set up Foxit Reader provides “Foxit Reader PDF Printer” to your listing of printers, which is, in reality, a pseudo printer that can be utilized to configure the ultimate look of your PDF doc.
- Open an Excel file to be transformed to PDF.
Open an Excel workbook, swap to the File tab, click on Print, and choose Foxit Reader PDF Printer within the listing of printers.
- Configure the settings.
Underneath the Settings part, you’ve gotten the next selections:
- Convert an energetic sheet, whole workbook or choice to PDF.
- Select the doc orientation – portrait or panorama.
- Outline the paper format and margins.
- Match the sheet, all columns or all rows on one web page.
As you make modifications, they’re instantly mirrored within the doc Preview on the suitable.
If you need extra choices, click on the Web page Setup hyperlink beneath Settings.
- Configure extra settings (elective).
Utilizing the Web page Setup dialog window, you may add a customized header or/and footer, change the web page order, present or conceal gridlines and extra.
- Save the PDF file.
When all of the edits are achieved, click on the Print button to avoid wasting the file. This can open the usual Excel Save as dialog window the place you select a vacation spot folder and kind the file title.
Primo PDF – a pseudo printer to transform Excel to PDF
PrimoPDF is another pseudo printer that may enable you to export your Excel paperwork to the PDF format. The options and choices supplied by this software program are similar to Foxit Reader’s, and also you set it up precisely in the identical manner – choose PrimoPDF beneath Printer and play with the settings.
Hopefully, this fast evaluate of desktop and on-line Excel to PDF converters has helped you to decide on your winner. If not one of the introduced instruments is the perfect match in your process, you may strive some different strategies, for instance, importing your Excel recordsdata to Google Sheets after which exporting them to PDF, or changing Excel to PDF through Open Workplace.
Within the subsequent article, we are going to deal with the alternative process and discover the specificities of importing PDF recordsdata to Excel. I thanks for studying and hope to see you once more subsequent week!
You might also be taken with
- Changing PDF recordsdata (textual content and picture) to Excel
- The way to convert Phrase to PDF – on-line and desktop options
- Convert PDF to Phrase utilizing on-line PDF to DOC converters or manually