November 23, 2022


Microsoft Excel logo on a green background

To export a cell vary as a PDF, first choose the vary along with your cursor or utilizing keyboard shortcuts. Choose File > Export > Create PDF/XPS Doc. On Home windows, click on the “Choices” button and select “Choice” or “Total Workbook” beneath “Publish What.” On a Mac, these choices are displayed on the backside of the save dialog.

If you wish to share information from Excel with out sharing the Excel file, you’ll be able to export a number of cells or the entire workbook as a PDF. The result’s a brilliant useful doc you’ll be able to share any approach you need.

Export an Excel Cell Vary as a PDF on Home windows

You probably have a specific cell vary you need to export to a PDF, you are able to do this in just some steps.

RELATED: How to Send Word, Excel, or PowerPoint Files as a PDF

Choose the cells you need to export. You are able to do this by dragging your cursor by way of adjoining cells or holding Ctrl as you choose non-adjacent cells.

Understand that in case you select non-adjacent cells, they might show on separate pages within the PDF doc.

Selected cell range in Excel

Go to the File tab and choose “Export” on the left aspect. On the suitable, choose “Create PDF/XPS Doc” and click on the Create PDF/XPS button.

Create a PDF or XPS Document in the Export section of Excel

When the Publish as PDF or XPS window opens, select a location to avoid wasting the file. Optionally modify the file identify and ensure that PDF is chosen within the Save as Kind drop-down field. Then, choose “Choices.”

Publish box for location, name, and options

Within the Choices window, choose “Choice” within the Publish What part. Click on “OK” within the Choices window after which “Publish” within the Publish as PDF or XPS window.

Publish Options window to pick Selection

Navigate to the situation the place you saved the PDF to entry the file.

Exported PDF file with selected cells from Excel

Export an Excel Workbook as a PDF on Home windows

Perhaps you need to export your entire workbook as a PDF file. You are able to do this by following the identical primary steps as above for exporting a cell vary.

Earlier than you start, needless to say you gained’t have an choice to pick out the web page breaks forward of time. By default, sheets with a variety of information carry over to the opposite pages. If you’d like one sheet per web page, check out our how-to for inserting page breaks in Excel first.

RELATED: How to Insert, Edit, or Remove Page Breaks in Microsoft Excel

While you’re able to export your Excel workbook, go to the File tab and choose “Export” on the left. On the suitable, choose “Create PDF/XPS Doc” and click on the Create PDF/XPS button.

Create a PDF or XPS Document in the Export section of Excel

Select a file location, optionally modify the file identify, and ensure that PDF is chosen within the Save as Kind drop-down field. Then, choose “Choices.”

Publish box for location, name, and options

Under Publish What, choose “Total Workbook.” To disregard any print areas you’ve arrange within the workbook, make sure you test that field in the identical part. You may then use the Web page Vary and different areas and choices as wanted.

Publish Options window to pick Entire Workbook

Click on “OK” within the Choices window and “Publish” within the Publish as PDF or XPS window. Then, go to the situation the place you saved the PDF file to open it.

Exported PDF for a workbook from Excel

Save Excel to a PDF on Mac

Like on Home windows, you’ll be able to flip a number of cells or a workbook right into a PDF on Mac. The steps are barely totally different from these above.

While you open the workbook, select a sheet and choose the cells if you wish to export a cell vary. To save lots of your entire workbook as a PDF, merely open it.

Choose File > Save As within the menu bar. When the window seems, select a location and optionally modify the filename. Then, choose “PDF” within the File Format drop-down field.

Save As box for Excel to PDF on Mac

To export the cell vary, select “Choice” which shows the chosen cells so that you can affirm. To export your entire workbook, select “Workbook.”

Workbook and Selection options for a PDF from Excel on Mac

Choose “Save” once you end, after which head to your chosen location to entry the PDF.

Whether or not you need to share a part of your Excel sheet or again up a particular model of a workbook, exporting it to a PDF file is a stable choice.

For extra, take a look at methods to insert a PDF into Excel or methods to import data from a PDF into your workbook.



Source link

Leave a Reply

Your email address will not be published.