AB D

· 01 Jan 2022

Follow Following

How To Convert Excel To PDF ?

Converting an Excel file to a PDF makes it easier for people to open and view the file on various platforms—even if they don't have #Microsoft Office. PDFs are also easier to print and distribute than Excel spreadsheets. If you have Microsoft Excel, you can easily convert your spreadsheet to a PDF by saving or exporting it within the app. If you don't have Excel, you can use Google Sheets, a tool on Google Drive, to make the conversion for free.

A.Using Excel for #Windows
1. Select the part of the Excel spreadsheet you want to convert to PDF (optional). If there's only a certain part of the Excel file that you want to turn into PDF format, select it now. Otherwise, move on to the next step.
Note that PDF conversions cannot be easily reverted back into an Excel sheet, but this method will preserve your original copy.

2. click the file .it's at the top-left corner.

3. Choose export in the menu. This opens the Export panel.

4. Click create pdf/XPS. Look for the icon that looks like a sheet of paper wearing a belt.

5. Click the options button. This will allow you to adjust the settings for the PDF file you are about to create.

6. Choose your PDF options and click OK.

If you selected an area of your spreadsheet to save as a PDF, choose Selection under "Publish what." This ensures that only that selected area is saved as a PDF.

If you'd rather save the entire visible worksheet as a PDF, choose Active sheet(s) instead.

If you want to choose specific pages from the workbook to save as a PDF, use the "Page(s)" drop-down menus to define the first and last pages.
Click OK to continue.

7. Choose your optimization (optional). Above the "Options" button, you can select how you want to optimize the PDF. Most people can stick with "Standard" unless the spreadsheet is very large. "Minimum size" will reduce the size of a larger file to something more manageable.

If you want to change the location to which you're saving the file, you can navigate to that folder in the window now.

8. Name the file Click Publish. This exports the selected information to a new PDF file with the name you've entered.

9. Review the PDF. By default, the PDF file will open automatically for your review. If it doesn't open automatically, just double-click the name of the file in the folder to which you saved it.

It's not really possible to edit the PDF now, so if you need to make changes you'll want to make them in the Excel document and then create a new PDF.

B.Using Google Drive
1. Go to https://drive.google.com. If you need to convert an Excel spreadsheet to PDF but don't have Excel, don't fret—you can use tools built into your Google account to do the conversion for free.

If you're not already signed in to your Google account, sign in when prompted.

2. Click  new it's at the top-left corner of your Google Drive.

3. Click  File Upload. This opens your computer's file browser.

4. Select your Excel spreadsheet and click Open. This uploads the spreadsheet to your Google Drive.

5. Click the Excel spreadsheet in your Google Drive. This opens the spreadsheet in Google Sheets, Google's free spreadsheet editor.

6. Click the File menu and select Download. A list of download options will expand.

7. Click PDF document (.pdf). This displays a preview of your PDF in the Google Sheets printing window.

8.Adjust the layout of your PDF. If the print preview doesn't look the way you want, use the right panel to make any changes you need before you continue.

The #PDF will save in the same orientation as the spreadsheet (usually landscape mode). If you'd rather it be in portrait (vertical) mode, select Portrait under "Page orientation."

Change the scale (the size/fit on the page) and margin size if necessary.
Click Formatting to choose whether to display grid lines and/or notes, adjust the page order, and change the alignment.

To add headers and footers to the tops and bottoms of pages, click Headers & footers, and then check the boxes to choose which information to display.

If your spreadsheet contains a lot of data and cuts off in odd places, click SET CUSTOM PAGE BREAKS in the right panel. Here, you can drag the blue lines to adjust where each page begins and ends. Click CONFIRM BREAKS at the top-right to save your changes.

9. Click #EXPORT . It's the blue button at the top-right. This prompts you to save your new PDF to your computer.

If the download doesn't begin automatically, choose a location to which you'll save the PDF, and then click Save to download it.