I have an excel sheet with too many columns, so when I save it as a PDF the file its in too many pages and its not easy to read . I need to save the sheet as pdf but before I want to change its orientation to horizontal so I can read the pdf with no problem. Is the same you can do when you print but I want it when I save an excel file as pdf. Is there any option I can choose?
我有一个包含太多列的excel表,所以当我将它保存为PDF文件时,它的页面太多而且不易阅读。我需要将工作表保存为pdf,但在我想将其方向更改为水平之前,我可以毫无问题地阅读pdf。打印时你可以做同样的事情,但是当我将excel文件保存为pdf时我想要它。有什么选择我可以选择吗?
I dont mind if someone gives me a code for a macro using my selection as an object.
2 个解决方案
#1
Under the "Page Layout" tab, click the "Orientation" option and then select "Landscape."
在“页面布局”选项卡下,单击“方向”选项,然后选择“横向”。
Then create your PDF as usual.
然后像往常一样创建PDF。
#2
You can save Excel files in PDF, even without using Excel. I use a program Universal Document Converter (http://www.print-driver.com/how-to/save-excel-as-pdf). This program allows you to quickly and easily create print-ready PDF-files on the basis of the original spreadsheets Excel.
即使不使用Excel,也可以将Excel文件保存为PDF。我使用程序Universal Document Converter(http://www.print-driver.com/how-to/save-excel-as-pdf)。该程序允许您基于原始电子表格Excel快速轻松地创建可打印的PDF文件。
#1
Under the "Page Layout" tab, click the "Orientation" option and then select "Landscape."
在“页面布局”选项卡下,单击“方向”选项,然后选择“横向”。
Then create your PDF as usual.
然后像往常一样创建PDF。
#2
You can save Excel files in PDF, even without using Excel. I use a program Universal Document Converter (http://www.print-driver.com/how-to/save-excel-as-pdf). This program allows you to quickly and easily create print-ready PDF-files on the basis of the original spreadsheets Excel.
即使不使用Excel,也可以将Excel文件保存为PDF。我使用程序Universal Document Converter(http://www.print-driver.com/how-to/save-excel-as-pdf)。该程序允许您基于原始电子表格Excel快速轻松地创建可打印的PDF文件。