Скачать или смотреть Convert Excel to PDF (All sheets, only specified number of pages, Selections, Table)

After the Excel document is made, if you want to publish it online, you can convert it to PDF, which can prevent copying on the one hand, and facilitate opening and browsing on the other hand.

Chapters:
0:00 Convert Excel to PDF
0:18 Convert All sheets to PDF
1:23 Publishes only the specified number of pages
1:55 Publish only Selections
2:25 Publish only Table

Description:

Convert Excel to PDF (All sheets, only specified number of pages, Selections, Table)

One. Convert Excel to PDF (only convert one sheet)

1. Use Excel to open the document you want to converte, select "File", click "Export" on the left in the window that opens, select "Create PDF/XPS Document" under "Export", click "Create PDF/XPS", open the "Publish as PDF or XPS" window, select the folder for saving the published PDF file, such as PDF (that is, F:\PDF), click "Publish" in the lower right corner of the window, and send it successfully and automatically open the PDF with the browser after a while.

2. Note: The time required to convert Excel to pdf depends on the size of the document, the larger the document, the longer it takes, and vice versa. The currently published Excel document is "Closthing 9-10 salse", it has multiple worksheets, but the default is only to publish one worksheet (that is, only publish the active worksheet, that is, the currently displayed worksheet), because there are few table records in it, so it is published at once. In addition, after successful publishing, whether it can be automatically opened depends on whether to check the "Open the file after publishing" and whether software that can open PDF files is installed on the computer; If it is checked first and installed, it can be turned on automatically, otherwise it cannot be.


Two. Convert All sheets to PDF

1. Use the shortcut keys Alt + F + E + A to open the "Publish as PDF or XPS" window. Press and hold Alt, pressing F, E and A once, open the "Publish to PDF or XPS" window, select the folder where the published as PDF is saved (for example, pdf), add 1 behind the file name "Closthing 9-10 salse" to distinguish the last published file; Click the "Options" button, open the "Options" window, select "Entire Workbook" under "Publish what", click "OK", and then click Publish, then publishing begins, and after a while, all workbooks in the document are published as PDF and open automatically.

2. Note: After converting to PDF, some tables have breakage, they break because they exceed the width of one page, so it is best to check if the table exceeds the page size before converting to PDF, here's how:

Select the "View" tab, click "Page Layout", and the part of the table that exceeds one page is divided into the next page.


Three. Parameter analysis for Excel convert to pdf

(1) Page range (Publishes only the specified number of pages, such as 5 to 12 pages)

There are All and Page for "Page Range", if we select "All", it wll publish all pages. If we select "Page", we must specify the number of pages to publish, for example, 5 to 12 pages.

Note: If you specify more pages than the last page of the document, Excel automatically publishes to the last page.


(2) Publish what

There are four options for "Publish what", Selection, Entire Workbook, Active Sheet and Table. It publishes only the selected content for "Selection"; It publishes all sheets for "Entire Workbook"; It publishes only the current worksheet (that is, the displayed worksheet) for "Active Sheet"; It publishes only tables that are created for "Table", and if no tables are created, it is grayed out and is not selectable. Here are additional examples of publishing only "Selection" and "Table", respectively:

1. Publish only Selections

A. Select the content you want to publish, for example, select the "Clothes, Price, SeptemberSales" three columns in the clothing list.

B. Press the shortcut Alt + F + E + A (the pressed key method is the same as above) to open the "Publish as PDF or XPS" window, click "Options" to open the window, select "Selection" for "Publish what".

C. Click "OK", and then click "Publish", and the publish will be completed. Only the selected "Clothes, Price, SeptemberSales" three columns were published.


2. Publish only Table

A. Select a created table, open the "Publish to PDF or XPS" window in the same way, click "Options" to open the window, at this time, the "Table" under "Publish what" is in the optional state, select it.

B. Click "OK" to return to the "Publish to PDF or XPS" window, click "Publish", and the Publish will be completed after a while.


(3) PDF options

The ISO 19005-1 standard (PDF/A)(1), issued by the International Organization for Standardization in October 2005, is "Document Management Electronic Document Formats Suitable for Long-Term Storage Part I: Using PDF1.4(PDF/A)(1)". Under PDF Options, it can be checked or unchecked.
Internet, usually choose the latter.