Saving an Excel spreadsheet as a PDF can be confusing, and the finished file often looks different from how we want it to be presented. Here’s how to save a sheet as a readable clean PDF file.
将Excel电子表格另存为PDF可能会造成混淆,并且最终文件的外观通常与我们希望其呈现方式不同。 以下是将工作表另存为可读的清晰PDF文件的方法。
Excel文件为PDF (Excel Files as PDFs)
There are many scenarios when you may want to save an Excel document as a PDF file instead of a spreadsheet. For example, if you wish to send out only a specific portion of a larger sheet, or you don’t want it to be editable. However, converting an Excel file to a PDF can be a bit tricky.
在许多情况下,您可能希望将Excel文档另存为PDF文件而不是电子表格。 例如,如果您只希望发送较大图纸的特定部分,或者您不希望它是可编辑的。 但是,将Excel文件转换为PDF可能有些棘手。
We often don’t think of Excel spreadsheets as documents with borders, pages, and margins. However, when it comes to turning these files into PDF documents that can be read, printed, or distributed to others, it’s something that you should be conscious of. Your file should be readable and understandable, without random stray columns on other pages or cell sizes that are too small to read.
我们通常不认为Excel电子表格是带有边框,页面和边距的文档。 但是,将这些文件转换为可以阅读,打印或分发给其他人的PDF文档时,您应该意识到这一点。 您的文件应易于阅读和理解,在其他页面上没有随机的杂散列,或者单元格大小太小而无法阅读。
Here’s how to turn your spreadsheet into a presentable and printable PDF document.
这是将电子表格转换为可显示和可打印的PDF文档的方法。
设置页面 (Setting Up the Page)
If you’re using Office or later, navigate to the Page Layout tab. Here, you’ll see several options grouped under the Page Setup section. Here are the first three:
如果您使用的是Office 或更高版本,请导航至“页面布局”选项卡。 在这里,您会看到“页面设置”部分下的几个选项。 这是前三个:
Margins:How large the whitespace is between the edge of a document and the first cell
边距:文档边缘和第一个单元格之间的空白量
Orientation:Whether you want your finished file to be in landscape or portrait
方向:是否要使完成的文件为横向或纵向
Size:The page size of your finished document
大小:完成文档的页面大小
These work mostly the same as they do in a Word document, so set them based on how you want your finished PDF to look like. Take note that most Excel spreadsheets are more readable in landscape orientation than in portrait, unless you have very few columns. Sheets that are saved in portrait tend to have columns that fall outside of the final print area, which can make your document very difficult to navigate and read.
这些工作原理与Word文档中的工作原理基本相同,因此请根据您希望最终PDF的外观进行设置。 请注意,除非列数很少,否则大多数Excel电子表格的横向可读性都比纵向更好。 以纵向保存的工作表中的列往往落在最终打印区域之外,这会使文档非常难以浏览和阅读。
Additionally, you can add a header and footer to your final layout. Click the arrow on the lower-right corner of the Page Setup section, then click on the Header/Footer tab. You can select one of Office’s generated options, or create one of your own by using the “Customize” feature.
此外,您可以在最终布局中添加页眉和页脚。 单击页面设置部分右下角的箭头,然后单击页眉/页脚选项卡。 您可以选择Office生成的选项之一,也可以使用“自定义”功能创建自己的选项之一。
You also have the option to change the background of your printout. To do this, click the Background button in Page Setup. You can select an image from your laptop or from the cloud, and this image will be tiled across your entire sheet.
您还可以选择更改打印输出的背景。 为此,请单击“页面设置”中的“背景”按钮。 您可以从笔记本电脑或云中选择图像,该图像将平铺在整个工作表中。
定义打印区域和配件 (Defining a Print Area and Fitting)
Next, you need to determine what area is going to be turned into a PDF, as well as how many rows and columns will be on each page.
接下来,您需要确定要将哪些区域转换为PDF,以及每页上将有多少行和多少列。
The first way to define the area is by using click and drag to select all the cells that you want in your document. Afterward, go to Page Setup > Print Area > Set Print Area. This will create a thin grey line around the entire area that will be printed. When you create your PDF, everything outside this area will not be included. You can also manually input the cells by clicking the arrow on the lower-left corner and going to Sheets > Print Area.
定义区域的第一种方法是通过单击并拖动以选择文档中所需的所有单元格。 然后,转到页面设置>打印区域>设置打印区域。 这将在要打印的整个区域周围产生一条细灰色线。 创建PDF时,将不包括该区域之外的所有内容。 您也可以通过单击左下角的箭头并转到“图纸”>“打印区域”来手动输入单元格。
Similar to Microsoft Word, you can also create page breaks to segment different tables. These page breaks can be both horizontal and vertical. Go to the cell where you want to place a page break, click the “Page Layout” tab on the ribbon, and select Page Setup > Page Breaks > Insert Page Break. This will create a break right above and to the left of your current cell.
与Microsoft Word相似,您也可以创建分页符以分割不同的表。 这些分页符可以是水平的也可以是垂直的。 转到要放置分页符的单元格,单击功能区上的“页面布局”选项卡,然后选择“页面设置”>“分页符”>“插入分页符”。 这将在当前单元格的上方和左侧创建一个中断。
Another important thing to do is to define the Scale to Fit option. To the right of Page Setup, you’ll see three options: Width, Height, and Scale. The Width and Height options allow you to set how many pages the rows or columns of your table will appear in. For example, if you have a lot of rows but just a few columns, setting the Width to one page is ideal. Scale, on the other hand, will determine the overall resizing of your entire print area.
要做的另一件事是定义“缩放以适合”选项。 在“页面设置”右侧,您会看到三个选项:“宽度”,“高度”和“比例”。 “宽度”和“高度”选项使您可以设置表的行或列将显示多少页。例如,如果您有很多行而只有几列,则将“宽度”设置为一页是理想的。 另一方面,缩放比例将决定整个打印区域的整体大小。
工作表选项 (Sheet Options)
The last menu you should pay attention to is Sheet Options. These are settings that affect the appearance of your final printed sheet. To access the full sheet options, click on the arrow on the lower-left corner ofSheet Options sections.
您应注意的最后一个菜单是“图纸选项”。 这些设置会影响最终打印纸的外观。 要访问完整的图纸选项,请单击“图纸选项”部分左下角的箭头。
Here’s an overview of the various customizations you can do in this menu:
这是您可以在此菜单中进行的各种自定义的概述:
Print Titles:You can freeze specific rows and columns of the sheet in place so that they appear on every page, such as headers and labels.
打印标题:您可以将工作表的特定行和列冻结在适当的位置,以便它们出现在每一页上,例如标题和标签。
Gridlines:This lets you set whether or not to show gridlines, which are the lines between cells that appear when there’s no border painted on them.
网格线:这使您可以设置是否显示网格线,即在单元格之间未绘制边框时显示的单元格之间的线。
Headings:This allows you do display headings, which are the fixed alphabetical (A, B, C) and numerical (1, 2, 3) labels on the x-axis and y-axis of Excel spreadsheets.
标题:您可以显示标题,这些标题是Excel电子表格的x轴和y轴上固定的字母(A,B,C)和数字(1、2、3)标签。
Comments, Notes, and Errors:This displays theembedded comments, notes, and error warnings in the final document.
注释,注释和错误:这将在最终文档中显示嵌入的注释,注释和错误警告。
Print Order:This lets you set whether to create a document going down first or going right first.
打印顺序:这使您可以设置创建文档的顺序是先降还是后降。
In this menu, you can go to the Print Preview screen, where you can get a glimpse of your final document. You can also go to the screen with the shortcut Ctrl+P.
在此菜单中,您可以转到“打印预览”屏幕,在其中可以浏览最终文档。 您也可以使用快捷键Ctrl + P转到屏幕。
保存或打印为PDF (Saving or Printing as PDF)
With your document correctly formatted and all set to go, there are two ways you can create a PDF.
在正确格式化文档并准备就绪后,可以通过两种方式创建PDF。
To save the file as a PDF in Excel, open the Save As dialog, and select PDF from the “Save as type” dropdown menu. Alternatively, you can go to Export > Export to XPS/PDF. From here, you have a few options. You can decide whether to optimize the file for Standard or Minimum, which will determine the final quality and filesize of the document. You can then click “Options” to select the area to publish:
要将文件另存为Excel中的PDF,请打开“另存为”对话框,然后从“另存为类型”下拉菜单中选择PDF。 或者,您可以转到导出>导出到XPS / PDF。 从这里,您可以选择几种方式。 您可以决定是针对标准文件还是最小文件优化文件,这将决定文件的最终质量和文件大小。 然后,您可以单击“选项”以选择要发布的区域:
Selection:The current cells you have selected
选择:您选择的当前单元格
Active Sheets:The current sheet that you’re in
活动工作表:您当前所在的工作表
Entire Workbooks:All the workbooks in the current file you’re working on
整个工作簿:您正在处理的当前文件中的所有工作簿
Table:A defined table that you’ve created via Microsoft Excel
表格:您通过Microsoft Excel创建的已定义表格
You can also opt to ignore the print area you’ve set entirely.
您还可以选择忽略整个设置的打印区域。
You could also print the file as a PDF. Microsoft has a built-in PDF printercalled Microsoft Print to PDF that you can select in the printer dropdown menu. If you have another PDF drive, such as Adobe PDF, Foxit, or PDF Xchange, you can use one of those as well. Before you click “Print”, look through your print preview to make sure everything looks correct.
您也可以将文件打印为PDF。 Microsoft具有内置的称为Microsoft Print to PDF的PDF打印机,您可以在打印机下拉菜单中选择。 如果您有另一个PDF驱动器,例如Adobe PDF,Foxit或PDF Xchange,则也可以使用其中之一。 在单击“打印”之前,请仔细查看打印预览,以确保所有内容均正确无误。
翻译自: /659219/how-to-save-an-excel-sheet-as-a-pdf/