-1.3 C
New York
Wednesday, January 19, 2022

Buy now

How to convert excel to pdf with all columns

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.

See more: How to convert excel to pdf with all columns

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.

  1. 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 : )
  2. In Excel 2013 and 1020, click on File > Save as. In Excel 2007, click on the Workplace button > Save as.
  3. 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).
  4. Click on the Choices… button within the left-lower a part of the window (please see the screenshot above).
  5. 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 : )

    Select whether you want to convert a selection, table, an active sheet or entire Excel workbook to PDF.

  6. 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

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. Exporting an Excel file to PDF using Adobe Reader

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. Converting an Excel file to PDF using Adobe Acrobat Pro

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:

Test Workbook 1 - a few tables in different formats

Check Workbook 2 – Microsoft’s Vacation Present Planner template:

Test Workbook 2 - Microsoft

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: Nitro Excel to PDF Converter

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 : (

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: Workbook 1 converted to PDF using Nitro Excel to PDF Converter

The second take a look at workbook was transformed to PDF with a number of errors, as you may see within the screenshot beneath: Workbook 2 converted to PDF using Nitro Excel to PDF Converter

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.

PDF Converter

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.

Online Excel to PDF converter

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: You can either download the resulting PDF file to your computer or save it 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.

Outcomes:

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: Workbook 2 was converted into a Word document instead of PDF.

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. Soda PDF Online Converter

Outcomes:

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: Test Workbook 2 converted to PDF using Soda PDF Converter

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. An advanced Excel to PDF online converter

Outcomes:

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.

  1. 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. Saving an Excel file to PDF using Foxit Reader

  2. 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: Reviewing the resulting PDF file

    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!

  3. 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.

  1. 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. Select Foxit Reader PDF Printer as a printer.

  2. 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. To get more options, click the Page Setup link under Settings.

  3. 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. Configure additional settings.

  4. 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. Click Print to save the PDF file.

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.

Primo PDF - a pseudo printer to convert Excel to PDF 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

Related Articles

Stay Connected

0FansLike
3,119FollowersFollow
0SubscribersSubscribe

Latest Articles