建表sql带字段注释_如何在Excel中打印带有注释的工作表

短命女 2021-07-26 22:31 329阅读 0赞

![建表sql带字段注释][sql]

建表sql带字段注释

![00\_lead\_image\_printing\_comments][00_lead_image_printing_comments]

You’ve [added comments][] to your worksheet, and now you want to print it out–with those comments intact. However, Excel doesn’t print comments by default. Here are two ways to do it.

您已经在工作表中[添加了注释][added comments] ，现在您希望将这些注释完整地打印出来。 但是，默认情况下，Excel不打印注释。 这有两种方法。

Before printing comments on a worksheet, you must be sure the [comments are not hidden using these instructions][]. Once your comments are showing on the worksheet, click the “Page Layout” tab.

在工作表上打印注释之前，必须确保按照[以下说明隐藏注释][comments are not hidden using these instructions] 。 一旦您的评论显示在工作表上，请单击“页面布局”选项卡。

![01\_clicking\_page\_layout\_tab][01_clicking_page_layout_tab]

Click the “Sheet Page Setup” dialog button in the lower-right corner of the “Sheet Options” section of the “Page Layout” tab.

单击“页面布局”选项卡“页面选项”部分右下角的“页面设置”对话框按钮。

![02\_clicking\_sheet\_page\_setup\_button][02_clicking_sheet_page_setup_button]

The “Sheet” tab on the “Page Setup” dialog box automatically displays. To print comments on your worksheet, select an option from the “Comments” drop-down list in the “Print” section.

“页面设置”对话框上的“表格”选项卡将自动显示。 要在工作表上打印注释，请从“打印”部分的“注释”下拉列表中选择一个选项。

![03\_selecting\_as\_displayed\_on\_sheet][03_selecting_as_displayed_on_sheet]

To print the comments at the end of the worksheet on a separate sheet of paper, select the “At end of sheet” option. The comments are not linked to the cells, but the cell reference and the name of the person who wrote the comment are included with the comment. To print the comments as they are displayed on the screen, select the “As displayed on sheet” option. This option preserves any formatting applied to the comments when you print them, such as bold, underline, italics, and colors.

要将注释在工作表的末尾打印在另一张纸上，请选择“在末尾”选项。 注释未链接到单元格，但注释中包含了单元格引用和撰写注释者的姓名。 要在屏幕上显示注释时进行打印，请选择“在图纸上显示”。 此选项将保留在打印注释时应用于注释的所有格式，例如粗体，下划线，斜体和颜色。

Click “OK” to accept your change and close the dialog box. The next time you print this worksheet, any comments you have showing on the screen will print in the selected format.

单击“确定”接受更改并关闭对话框。 下次打印此工作表时，您在屏幕上显示的所有注释都将以选定的格式打印。

If you want to change the way comments are printed while on the “Print” backstage screen, right before printing the worksheet, click the “Page Setup” link. When opening the “Page Setup” dialog box from this location, the “Page” tab automatically displays. So, you will have to click the “Sheet” tab on the “Page Setup” dialog box to access it. Then, change the “Comments” setting and click “OK”.

如果要在“打印”后台屏幕上更改注释的打印方式，则在打印工作表之前，单击“页面设置”链接。 从此位置打开“页面设置”对话框时，将自动显示“页面”选项卡。 因此，您必须单击“页面设置”对话框上的“工作表”选项卡才能访问它。 然后，更改“注释”设置，然后单击“确定”。

![04\_clicking\_page\_setup\_on\_print\_page][04_clicking_page_setup_on_print_page]

The option you select in the “Comments” drop-down list is applied to each worksheet in your workbook separately, meaning if you turn it on for one worksheet, it will not be on for the other worksheets in the workbook. So, before selecting an option in the “Comments” drop-down list, make sure the worksheet containing the comments you want to print is the active sheet.

您在“注释”下拉列表中选择的选项将分别应用于工作簿中的每个工作表，这意味着如果为一个工作表打开了该选项，则该工作簿中的其他工作表将不会打开。 因此，在“注释”下拉列表中选择一个选项之前，请确保包含要打印注释的工作表是活动表。

> 翻译自: [https://www.howtogeek.com/243877/how-to-print-a-worksheet-with-comments-in-excel/][https_www.howtogeek.com_243877_how-to-print-a-worksheet-with-comments-in-excel]

建表sql带字段注释

[sql]: /images/20210726/11675e754b944b81a3b170549c4e6245.png
[00_lead_image_printing_comments]: /images/20210726/6fbcb2f5384f488b9a23e29a0d3befc6.png
[added comments]: https://www.howtogeek.com/162231/add-comments-to-formulas-and-cells-in-excel-2013/
[comments are not hidden using these instructions]: https://www.howtogeek.com/218633/how-to-hide-comments-formulas-overflow-text-and-gridlines-in-excel/
[01_clicking_page_layout_tab]: /images/20210726/e48b3818be0f4778aa8a8b1f67d5e955.png
[02_clicking_sheet_page_setup_button]: /images/20210726/b3b39666a3654e1e93158fff98644c0f.png
[03_selecting_as_displayed_on_sheet]: /images/20210726/0ba7a98ac24d4e60b17748d3789a7cd3.png
[04_clicking_page_setup_on_print_page]: /images/20210726/1adfaccee1df4ba89c6faeb67f751bb9.png
[https_www.howtogeek.com_243877_how-to-print-a-worksheet-with-comments-in-excel]: https://www.howtogeek.com/243877/how-to-print-a-worksheet-with-comments-in-excel/