Microsoft Excel is primarily used to organize or store data in rows and columns and also for various kinds of numerical calculations. Converting an excel spreadsheet or a part of it into PDF is a simple task for anyone with basic MS Office Knowledge, even though it is not as easy as that to convert it back. There are several online and offline ways to do the conversion process and here are some ways or steps to help you with that.

  1. Convert within Microsoft Excel 

Storing excel files in PDF format makes it more convenient to print, send, distribute among a group or organization, etc. To begin with, you have to choose the desired spreadsheet you want to convert into PDF format, click on the file tab and you will see the “Save As” or “Export” option.

  • As soon as you click on that option, a sidebar will emerge showing “Save as PDF” or “Create PDF” option. You have to select that, and it will lead you to a pop-up box with the details of the PDF file you want to create.
  • Select the appropriate details range, and what all to add or include in the PDF file, pages, whether the entire workbook is to be converted or a part of them, etc. and click “OK” after completing the criterion.
  • This will link you to another pop-up where you can decide where to save your file. After choosing the file destination, choose any one of the optimization options and name the file.
  • Finally, click “Save” to complete the process. You will be able to access the PDF file in your device folder.

  1. Convert into PDF Format Online

There are several sites that offer conversion of excel into PDF free of cost. They are comparatively less secure as compared to the conversion among the MS Excel and also require an internet connection, but are still an instant way to do so.

  • All you have to do is find a suitable site for the conversion and open it. Once you open it mostly, you will see a “Choose File” or “Select File” option. Click on that and a box will pop-up which will lead you to your device’s folders.
  • You can also choose the file to convert from Google docs, Dropbox, etc. Choose the excel spreadsheet or workbook which you want to convert and open it or drag it down according to the instructions of the online conversion site.
  • Once you do that the site will instantly convert the files into PDF. After the whole conversion process, click on the download option and the file will get saved to your desired device folder.
  • After the download process, you will be able to access the PDF file in the previously mentioned folder.

  1. Convert Excel to PDF with Software

Generally, PDF conversion software can be free of cost or not but they indeed offer you many advantages such as several tools and advanced options. These can be installed into your device and then the conversion can be done easily without an internet connection.

  • They also simplify the whole process and also are more secure than online sites that offer the same. Also, they include technological features to convert PDF files into other formats. Some online sites may have a size limit for conversion, but software might not possess that problem.
  • The first step you have to do is install the software. Open the software and you will see a “Create PDF” option in the window. Choose any excel file you wish to convert and open the same and the conversion process will get initiated. Click on any end option which is displayed on the screen.
  • Now the PDF file is created and you can edit the file, add images or other features. After that click on the “Save As” or “Save” option available which could be either displayed directly on the page or can be selected from the File tab.
  • Make sure the file is saved in the PDF format in the suitable file destination. You might be able to access the PDF file from your device folder.

  1. Converting the PDF from the Excel Sheet in Android and iOS

The primary step in carrying out the conversion process in androids or iOS is by making sure that the device is connected to the internet. After that, install the MS Excel application into your device.

  • Open the file which you want to convert into PDF format and click on the menu option from the upper corner, from which you will see a send or share option.
  • If you click on the send option then you can direct it as an email attachment after choosing the PDF form in iOS and then choose the layout and send the file in mail-in PDF format.
  • In androids, you can choose the share option, and a pop-up will ask you to select between workbook or PDF form, from which you are supposed to choose PDF.

TIPS

After choosing, tap on the allow button which will convert the file into PDF format and present you a number of compatible applications for you to share the file. Decide on the appropriate location for your file, select yourself as the recipient, or share as a draft from where you will be able to later access the created PDF file.

How do I convert Excel spreadsheet to PDF?

This page teaches you how to convert an Excel file to a PDF file.
  1. Open a workbook.
  2. On the File tab, click Save As.
  3. Click Browse.
  4. Select PDF from the drop-down list.
  5. Click Options.
  6. You can publish a selection, active sheet or entire workbook.
  7. Click OK and then Click Save.

How do I convert Excel to PDF for free?

How to convert Excel to PDF online:
  1. Drag and drop your file to the Excel to PDF converter.
  2. Wait as the tool saves the spreadsheet to PDF format.
  3. On the result page, continue to modify the output file if needed.
  4. Otherwise, download, share or save the file to Dropbox or Google Drive.

How do I convert all columns to PDF in Excel?

Under the Settings section, you have the following choices:
  1. Convert an active sheet, entire workbook or selection to PDF.
  2. Choose the document orientation – portrait or landscape.
  3. Define the paper format and margins.
  4. Fit the sheet, all columns or all rows on one page.

How do I stop Excel from converting to PDF?

After open an excel docuemnt, Use mouse right-button to drag to select cells which you want to print in one page. > Setup the right margins as paper size margins. > Use Scale to Fit to avoid cutting page head or bottom part off.

How do I export from Excel to Word?

Solution One: Copy/Paste

The simplest way to display Excel data in a Word document is to use Copy/Paste. Open the destination Word document. In the source Excel spreadsheet, select the data you want to copy then hit CTRL-C. In the destination Word document, place the cursor where you want the data, then hit CTRL-V.

How do I merge Excel data into a Word template?

What are the six steps of mail merge?

On your Word document, highlight the field you want to populate with the data from Excel. On the Mailings tab, choose the ‘Insert Merge Field’ button, a list of the column headers on your saved excel document will drop down (i.e. Company Name, etc.). Choose the appropriate field you want to merge and choose Insert.

How do I make Excel print on one page?

There are six steps in the mail merge wizard:
  1. Select the document type.
  2. Start the document.
  3. Select recipients.
  4. Write your letter.
  5. Preview your letters.
  6. Complete the merge.

Why is Excel printing so small?

Shrink a worksheet to fit on one page
  1. Click Page Layout.
  2. Select the Page tab in the Page Setup dialog box.
  3. Select Fit to under Scaling.
  4. To fit your document to print on one page, choose 1 page(s) wide by 1 tall in the Fit to boxes.
  5. Press OK at the bottom of the Page Setup dialog box.

What is a page break in Excel?

In the worksheet, click File > Print. Under Settings, click Custom Scaling > Custom Scaling Options. If the paper size setting is different from the paper size in your printer, Excel adjusts the printout to fit the paper size in the printer and the printed worksheet might not match your Print Preview.

How do you AutoFit in Excel?

Page breaks are dividers that break a worksheet into separate pages for printing. Microsoft Excel inserts automatic page breaks based on the paper size, margin settings, scale options, and the positions of any manual page breaks that you insert.

What is the shortcut for AutoFit in Excel?

Change the column width to automatically fit the contents (AutoFit)
  1. Select the column or columns that you want to change.
  2. On the Home tab, in the Cells group, click Format.
  3. Under Cell Size, click AutoFit Column Width.

How do I make a table fit in Excel?

The AutoFit Column Width button bases the width of the column on the cells you have selected. In the image above I have cell A4 selected. So the column width will be adjusted to fit the contents of A4, as shown in the results below. Alt,H,O,A is the keyboard shortcut to AutoFit Row Height.

How do I make words fit in Excel?

Automatically adjust your table or columns to fit the size of your content by using the AutoFit button.
  1. Select your table.
  2. On the Layout tab, in the Cell Size group, click AutoFit.
  3. Do one of the following. To adjust column width automatically, click AutoFit Contents.

What is Ctrl D in Excel?

Adjust text to fit within an Excel cell
  1. Select the cell with text that’s too long to fully display, and press [Ctrl]1.
  2. In the Format Cells dialog box, select the Shrink To Fit check box on the Alignment tab, and click OK.

How do I fit data into one cell in Excel?

Then press Ctrl+D. Whatever is in the first cell is copied to fill the remaining cells.

What is count A in Excel?

On the Home tab, in the Alignment group, click Wrap Text. (On Excel for desktop, you can also select the cell, and then press Alt + H + W.) Notes: Data in the cell wraps to fit the column width, so if you change the column width, data wrapping adjusts automatically.

How do you create a formula for a count function?

The COUNTA function counts cells containing any type of information, including error values and empty text (“”). For example, if the range contains a formula that returns an empty string, the COUNTA function counts that value. The COUNTA function does not count empty cells.