excel页码编号打印_Excel编号以供打印

excel页码编号打印

If you add comments to an Excel worksheet, you might want to include those comments when printing. There are a couple of built in options for printing comments, but neither is ideal. We'll look at those, then a numbering system, that's similar to numbered footnotes.

如果将注释添加到Excel工作表中，则可能需要在打印时包括这些注释。 有两个用于打印注释的内置选项，但都不是理想选择。 我们先看一下那些编号系统，类似于编号的脚注。

内置选项 (The Built In Options)

In the Page Setup dialog box, on the Sheet tab, there are 3 options for printing the comments:

在“页面设置”对话框的“图纸”选项卡上，有3个用于打印注释的选项：

• (None)
  (没有)
• At end of sheet
  工作表末
• As displayed on sheet
  如表所示

If you select At end of sheet, a separate page of comments prints, listing the cell address, commenter name and comment text.

如果选择在表格末尾 ，将打印单独的评论页面，列出单元格地址，评论者名称和评论文本。

If you select As displayed on sheet, the comment that are currently visible on the worksheet will print, exactly as they appear on screen.

如果选择“ 在图纸上显示为” ，则将打印工作表上当前可见的注释，它们与屏幕上显示的完全相同。

That might work if there are a couple of comments that you want to show, and can arrange them over an empty space. Otherwise, you'll end up with a jumbled mess of comments, covering your data.

如果要显示几个注释，并且可以将它们排列在空白处，则可能会起作用。 否则，您将得到混乱的注释，覆盖数据。

将数字添加到带有注释的单元格中 (Add Numbers to Cells With Comments)

Instead of using either of the built in options to print comments, you could use a bit of programming to add a tiny number at the top right of each cell that has a comment. Here's a close up view of the numbered cells.

不必使用任何内置选项来打印注释，您可以使用一些编程来在每个带有注释的单元格的右上角添加一个小数字。 这是编号单元格的特写视图。

列出编号的注释 (List the Numbered Comments)

With another bit of programming, you can create a numbered list of the comments, with other details, such as range name, cell value, cell address and comment text.

通过另一编程，您可以创建带注释的编号列表，并带有其他详细信息，例如范围名称，单元格值，单元格地址和注释文本。

This list is on a separate worksheet, that you can print when you print the sheet with comments.

此列表位于单独的工作表上，当您打印带有注释的表时可以打印该列表。

下载样本文件 (Download the Sample File)

To download the sample file for Excel 2003 or Excel 2007/2010, go to the Number and List Comments section on the Comments programming page. There's sample code to add numbers, remove numbers and list the comments, and a zipped sample file that you can download.

要下载Excel 2003或Excel 2007/2010的示例文件，请转到“注释”编程页上的“ 编号和列表注释”部分。 有用于添加数字，删除数字和列出注释的示例代码，以及可以下载的压缩示例文件。

The Excel 2003 numbering code didn't work well in Excel 2007. The numbers didn't appear in some boxes, and the boxes didn't line up correctly in the cells. So if you're using Excel 2007, be sure to download that version's sample file

Excel 2003编号代码在Excel 2007中不能很好地工作。数字没有出现在某些框中，并且这些框在单元格中未正确对齐。 因此，如果您使用的是Excel 2007，请确保下载该版本的示例文件

Both files contain macros, so you may get a warning when you open them. Enable the macros if you want to run the code. __________

这两个文件都包含宏，因此打开它们时可能会收到警告。 如果要运行代码，请启用宏。 __________

翻译自: https://contexturesblog.com/archives/2009/08/19/number-excel-comments-for-printing/

excel页码编号打印