excel公式单元格注释_向Excel 2013中的公式和单元格添加注释

excel公式单元格注释

When entering formulas in Excel, you may want to remind yourself, or someone else, what it was for in the future. Or you may want to add instructions to let users of your spreadsheet know what to do in certain cells.

在Excel中输入公式时，您可能想提醒自己或其他人将来的用途。 或者，您可能想要添加说明，以使电子表格的用户知道在某些单元格中要做什么。

We will show you how to add a comment to a formula and a comment that displays when you move your mouse over a cell.

我们将向您展示如何在公式中添加注释以及将鼠标移到单元格上方时显示的注释。

在公式中添加注释 (Add a Comment to a Formula)

The N() function allows you add comments directly inside your cells on your formulas. To use the function to add a comment, simply add a plus sign (+) to the end of your formula, and then enter some text in quotes inside the parentheses, passing that text to the N() function.

N()函数使您可以直接在公式的单元格内部添加注释。 要使用该函数添加注释，只需在公式的末尾添加一个加号(+)，然后在括号内的引号中输入一些文本，然后将该文本传递给N()函数。

When you select the cell, the comment shows as part of the formula in the Formula bar.

选择单元格时，注释将显示为“公式”栏中的公式的一部分。

在单元格中添加评论 (Add a Comment to a Cell)

You can also add a comment to a cell that displays when you move your mouse over that cell. This is helpful if you want to provide help for the users of your spreadsheet, informing them of how to use specific parts of your spreadsheet.

您也可以在将鼠标移到该单元格上时显示的单元格中添加注释。 如果您想为电子表格的用户提供帮助，告知他们如何使用电子表格的特定部分，这将很有帮助。

We will use the function that generates a random number between a range of numbers as an example. Enter the following formula in a cell in your spreadsheet.

我们将以在数字范围之间生成随机数的函数为例。 在电子表格的单元格中输入以下公式。

=RANDBETWEEN(1, 49)

= RANDBETWEEN(1，49)

This function will generate a random number between 1 and 49.

此函数将生成1到49之间的随机数。

If you don’t have automatic calculation on, you have to click Calculate Now in the Calculation section of the Formula tab (or press F9) to generate a new random number.

如果没有启用自动计算 ，则必须单击“公式”选项卡的“计算”部分中的“立即计算”(或按F9键)以生成新的随机数。

To add a comment to the cell that lists the steps for generating a new random number, select the cell and click the Review tab.

要将注释添加到列出生成新随机数的步骤的单元格中，请选择该单元格，然后单击“审阅”选项卡。

In the Comments section of the Review tab, click New Comment.

在“审阅”选项卡的“评论”部分中，单击“新建评论”。

A sticky note-style box displays pointing at the selected cell. By default, the user name of the current user is entered into the comment box, but you can delete this text or change it to something else. Enter any additional desired text into the comment box. You can resize the comment box using the small, outlined box handles along the edge.

便签样式框显示指向所选单元格。 默认情况下，当前用户的用户名会输入到注释框中，但是您可以删除此文本或将其更改为其他内容。 在注释框中输入任何其他所需的文本。 您可以使用边缘上的小轮廓框手柄来调整注释框的大小。

Once you have entered your text, click on any other cell outside of the comment box. The cell now contains a small, red triangle in the upper, right corner, indicating a comment has been added to it.

输入文字后，请在评论框外单击任何其他单元格。 现在，该单元格的右上角包含一个红色的小三角形，表示已添加注释。

When you move your mouse over the cell, the comment box displays.

当您将鼠标移到单元格上方时，将显示注释框。

To remove a comment from a cell, right-click on the cell and select Delete Comment from the popup menu.

要从单元格中删除评论，请右键单击该单元格，然后从弹出菜单中选择“删除评论”。

Comments are a convenient way of documenting your spreadsheet both for your own reference and as “context-sensitive help” for users of your spreadsheet.

注释是记录电子表格的便捷方法，既可以供您自己参考，也可以作为电子表格用户的“上下文相关帮助”。

翻译自: https://www.howtogeek.com/162231/add-comments-to-formulas-and-cells-in-excel-2013/

excel公式单元格注释