Current location - Loan Platform Complete Network - Big data management - Excel table has too many columns, converted to PDF, the columns are not on the same page. It is difficult to see, how to make all the columns are in a page pdf?
Excel table has too many columns, converted to PDF, the columns are not on the same page. It is difficult to see, how to make all the columns are in a page pdf?

You can print in the EXCEL print mode will be set to store the PDF format, and then reduce the proportion of its reduction in the size of the need to complete the effect of displaying a PDF page. Specific settings are as follows:

1, in the open EXCEL file click on the open preview button.

2, at this point in the print preview to see the document has 2 pages, while a column in the second page of the form.

3, click on the upper left corner of the page settings to enter.

4, in the page setup will appear in the zoom ratio is set to 70% after clicking OK.

5, at this time you can see the previous two pages of the preview has been set to one page.

6, click the page in the upper left corner of the print button.

7, in the pop-up print dialog box, click the drop-down printer, select TO PDF option and click OK button.

8, at this point you can see the pop-up dialog con for printout to PDF format, click the Save button.

9, save the file is completed after opening the PDF file.

10, in the open PDF file can be seen by the EXCEL generated by a page file.

11, in the page click on the button to zoom in to see the corresponding file content.