![excel公式单元格注释](https://i-blog.csdnimg.cn/blog_migrate/e42845357b5290f7cb891439547e68d1.png)
excel公式单元格注释
![00_lead_image_hiding_comments](https://i-blog.csdnimg.cn/blog_migrate/d1d98b68d9e8dfe1f5295a46ac7c8611.png)
We’ve shown you how to hide cells, rows, and columns and how to hide worksheets/tabs and entire workbooks in Excel. Additionally, you can hide items such as comments, formulas, overflow text, and gridlines. We’ll show you how to hide these items.
我们已经向您展示了如何在Excel中隐藏单元格,行和列,以及如何隐藏工作表/选项卡和整个工作簿。 此外,您可以隐藏诸如注释,公式,溢出文本和网格线之类的项目。 我们将向您展示如何隐藏这些项目。
隐藏评论 (Hide Comments)
When you add a comment to a cell in Excel, a small red triangle displays in the upper-right corner of the cell to indicate a comment was added. When you hover your mouse over the cell, or select the cell, the comment displays in a popup window.
当您向Excel中的单元格添加注释时,该单元格的右上角会显示一个红色小三角形,表示已添加注释。 将鼠标悬停在单元格上方或选择该单元格时,注释将显示在弹出窗口中。
![25_comment_in_a_cell](https://i-blog.csdnimg.cn/blog_migrate/3cdc07df34622d81e7576e2edcdc83f9.png)
If you have a lot of comments in your worksheet, you may not want to see the red triangles and have comments popup as you move your mouse around the worksheet. To hide the comments, click the “File” tab.
如果您的工作表中有很多注释,则可能不希望看到红色三角形,并且在工作表上移动鼠标时会弹出注释。 要隐藏评论,请单击“文件”选项卡。
![26_clicking_the_file_tab](https://i-blog.csdnimg.cn/blog_migrate/41231f48a2d7c055d1a5ed2bf757553c.png)
On the backstage screen, click “Options” in the list of items on the left.
在后台屏幕上,单击左侧项目列表中的“选项”。
![27_clicking_options](https://i-blog.csdnimg.cn/blog_migrate/e98f0ffdc0b923f6658e886413469c7d.png)
On the “Excel Options” dialog box, click “Advanced” in the list of items on the left.
在“ Excel选项”对话框中,在左侧的项目列表中单击“高级”。
![28_clicking_advanced](https://i-blog.csdnimg.cn/blog_migrate/2671797de6cd50a0fdb131fe69f86b87.png)
Scroll down to the “Display” section. Under “For cells with comments, show”, select the “No comments or indicators” radio button.
向下滚动到“显示”部分。 在“对于带有注释的单元格,显示”下,选择“无注释或指示符”单选按钮。
![29_selecting_no_comments_or_indicators](https://i-blog.csdnimg.cn/blog_migrate/ef7fc34cd556d703d837d5cfa11a761f.png)
Click “OK” to accept the change and close the “Excel Options” dialog box.
单击“确定”接受更改,然后关闭“ Excel选项”对话框。
![30_clicking_ok_on_options_dialog](https://i-blog.csdnimg.cn/blog_migrate/7c6219677675546f236b656bcecb46a3.png)
The red triangles and comment popup windows are now hidden.
现在隐藏了红色三角形和注释弹出窗口。
![31_no_comment_showing](https://i-blog.csdnimg.cn/blog_migrate/45e2d90663a74ab51eac54e9a3a4629d.png)
The comments are still associated with their respective cells and can be viewed by clicking the “Review” tab and clicking “Show All Comments” in the “Comments” section.
这些评论仍与它们各自的单元格关联,可以通过单击“评论”选项卡并单击“评论”部分中的“显示所有评论”来查看。
![32_clicking_show_all_comments](https://i-blog.csdnimg.cn/blog_migrate/3dc9b0aa102a66e7b3fec10113a63dbb.png)
All the comments in your worksheet are displayed without having to hover over the cells. To hide the comment popup windows, click “Show All Comments” again. The comment popup windows are hidden but the red triangles remain visible.
将显示工作表中的所有注释,而无需将鼠标悬停在单元格上。 要隐藏评论弹出窗口,请再次单击“显示所有评论”。 注释弹出窗口被隐藏,但红色三角形仍然可见。
NOTE: If you want to show or hide a comment for a certain cell, select that cell and click “Show/Hide Comment” in the “Comments” section of the “Review” tab. You can select multiple cells with comments using the “Ctrl” key to show or hide the comments on those cells only.
注意:如果要显示或隐藏某个单元格的评论,请选择该单元格,然后在“审阅”选项卡的“评论”部分中单击“显示/隐藏评论”。 您可以使用“ Ctrl”键选择多个带有注释的单元格,以仅显示或隐藏这些单元格上的注释。
![33_all_comments_showing](https://i-blog.csdnimg.cn/blog_migrate/62292306f8c95992ffd769d1acb46d26.png)
Clicking the “Show All Comments” button so it toggles off changes the “For cells with comments, show” option back to “Indicators only, and comments on hover” automatically.
单击“显示所有注释”按钮以将其关闭,从而将“对于带注释的单元格,显示”选项自动变回“仅指示器,并且悬停时注释”。
隐藏公式 (Hide Formulas)
There are two things you need to do to hide a formula. First, you must apply the “Hidden” setting to the cell and then protect the worksheeet.
隐藏公式需要做两件事。 首先,您必须将“隐藏”设置应用于单元格,然后保护工作表。
Select the cell for which you want to hide the formula and right-click on the selected cell. Select “Format Cells” from the popup menu.
选择要为其隐藏公式的单元格,然后右键单击所选的单元格。 从弹出菜单中选择“格式化单元格”。
NOTE: You can select multiple cells and hide the formulas for all the selected cells.
注意:您可以选择多个单元格并隐藏所有选定单元格的公式。
![17_selecting_format_cells_hide_formulas](https://i-blog.csdnimg.cn/blog_migrate/b27ca998caf80fe6eab1bc39d1af457f.png)
Click the “Protection” tab on the “Format Cells” dialog box, and select the “Hidden” check box so there is a check mark in the box. Click “OK” to accept the change and close the dialog box.
单击“设置单元格格式”对话框上的“保护”选项卡,然后选择“隐藏”复选框,以便在该复选框中有一个复选标记。 单击“确定”接受更改并关闭对话框。
![18_selecting_hidden](https://i-blog.csdnimg.cn/blog_migrate/6baf7b99310940ec034e4bd9a8f94342.png)
The formulas won’t be hidden until you protect the sheet. To do this, click the “Review” tab and click “Protect Sheet” in the “Changes” section.
在保护工作表之前,公式不会隐藏。 为此,请单击“审阅”选项卡,然后在“更改”部分中单击“保护表”。
![19_clicking_protect_sheet](https://i-blog.csdnimg.cn/blog_migrate/6daf5fed3e6d70cb5e0dffadcebeffe7.png)
The “Protect Sheet” dialog box displays. To prevent other users from unhiding the formulas, enter a password in the “Password to unprotect sheet” edit box. Specify the actions you want to allow users to perform on the worksheet by selecting check boxes in the “Allow all users of this worksheet to” list. Click “OK” to accept your changes and close the dialog box.
显示“保护表”对话框。 为防止其他用户取消隐藏公式,请在“取消保护工作表的密码”编辑框中输入密码。 通过选中“允许此工作表的所有用户访问”列表中的复选框,指定要允许用户在工作表上执行的操作。 单击“确定”接受更改并关闭对话框。
NOTE: The password is not required, but we recommend you enter one if you don’t want other users to be able to unprotect the worksheet.
注意:不需要密码,但是如果您不希望其他用户能够取消保护工作表,我们建议您输入一个。
![20_protect_sheet_dialog](https://i-blog.csdnimg.cn/blog_migrate/02c4b327148bb44af1bb7cc9e2d0a239.png)
A dialog box displays asking you to confirm your password.
出现一个对话框,要求您确认密码。
![21_confirm_password](https://i-blog.csdnimg.cn/blog_migrate/805f0f2e51b9005d7ce6edc1cc325cdd.png)
The formulas in the selected cells do not display in the Formula Bar, but the results of the formulas remain visible in the cells. If you entered a password when protecting the sheet, other users will not be able to use the “Show Formulas” button on the “Formulas” tab to display all the formulas in the worksheet.
所选单元格中的公式不会显示在“公式栏”中,但是公式的结果在单元格中仍然可见。 如果在保护工作表时输入了密码,其他用户将无法使用“公式”选项卡上的“显示公式”按钮来显示工作表中的所有公式。
![22_formula_not_showing](https://i-blog.csdnimg.cn/blog_migrate/738ef4f23fef200de2350e74cbe80ec5.png)
To unhide the formulas, click “Unprotect Sheet” in the “Changes” section of the “Review” tab.
要取消隐藏公式,请在“审阅”选项卡的“更改”部分中单击“取消保护工作表”。
![23_clicking_unprotect_sheet](https://i-blog.csdnimg.cn/blog_migrate/70404e0f5b06b3c0552b53c30a7c7a69.png)
If you entered a password when protecting the sheet, the “Unprotect Sheet” dialog box displays, prompting you for the password. Enter the password in the “Password” edit box and click “OK”. If you didn’t enter a password when protecting the sheet, the sheet will be unprotected with no further prompts.
如果在保护工作表时输入密码,则会显示“取消保护工作表”对话框,提示您输入密码。 在“密码”编辑框中输入密码,然后单击“确定”。 如果在保护工作表时未输入密码,则工作表将不受保护,不会再显示任何提示。
![24_unprotect_sheet_dialog](https://i-blog.csdnimg.cn/blog_migrate/75864ce8c9bf0f4619c3a1b8b000caac.png)
Select the cells for which you hid the formulas, right-click on the cells, and select “Format Cells” from the popup menu. Deselect the “Hidden” option on the “Protection” tab of the “Format Cells” dialog box so there is NO check mark in the box.
选择要为其隐藏公式的单元格,右键单击这些单元格,然后从弹出菜单中选择“设置单元格格式”。 在“设置单元格格式”对话框的“保护”选项卡上取消选择“隐藏”选项,因此该框中没有复选标记。
Another way to hide formulas from other users is to convert the formulas to static values and save the workbook with a different filename. Then, distribute this new workbook to the users.
对其他用户隐藏公式的另一种方法是将公式转换为静态值,然后使用其他文件名保存工作簿。 然后,将此新工作簿分发给用户。
隐藏溢出文字 (Hide Overflow Text)
When you type a lot of text into a cell in Excel, it overflows over to the adjacent cells. For example, the text entered into cell A1 in the image below overflows into cells B1 through E1.
当您在Excel中的单元格中键入大量文本时,它将溢出到相邻的单元格中。 例如,下图中输入到单元格A1中的文本溢出到单元格B1至E1中。
![34_overflowing_text](https://i-blog.csdnimg.cn/blog_migrate/333fdb77e79380ebc38e2e289b5120f3.png)
If we type text into cell B1, the overflow text from cell A1 is blocked by the text in cell B1.
如果我们在单元格B1中键入文本,则来自单元格A1的溢出文本将被单元格B1中的文本阻止。
![35_text_blocking_another_cells_overflow](https://i-blog.csdnimg.cn/blog_migrate/800db73bfce8e86bc4690222f234595b.png)
If you want to hide the overflow text in a cell, such as A1 in this example, without having to type anything into the adjacent cells, right-click on the cell and select “Format Cells” from the popup menu.
如果要在单元格(例如本示例中的A1)中隐藏溢出文本,而不必在相邻的单元格中键入任何内容,请右键单击该单元格,然后从弹出菜单中选择“格式化单元格”。
![36_selecting_format_cells_for_overflow](https://i-blog.csdnimg.cn/blog_migrate/c5911f4d66304dd8e378f5d05f7c52ac.png)
On the “Format Cells” dialog box, click the “Alignment” tab. Select “Fill” from the “Horizontal” drop-down list. Click “OK” to accept the change and close the dialog box.
在“设置单元格格式”对话框中,单击“对齐”选项卡。 从“水平”下拉列表中选择“填充”。 单击“确定”接受更改并关闭对话框。
![37_selecting_fill_text_alignment](https://i-blog.csdnimg.cn/blog_migrate/d60782ef803024e2eb32c722fbe07aaa.png)
The overflow text from cell A1 is hidden even though there is no text in cell B1.
即使单元格B1中没有文本,也会隐藏来自单元格A1的溢出文本。
![38_overflow_text_hidden](https://i-blog.csdnimg.cn/blog_migrate/f8392814942c4bcdf43595fb75639f1e.png)
You can prevent text from overflowing to adjacent cells using the “Wrap Text” feature. Select the cell containing overflowing text and access the “Format Cells” dialog box as described earlier in this article. Click the “Alignment” tab and select the “Wrap text” check box so there is a check mark in the box. Click “OK” to accept the change and close the dialog box.
您可以使用“自动换行”功能防止文本溢出到相邻的单元格中。 选择包含溢出文本的单元格,然后访问本文前面所述的“设置单元格格式”对话框。 单击“对齐方式”选项卡,然后选择“自动换行”复选框,以便该复选框中有一个复选标记。 单击“确定”接受更改并关闭对话框。
![39_selecting_wrap_text](https://i-blog.csdnimg.cn/blog_migrate/7b15a84c7a318fc9904643435be9163b.png)
When you choose to wrap text in a cell, the cell height is adjusted to accommodate the text. If you want to keep the row height at the standard value (15) for a single line of text, right-click on the row number and select “Row Height” from the popup menu.
当您选择在单元格中换行时,将调整单元格的高度以容纳文本。 如果要将单行文本的行高保持在标准值(15),请右键单击行号,然后从弹出菜单中选择“行高”。
![40_selecting_row_height](https://i-blog.csdnimg.cn/blog_migrate/dfcfb1da33bdbc6c426d4b200ad52ad6.png)
On the “Row Height” dialog box, type “15” in the edit box and click “OK”.
在“行高”对话框中,在编辑框中键入“ 15”,然后单击“确定”。
![41_setting_row_height](https://i-blog.csdnimg.cn/blog_migrate/1fbc44bcaa5105c769c7dec63ef990b9.png)
The row height is adjusted and the remaining text that doesn’t fit on the first line appears to be hidden.
调整行高,第一行不适合的其余文本似乎被隐藏了。
![42_row_height_adjusted](https://i-blog.csdnimg.cn/blog_migrate/d4f0519d64bbbf8d39195b79b72daeb3.png)
If you don’t change the “Row Height” back to its original value and you turn off the “Wrap text” feature, you’ll notice that the text now takes up only one line but the height of the row remains the same as it was when it adjusted to accommodate the wrapped text. You can either set the “Row Height” to “15” or you can automatically adjust the row height to fit the one line of text using the “AutoFit Row Height” feature. Make sure the “Home” tab is the active tab on the ribbon and click “Format” in the “Cells” section. Select “AutoFit Row Height” in the “Cell Size” section on the drop-down menu.
如果您没有将“行高”更改回其原始值,而是关闭了“换行文字”功能,则会注意到该文本现在仅占据一行,但行高与它是在进行调整以适应换行的文本时。 您可以将“行高”设置为“ 15”,也可以使用“自动调整行高”功能自动调整行高以适合一行文本。 确保“主页”选项卡是功能区上的活动选项卡,然后在“单元格”部分中单击“格式”。 在下拉菜单的“单元格大小”部分中选择“自动调整行高”。
![43_selecting_autofit_row_height](https://i-blog.csdnimg.cn/blog_migrate/ff03b8dcf7326619810511922312cf5a.png)
隐藏网格线 (Hide Gridlines)
If you are displaying your worksheet in a presentation, you can hide the gridlines to make the presentation of the data in your worksheet cleaner. There are a couple of different methods you can use to hide all the gridlines in a worksheet. For the first method, click the “View” tab.
如果要在演示文稿中显示工作表,则可以隐藏网格线以使工作表中的数据演示更加整洁。 您可以使用两种不同的方法来隐藏工作表中的所有网格线。 对于第一种方法,请单击“查看”选项卡。
![07_clicking_view_tab](https://i-blog.csdnimg.cn/blog_migrate/1d676a61ff7d7650e34216bd51c63388.png)
Select the “Gridlines” check box in the “Show” section so there is NO check mark in the box.
选中“显示”部分中的“网格线”复选框,以便该框中没有复选标记。
![08_clicking_gridlines_on_view_tab](https://i-blog.csdnimg.cn/blog_migrate/b10920e683e92d427732a893341acf13.png)
For the second method, click the “Page Layout” tab.
对于第二种方法,单击“页面布局”选项卡。
![09_clicking_page_layout_tab](https://i-blog.csdnimg.cn/blog_migrate/eba96b075f2af6e99aefb18d570cecc4.png)
Under “Gridlines” in the “Sheet Options” section, select the “View” check box so there is NO check mark in the box.
在“工作表选项”部分的“网格线”下,选中“查看”复选框,以便该框中没有复选标记。
![10_clicking_view_on_page_layout_tab](https://i-blog.csdnimg.cn/blog_migrate/c2c5ed7932a7421b4da6449625632abb.png)
Remember, you can also hide other items in Excel such as cells, rows, and columns and worksheets/tabs and even entire workbooks.
请记住,您还可以在Excel中隐藏其他项目,例如单元格,行和列以及工作表/选项卡,甚至整个工作簿。
翻译自: https://www.howtogeek.com/218633/how-to-hide-comments-formulas-overflow-text-and-gridlines-in-excel/
excel公式单元格注释