{"id":19278,"date":"2020-09-16T05:32:36","date_gmt":"2020-09-16T03:32:36","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=19278"},"modified":"2024-05-25T17:06:28","modified_gmt":"2024-05-25T15:06:28","slug":"7-quick-ways-to-convert-excel-to-pdf-pdf-to-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/7-quick-ways-to-convert-excel-to-pdf-pdf-to-excel\/","title":{"rendered":"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19535\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/excel-to-pdf-2.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"800\" height=\"450\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/excel-to-pdf-2.png 800w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/excel-to-pdf-2-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/excel-to-pdf-2-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h3>7 Quick Conversion Methods \u2013 Excel to PDF &amp; PDF to Excel<\/h3>\n<p>Excel and PDF are the<strong> two most popular file types<\/strong> and you might need to <strong>convert one format to another<\/strong> from time to time.<\/p>\n<p><em>This tutorial will cover exactly that &#8211; How <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/word-files-to-pdf\/\" target=\"_blank\" rel=\"noopener\">to Convert Excel<\/a> to PDF or PDF to Excel.<\/em><\/p>\n<p><strong>PDF files<\/strong> are a widely used format for electronic documents. They are used when you need to save a file without modification so that it can be easily shared and printed. By default, an Excel Workbook is<strong> saved as a .xlsx<\/strong> file type.<\/p>\n<p>But you can easily <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/xlsx-to-csv\/\" target=\"_blank\" rel=\"noopener\">convert Excel to PDF format<\/a><\/strong>. Similarly, you can easily create tables from the <strong>PDF document using Excel.<\/strong><\/p>\n<p>This article will cover the following <strong>two conversion methods<\/strong> in detail:<\/p>\n<ul>\n<li><a href=\"#convert-excel-to-pdf\"><strong>Convert Excel to PDF<\/strong><\/a><\/li>\n<li><a href=\"#convert-pdf-to-excel\"><strong>Convert PDF to Excel<\/strong><\/a><\/li>\n<\/ul>\n<p>Let&#8217;s look at both ways one-by-one!<\/p>\n<p>Make sure to download the Excel Workbook below and follow along:<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/7-Quick-Ways-to-Convert-Excel-to-PDF-PDF-to-Excel.xlsm\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-39.html\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong> download excel workbook<\/strong> <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">7-Quick-Ways-to-Convert-Excel-to-PDF-PDF-to-Excel.xlsm<\/span><\/a><\/p>\n<\/div>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/7-quick-ways-to-convert-excel-to-pdf-pdf-to-excel\/#Want_to_know_how_to_convert_excel_to_pdf_and_pdf_to_excel\" title=\"Want to know how to convert excel to pdf and pdf to excel?\">Want to know how to convert excel to pdf and pdf to excel?<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Want_to_know_how_to_convert_excel_to_pdf_and_pdf_to_excel\"><\/span><em><strong>Want to know how to convert excel to pdf and pdf to excel?<\/strong><\/em><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***<\/p>\n<p>Watch it on <a href=\"https:\/\/youtu.be\/0hoLfiBAeLw\" target=\"_blank\" rel=\"nofollow noopener\"><strong>YouTube<\/strong><\/a> and give it a thumbs-up!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/0hoLfiBAeLw?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/DataEntry3.xlsm\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/DataEntry2.xlsm\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download the youtube excel practice file<\/strong><\/span><span class=\"postTitle px-3\">DataEntry3.xlsm<\/span><\/a><\/p>\n<\/div>\n<h3><strong><a id=\"convert-excel-to-pdf\"><\/a>Convert Excel to PDF<\/strong><\/h3>\n<p>PDFs can be easily shared and can be viewed on any platform without a change in format. So, learning how to convert Excel to PDF is extremely essential!<\/p>\n<p>There are <strong>5 different methods<\/strong> in which you can convert Excel to PDF:<\/p>\n<ul>\n<li><a href=\"#using-save-as-option\"><strong>#1 &#8211; Using Save as Option<\/strong><\/a><\/li>\n<li><a href=\"#using-export-option\"><strong>#2 &#8211; Using Export Option<\/strong><\/a><\/li>\n<li><a href=\"#export-using-quick-access-toolbar\"><strong>#3 &#8211; Export using Quick Access Toolbar<\/strong><\/a><\/li>\n<li><a href=\"#email-pdf-using-quick-access-toolbar\"><strong>#4 &#8211; Email PDF using Quick Access Toolbar<\/strong><\/a><\/li>\n<li><a href=\"#using-vba\"><strong>#5 &#8211; Using VBA<\/strong><\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #23984e\"><strong><a id=\"using-save-as-option\"><\/a>#1 &#8211; Using Save As Option<\/strong><\/span><\/p>\n<p>Follow the step-by-step tutorial on how to convert Excel to PDF using the Save As option:<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 1: <\/strong><\/span>Select the Excel table that you want in the PDF Format.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-639.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19315\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-639.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"835\" height=\"448\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-639.png 835w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-639-300x161.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-639-768x412.png 768w\" sizes=\"(max-width: 835px) 100vw, 835px\" \/><\/a><\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 2:<\/strong><\/span> Click on <strong>File<\/strong> Tab.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-631.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19316\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-631.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"597\" height=\"129\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-631.png 597w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-631-300x65.png 300w\" sizes=\"(max-width: 597px) 100vw, 597px\" \/><\/a><\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 3:<\/strong><\/span> Select<strong> Save As<\/strong> &gt; <strong>Browse.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-640.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19317\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-640.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"497\" height=\"536\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-640.png 497w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-640-278x300.png 278w\" sizes=\"(max-width: 497px) 100vw, 497px\" \/><\/a><\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 4:<\/strong><\/span> In the <strong>Save As<\/strong> dialog box, <strong>select the\u00a0location<\/strong> where you want to save the PDF file.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-634-copy.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19318\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-634-copy.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"671\" height=\"485\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-634-copy.png 671w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-634-copy-300x217.png 300w\" sizes=\"(max-width: 671px) 100vw, 671px\" \/><\/a><\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 5:<\/strong><\/span> Under Save as type dropdown, select <strong>PDF<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-635.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19319\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-635.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"914\" height=\"558\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-635.png 914w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-635-300x183.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-635-768x469.png 768w\" sizes=\"(max-width: 914px) 100vw, 914px\" \/><\/a><\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 6:<\/strong><\/span> Click on the <strong>Options<\/strong> button to customize the PDF file you want to create.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-636-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19414\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-636-1.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"673\" height=\"571\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-636-1.png 673w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-636-1-300x255.png 300w\" sizes=\"(max-width: 673px) 100vw, 673px\" \/><\/a><\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 7:<\/strong><\/span> In the <strong>Options<\/strong> dialog box, Go to <strong>Publish what<\/strong> section and click on <strong>Selection<\/strong>. Then, Click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-638.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19322\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-638.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"669\" height=\"571\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-638.png 669w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-638-300x256.png 300w\" sizes=\"(max-width: 669px) 100vw, 669px\" \/><\/a><\/p>\n<p><em>This will help you to publish only what you have selected on the sheet.<\/em> <em>To publish the entire sheet, click on<strong> Active Sheet(s)<\/strong>, and to publish the workbook click on the <strong>Entire Workbook<\/strong>.<\/em><\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 8:<\/strong><\/span> Click <strong>Save<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-641-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19415\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-641-1.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"667\" height=\"565\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-641-1.png 667w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-641-1-300x254.png 300w\" sizes=\"(max-width: 667px) 100vw, 667px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>This will save you Excel Table in PDF format.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-646.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19328\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-646.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"769\" height=\"458\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-646.png 769w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-646-300x179.png 300w\" sizes=\"(max-width: 769px) 100vw, 769px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #23984e\"><strong><a id=\"using-export-option\"><\/a>#2 &#8211; Using Export Option<\/strong><\/span><\/p>\n<p>The Export option in Excel will provide you with a<strong> quicker way<\/strong> to save your file as PDF.<\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 1:<\/strong><\/span>Go to the <strong>File<\/strong> Tab.<\/p>\n<p><strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-631.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19316\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-631.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"597\" height=\"129\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-631.png 597w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-631-300x65.png 300w\" sizes=\"(max-width: 597px) 100vw, 597px\" \/><\/a><\/strong><\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 2:<\/strong><\/span> Click on <strong>Export<\/strong> &gt; <strong>Create PDF\/XPS Document\u00a0<\/strong>&gt; <strong>Create PDF\/XPS Document\u00a0<\/strong>button.<\/p>\n<p><span style=\"color: #ff0000\"><span style=\"color: #000000\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-644.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19324\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-644.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"917\" height=\"538\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-644.png 917w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-644-300x176.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-644-768x451.png 768w\" sizes=\"(max-width: 917px) 100vw, 917px\" \/><\/a><\/span><\/span><\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 3:\u00a0<\/strong><\/span>In the <strong>Publish as PDF or XPS<\/strong> dialog box, click on <strong>Publish<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-645-copy.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19326\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-645-copy.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"669\" height=\"579\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-645-copy.png 669w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-645-copy-300x260.png 300w\" sizes=\"(max-width: 669px) 100vw, 669px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #23984e\"><strong><a id=\"export-using-quick-access-toolbar\"><\/a>#3 &#8211; Export using Quick Access Toolbar<\/strong><\/span><\/p>\n<p>If converting Excel <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/track-changes-in-excel\/\" target=\"_blank\" rel=\"noopener\">to PDF<\/a> is a regular task for you, you can add it to the Quick Access Toolbar (QAT). Follow the steps below to add Publish as PDF option to the QAT:<\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 1:<\/strong><\/span> <strong>Right Click<\/strong> on the QAT to customize it.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-668.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19380\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-668.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"597\" height=\"216\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-668.png 597w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-668-300x109.png 300w\" sizes=\"(max-width: 597px) 100vw, 597px\" \/><\/a><\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 2:<\/strong><\/span> In the Excel Options dialog box, select<strong> Quick Access Toolbar<\/strong> &gt; <strong>Publish as PDF or XPS<\/strong> &gt;<strong> Add<\/strong>. <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-669.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19381\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-669.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"823\" height=\"679\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-669.png 823w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-669-300x248.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-669-768x634.png 768w\" sizes=\"(max-width: 823px) 100vw, 823px\" \/><\/a><\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 3:<\/strong><\/span> This will add <strong>Publish as PDF<\/strong> under Customize Quick Access Toolbar. Now, <strong>Click OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-670.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19382\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-670.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"823\" height=\"677\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-670.png 823w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-670-300x247.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-670-768x632.png 768w\" sizes=\"(max-width: 823px) 100vw, 823px\" \/><\/a> \u00a0<span style=\"color: #23984e\"><strong>STEP 4:<\/strong><\/span> This will<strong> add Publish as PDF\/XPS to the Quick Access Toolbar<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-671.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19383\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-671.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"323\" height=\"161\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-671.png 323w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-671-300x150.png 300w\" sizes=\"(max-width: 323px) 100vw, 323px\" \/><\/a><\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 5:<\/strong><\/span> Simply click on the icon, select the file location you want to save it at and click on Publish.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-645-copy.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19326\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-645-copy.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"669\" height=\"579\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-645-copy.png 669w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-645-copy-300x260.png 300w\" sizes=\"(max-width: 669px) 100vw, 669px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #23984e\"><strong>#4 &#8211; Email PDF using Quick Access Toolbar<\/strong><\/span><\/p>\n<p>If you want to attach an Excel file as PDF in an email, you can add it to the Quick Access Toolbar (QAT).<\/p>\n<p>Follow the steps below to email PDF as QAT:<\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 1:<\/strong><\/span> <strong>Right Click<\/strong> on the QAT to customize it.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-668.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19380\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-668.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"597\" height=\"216\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-668.png 597w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-668-300x109.png 300w\" sizes=\"(max-width: 597px) 100vw, 597px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 2:<\/strong><\/span> In the Excel Options dialog box, select<strong> Quick Access Toolbar<\/strong> &gt; <strong>E-mail as PDF Attachment<\/strong> &gt;<strong> Add<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-673.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19384\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-673.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"825\" height=\"677\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-673.png 825w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-673-300x246.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-673-768x630.png 768w\" sizes=\"(max-width: 825px) 100vw, 825px\" \/><\/a><\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 3:<\/strong><\/span> This will add<strong> E-mail as PDF Attachment<\/strong> under Customize Quick Access Toolbar. Now, <strong>Click OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-674.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19385\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-674.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"823\" height=\"675\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-674.png 823w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-674-300x246.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-674-768x630.png 768w\" sizes=\"(max-width: 823px) 100vw, 823px\" \/><\/a><\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 4:<\/strong><\/span> This will add <strong>E-mail as PDF Attachment<\/strong> to Quick Access Toolbar.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-675.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19386\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-675.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"323\" height=\"160\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-675.png 323w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-675-300x149.png 300w\" sizes=\"(max-width: 323px) 100vw, 323px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #23984e\"><strong><a id=\"using-vba\"><\/a>#5 &#8211; Using VBA<\/strong><\/span><\/p>\n<p>You can also <strong>use <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/\" target=\"_blank\" rel=\"noopener\" title=\"VBA\" data-wpil-keyword-link=\"linked\">VBA<\/a> code to publish a range in Excel into PDF<\/strong>. This VBA will prompt you to provide the range you wish to export and then select the location, to automatically export Excel to PDF.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Copy Source Code<\/strong><\/p>\n<blockquote>\n<p class=\"lp-headline text-align-left font-scale-6 line-height-scale-5 small-subhead\"><strong>&#8216;<\/strong><strong>MyExcelOnline.com &#8211; PrintSelectionToPDF<\/strong><strong><br \/>\nSub PrintSelectionToPDF()<\/strong><\/p>\n<p>&#8216;Declaration of Variables<br \/>\nDim rng As Range<br \/>\nDim strFilePath As String<br \/>\nDim strFile As String<br \/>\nDim file As Variant<\/p>\n<p>&#8216;Check first if a range has been selected<br \/>\nIf Selection.Count = 1 Then<br \/>\nSet rng = Application.InputBox(&#8220;Please select a range&#8221;, &#8220;Get Range&#8221;, Type:=8)<br \/>\nElse<br \/>\nSet rng = Selection<br \/>\nEnd If<\/p>\n<p>&#8216;Create the filename with the path &#8211; the default filename is ExceltoPdf.pdf<br \/>\nstrFile = &#8220;ExceltoPdf.pdf&#8221;<br \/>\nstrFile = ThisWorkbook.Path &amp; &#8220;\\&#8221; &amp; strFile<\/p>\n<p>&#8216;We open a save prompt for the username to select the location and filename<br \/>\nfile = Application.GetSaveAsFilename(InitialFileName:=strFile, FileFilter:=&#8221;PDF Files (*.pdf), *.pdf&#8221;, Title:=&#8221;Select location for the PDF file&#8221;)<\/p>\n<p>&#8216;Start the export process of the selected range<br \/>\nIf file &lt;&gt; &#8220;False&#8221; Then<br \/>\nrng.ExportAsFixedFormat Type:=xlTypePDF, Filename:=file, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False<br \/>\nMsgBox &#8220;PDF file has been successfully created: &#8221; &amp; strFile<br \/>\nElse<br \/>\nMsgBox &#8220;Unable to create PDF file&#8221;, vbOKOnly, &#8220;No File Selected&#8221;<br \/>\nEnd If<\/p>\n<p>End Sub<br \/>\n<em><strong><br \/>\n<\/strong><\/em><\/p><\/blockquote>\n<p>&nbsp;<\/p>\n<pre><\/pre>\n<p>Follow the steps below to use this VBA code to Export selection to PDF:<\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 1:<\/strong><\/span> Press <strong>Alt + F11<\/strong> to open VBA Editor.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-692.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone wp-image-19389 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-692-e1599739835670.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"1320\" height=\"526\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-692-e1599739835670.png 1320w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-692-e1599739835670-300x120.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-692-e1599739835670-1024x408.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-692-e1599739835670-768x306.png 768w\" sizes=\"(max-width: 1320px) 100vw, 1320px\" \/><\/a><\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 2:<\/strong><\/span> Right Click on the sheet name and then select <strong>Insert<\/strong> &gt; <strong>Module<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-686.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone wp-image-19391 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-686-e1599744171592.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"711\" height=\"442\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-686-e1599744171592.png 711w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-686-e1599744171592-300x186.png 300w\" sizes=\"(max-width: 711px) 100vw, 711px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 3:<\/strong><\/span> <strong>Copy-paste<\/strong> the VBA code from above into here.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-696.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19498\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-696.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"1295\" height=\"498\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-696.png 1295w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-696-300x115.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-696-1024x394.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-696-768x295.png 768w\" sizes=\"(max-width: 1295px) 100vw, 1295px\" \/><\/a><\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 4:<\/strong><\/span> Press <strong>Ctrl + S<\/strong> to save the file and then click <strong>No<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-678.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19393\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-678.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"622\" height=\"173\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-678.png 622w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-678-300x83.png 300w\" sizes=\"(max-width: 622px) 100vw, 622px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 5:<\/strong><\/span> In the Save as dialog box, choose <strong>Excel macro-enabled workbook<\/strong> from the drop-down list and click the<strong>\u00a0Save<\/strong>\u00a0button.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-679.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19394\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-679.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"775\" height=\"595\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-679.png 775w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-679-300x230.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-679-768x590.png 768w\" sizes=\"(max-width: 775px) 100vw, 775px\" \/><\/a><\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 6:<\/strong><\/span> Press <strong>Alt + F8<\/strong> to open the <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/\" target=\"_blank\" rel=\"noopener\" title=\"Macro\" data-wpil-keyword-link=\"linked\">Macro<\/a> dialog box.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-688-Copy.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19395\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-688-Copy.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"372\" height=\"362\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-688-Copy.png 372w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-688-Copy-300x292.png 300w\" sizes=\"(max-width: 372px) 100vw, 372px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 7:<\/strong><\/span> Select the Macro<strong> PrintSelectionToPDF<\/strong> that is located in <strong>All Open Workbooks<\/strong> and click <strong>Run<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-688.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19396\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-688.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"372\" height=\"362\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-688.png 372w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-688-300x292.png 300w\" sizes=\"(max-width: 372px) 100vw, 372px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 8:<\/strong><\/span> In the dialog box, type the required range &#8211;<strong> A1: F8<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-689.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19397\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-689.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"268\" height=\"116\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 9:<\/strong><\/span> Select the location and press <strong>Save<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-694.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19424\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-694.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"670\" height=\"474\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-694.png 670w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-694-300x212.png 300w\" sizes=\"(max-width: 670px) 100vw, 670px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>This is how you can convert the range A1: F8 in excel to PDF.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-691.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19398\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-691.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"1269\" height=\"587\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-691.png 1269w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-691-300x139.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-691-1024x474.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-691-768x355.png 768w\" sizes=\"(max-width: 1269px) 100vw, 1269px\" \/><\/a><\/p>\n<h3><strong><a id=\"convert-pdf-to-excel\"><\/a>Convert PDF to Excel<\/strong><\/h3>\n<p>PDF does not allow users to make edits on the data so it might be useful to learn how to convert the data from PDF to Excel. If you have a table saved in PDF, you can easily get that imported in Excel and work on it easily.<\/p>\n<p>The <strong>two methods<\/strong> for converting PDF to Excel are:<\/p>\n<ul>\n<li><a href=\"#copy-and-paste\"><strong>#1 &#8211; Copy and Paste<\/strong><\/a><\/li>\n<li><a href=\"#import-data-from-pdf-to-excel\"><strong>#2 &#8211; Import Data from PDF to Excel<\/strong><\/a><\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-659.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19334\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-659.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"535\" height=\"516\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-659.png 535w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-659-300x289.png 300w\" sizes=\"(max-width: 535px) 100vw, 535px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #23984e\"><strong><a id=\"copy-and-paste\"><\/a>#1 &#8211; Copy and Paste<\/strong><\/span><\/p>\n<p>The most simple method to convert PDF to Excel is to copy &amp; paste the data. <em>Let&#8217;s look at an example to understand this better.<\/em><\/p>\n<p><strong>Follow the steps below<\/strong> for a detailed tutorial on PDF to Excel converter:<\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 1:<\/strong> <\/span>Press <strong>Ctrl + A<\/strong> and<strong> Ctrl + C<\/strong> to select the entire data and copy the data in PDF.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-661.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19335\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-661.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"966\" height=\"637\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-661.png 966w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-661-300x198.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-661-768x506.png 768w\" sizes=\"(max-width: 966px) 100vw, 966px\" \/><\/a><\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 2:<\/strong><\/span> Open the Excel File and simply press Ctrl + V to paste the data in Excel.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-662.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19337\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-662.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"244\" height=\"462\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-662.png 244w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-662-158x300.png 158w\" sizes=\"(max-width: 244px) 100vw, 244px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Even though, you have got the data in Excel it is <strong>not formatted in the way you want<\/strong>. You can use different functions of Excel to format that like <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/split-first-last-name-using-excel-text-column\/\" target=\"_blank\" rel=\"noopener noreferrer\">Text to Column<\/a><\/strong>, <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/index-function-introduction\/\" target=\"_blank\" rel=\"noopener noreferrer\">Index Formula<\/a><\/strong>, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-offset-function-introduced\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>OFFSET Formula<\/strong><\/a>, etc.<\/p>\n<p>In this example, you need to transpose every 5<sup>th<\/sup> row into a single row using OFFSET <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"Formula\" data-wpil-keyword-link=\"linked\">Formula<\/a>.<\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 3:<\/strong><\/span> In the blank cell C1, start with the OFFSET formula to transpose the data<\/p>\n<p><span style=\"color: #ff0000\"><strong>=OFFSET($A$1<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-663.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19338\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-663.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"826\" height=\"425\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-663.png 826w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-663-300x154.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-663-768x395.png 768w\" sizes=\"(max-width: 826px) 100vw, 826px\" \/><\/a><\/p>\n<p>This will provide Excel with the starting point to extract data from i.e cell A1.<\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 4:<\/strong><\/span> Now, type the second argument the provides Excel with the number of rows, up or down, that you want the top-left cell of the result to refer to.<\/p>\n<p><strong>=OFFSET($A$1,<span style=\"color: #ff0000\">COLUMNS($A1:A1)-1+(ROWS($1:1)-1)*5,<\/span><\/strong> \u00a0 Here:<\/p>\n<ul>\n<li><strong>COLUMNS ($A1: A1)<\/strong> will count the columns in the defined range and it will expand by keeping the first reference frozen ($A1) and the second reference (A1) relative. When you will drag the formula right, the column count will increase.<\/li>\n<li>Similarly, <strong>ROWS ($1:1)<\/strong> will count the rows in the defined range and it will expand by keeping the first reference frozen ($1) and the second reference (1) relative. When you will drag the formula down, the row count will increase.<\/li>\n<li>Moreover, we are <strong>multiplying (ROWS($1:1)-1) with 5 <\/strong>because we want to transpose every 5 rows from 1 column to multiple columns.<\/li>\n<li>Lastly, say if we want to transpose data from cell A1 to C1. We need to<strong> subtract 1<\/strong> from both COLUMNS and ROWS function Excel to say in the same row and column from the starting point i.e. A1.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 5:<\/strong><\/span> Type the third argument the provides Excel with the number of columns, to the left or right, that you want the top-left cell of the result to refer to.<\/p>\n<p>Since the entire data is in the same column i.e. Column A, the third argument will be 0.<\/p>\n<p><strong>=OFFSET($A$1,COLUMNS($A1:A1)-1+(ROWS($1:1)-1)*5,<span style=\"color: #ff0000\">0<\/span>)<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 6:<\/strong><\/span> <strong>Drag this formula<\/strong> right till Column G.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-664.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19339\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-664.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"636\" height=\"287\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-664.png 636w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-664-300x135.png 300w\" sizes=\"(max-width: 636px) 100vw, 636px\" \/><\/a><\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 7:<\/strong><\/span> Again, <strong>drag down<\/strong> till row 46 to incorporate the entire table.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-667.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19340\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-667.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"699\" height=\"485\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-667.png 699w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-667-300x208.png 300w\" sizes=\"(max-width: 699px) 100vw, 699px\" \/><\/a><\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 8:<\/strong><\/span> Change the <strong>Date &amp; Currency format<\/strong>, <strong>make the header bold<\/strong> and<strong> insert borders<\/strong>.<\/p>\n<p>Your Data Table is ready!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-666.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19341\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-666.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"751\" height=\"486\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-666.png 751w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-666-300x194.png 300w\" sizes=\"(max-width: 751px) 100vw, 751px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><em>Let&#8217;s look at how Excel retrieves a value using this formula in a particular cell (say E4).<\/em><\/p>\n<p>=OFFSET($A$1,COLUMNS($A4:C4)-1+(ROWS($1:4)-1)*5,0)<\/p>\n<p>=OFFSET($A$1, 4-1+(ROWS($1:4)-1)*5,0)<\/p>\n<p>=OFFSET($A$1, 3+(4-1)*5,0<\/p>\n<p>=OFFSET($A$1,18,0)<\/p>\n<p>=John Michaloudis<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-2020-09-11-at-4.50.49-AM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19425\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-2020-09-11-at-4.50.49-AM.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"747\" height=\"449\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-2020-09-11-at-4.50.49-AM.png 747w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-2020-09-11-at-4.50.49-AM-300x180.png 300w\" sizes=\"(max-width: 747px) 100vw, 747px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #23984e\"><strong><a id=\"import-data-from-pdf-to-excel\"><\/a>#2 &#8211; Import Data from PDF to Excel<\/strong><\/span><\/p>\n<p>In most cases, you will be able to simply copy &amp; paste the data and format it to get the desired result. But if that is not working for you, use the <strong>Import Data method<\/strong> in Excel.<\/p>\n<p><strong>Follow the steps<\/strong> below to import data from PDF to Excel (For Excel 365 only):<\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 1:<\/strong><\/span> Go to <strong>Data<\/strong> Tab &gt;<strong> Get Data<\/strong> &gt;<strong> From File<\/strong> &gt; <strong>From PDF<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-655.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19332\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-655.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"546\" height=\"501\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-655.png 546w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-655-300x275.png 300w\" sizes=\"(max-width: 546px) 100vw, 546px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 2:<\/strong><\/span> In the <strong>Import Data<\/strong> dialog box, select the location of the PDF file, and click on<strong> Import<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-656-copy.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19333\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-656-copy.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"670\" height=\"473\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-656-copy.png 670w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-656-copy-300x212.png 300w\" sizes=\"(max-width: 670px) 100vw, 670px\" \/><\/a><\/p>\n<p><span style=\"color: #23984e\"><strong>STEP 3:<\/strong><\/span> In the dialog box,<strong> select the table<\/strong> from the left panel and click on <strong>Load<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-657.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19343\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-657.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"873\" height=\"700\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-657.png 873w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-657-300x241.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-657-768x616.png 768w\" sizes=\"(max-width: 873px) 100vw, 873px\" \/><\/a><\/p>\n<p>This will convert the table from PDF to Excel!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-659-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" class=\"alignnone size-full wp-image-19344\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-659-1.png\" alt=\"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel\" width=\"535\" height=\"516\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-659-1.png 535w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/09\/Screenshot-659-1-300x289.png 300w\" sizes=\"(max-width: 535px) 100vw, 535px\" \/><\/a><\/p>\n<h3>Conclusion<\/h3>\n<p>In this article, you have learned <strong>how to swap between the two most commonly used file formats &#8211; Excel &amp; PDF<\/strong>.<\/p>\n<p>When you need a file in PDF format<strong> for sharing or printing<\/strong> &#8211; <strong>Convert Excel to PDF<\/strong> by using either the Save as or Export option.<\/p>\n<p>Similarly, when you need <strong>to make edits<\/strong> in a PDF file &#8211; <strong>Convert PDF to Excel<\/strong> by using either the copy-paste technique or the Import Data feature in Excel 365.<\/p>\n<p><em>You can learn more about how to import or export files in Excel by going through this <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><strong>tutorial by Microsoft<\/strong><\/a>.<\/em><\/p>\n<h3>HELPFUL RESOURCE:<\/h3>\n<p>Make sure to download our FREE PDF on the<strong><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener noreferrer\"> 333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n<p><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"nofollow noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-14329 size-medium\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-300x200.jpg\" alt=\"pdf to excel\" width=\"300\" height=\"200\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-300x200.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-1024x682.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-768x512.jpg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups.jpg 1340w\" sizes=\"(max-width: 300px) 100vw, 300px\" title=\"\"><\/a><\/p>\n<p>You can learn more about how to use Excel by viewing our FREE Excel webinar training on <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-43.html\" target=\"_blank\" rel=\"noopener noreferrer\">Formulas<\/a>, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\">Pivot Tables<\/a>, <\/strong>and <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-39.html\" target=\"_blank\" rel=\"noopener noreferrer\">Macros &amp; VBA<\/a>!<\/strong><\/p>\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/save-selected-range-as-pdf-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener\">Save Selected Range as PDF Using Macros In Excel<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/save-each-worksheet-as-a-pdf-file-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener\">Save Each Worksheet as a PDF File Using Macros In Excel<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-save-word-as-pdf\/\" target=\"_blank\" rel=\"noopener\">How to Save Word as PDF<\/a><\/li>\n<\/ul>\n<p><em><strong>You can follow our\u00a0<a href=\"https:\/\/www.youtube.com\/user\/LearnExcelPivotTable\" target=\"_blank\" rel=\"noopener noreferrer\">YouTube channel<\/a> to learn more about How To Merge Cells in Excel!<\/strong><\/em><\/p>\n<p><strong><style>.special-box a { color: #fff; } <\/style><div class=\"drop-shadow lifted special-box\" style=\"text-align: center; color: #fff; padding: 15px; background: var(--V4-primary-orange); border-radius: 6px;\"> <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-51.html\" target=\"_blank\" rel=\"noopener noreferrer\">&#x1f449; Click Here To Join Our Excel Academy Online Course &amp; Access 1,000+ Excel Tutorials On Formulas, Macros, VBA, Pivot Tables, Dashboards, Power BI, Power Query, Power Pivot, Charts, Microsoft Office Suite + MORE!\u00a0<\/a> <\/div><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>7 Quick Conversion Methods \u2013 Excel to PDF &amp; PDF to Excel Excel and PDF are the two most popular file types and you might need to convert one format to another from time to time. This tutorial will cover exactly that &#8211; How to Convert Excel to PDF or PDF to Excel. PDF files [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":19535,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[10,647,56],"tags":[],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/19278"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=19278"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/19278\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/19535"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=19278"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=19278"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=19278"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}