idea中注释代码怎么注释_如何在Excel中搜索注释

客官°小女子只卖身不卖艺 2021-07-27 00:04 535阅读 0赞

![idea中注释代码怎么注释][idea]

idea中注释代码怎么注释

![00\_lead\_image\_search\_comments\_excel][00_lead_image_search_comments_excel]

Comments in Excel are great for making notes about certain cells so you can keep track of your work. If you’ve [added a lot of comments to your worksheets][], it can get hard to remember where you put a specific note in a comment.

Excel中的注释非常适合对某些单元格进行注释，因此您可以跟踪自己的工作。 如果您在[工作表中添加了很多注释][added a lot of comments to your worksheets] ，可能很难记住在注释中放置特定注释的位置。

However, you can search through only the comments in your worksheet or workbook, with this advanced setting.

但是，使用此高级设置，您只能搜索工作表或工作簿中的注释。

You can start the search from any cell in your worksheet. Excel will continue to cycle the search through the worksheet and search all the cells. Press Ctrl+F on your keyboard to open the Find and Replace dialog box with the Find tab active. Click “Options”.

您可以从工作表中的任何单元格开始搜索。 Excel将继续在工作表中循环搜索并搜索所有单元格。 在键盘上按Ctrl + F，以打开“查找和替换”对话框，其中“查找”选项卡处于活动状态。 点击“选项”。

![01\_clicking\_options][01_clicking_options]

To narrow the search to only comments, select “Comments” from the “Look in” drop-down list.

要将搜索范围缩小到仅注释，请从“查找范围”下拉列表中选择“注释”。

![02\_selecting\_comments][02_selecting_comments]

By default, Excel will only search the current worksheet. If you want to search through all the comments on all the worksheets in your workbook, select “Workbook” from the “Within” drop-down list. Click “Find Next” to start the search.

默认情况下，Excel仅搜索当前工作表。 如果要搜索工作簿中所有工作表上的所有注释，请从“内部”下拉列表中选择“工作簿”。 单击“查找下一个”开始搜索。

![03\_clicking\_find\_next][03_clicking_find_next]

The first cell with a comment attached to it that contains the search term you entered is highlighted. The comment is not automatically shown. However, you don’t have to close the Find and Replace dialog box to view or edit the comment on the selected cell. The Find and Replace dialog box is a non-modal dialog box, which means you can work on the worksheet behind it while the dialog box is still open. If your [comments are hidden][], move your mouse over the selected cell to view the comment.

带有注释的第一个单元格将突出显示，其中包含您输入的搜索词。 注释不会自动显示。 但是，您不必关闭“查找和替换”对话框即可查看或编辑所选单元格上的注释。 “查找和替换”对话框是一个非模式对话框，这意味着您可以在对话框仍打开的情况下在其后面的工作表上进行工作。 如果您的[注释是隐藏的][comments are hidden] ，请将鼠标移到选定的单元格上以查看该注释。

![04\_comment\_found][04_comment_found]

If you want to edit the comment, right-click on the cell and select “Edit Comment” from the popup menu.

如果要编辑注释，请在单元格上单击鼠标右键，然后从弹出菜单中选择“编辑注释”。

![05\_selecting\_edit\_comment][05_selecting_edit_comment]

The comment is shown (if it was hidden) and the cursor is placed within the comment, allowing you to edit it. When you’re finished editing the comment, click in any other cell. Your changes to the comment are saved and the comment is hidden again, if it was previously hidden.

显示注释(如果已隐藏)，并将光标放在注释内，您可以对其进行编辑。 编辑完注释后，单击其他任何单元格。 您对注释所做的更改将被保存，并且该注释将被再次隐藏(如果先前已隐藏)。

![06\_editing\_a\_comment][06_editing_a_comment]

To continue searching through your comments, click “Find Next” again on the Find and Replace dialog box to find the next occurrence of your search term. When you’re finished with your search, click “Close” to close the Find and Replace dialog box.

要继续搜索您的注释，请在“查找和替换”对话框上再次单击“查找下一个”，以查找下一个出现的搜索词。 搜索完成后，单击“关闭”以关闭“查找和替换”对话框。

> 翻译自: [https://www.howtogeek.com/261913/how-to-search-through-comments-in-excel/][https_www.howtogeek.com_261913_how-to-search-through-comments-in-excel]

idea中注释代码怎么注释

[idea]: /images/20210726/020e0f332ea04d44bd405c8ea940553b.png
[00_lead_image_search_comments_excel]: /images/20210726/47d1cd00ba944070927ef120bbe6d53b.png
[added a lot of comments to your worksheets]: https://www.howtogeek.com/162231/add-comments-to-formulas-and-cells-in-excel-2013/
[01_clicking_options]: /images/20210726/0e73d3c59d044edb81bb81b48329f56e.png
[02_selecting_comments]: /images/20210726/6785ffde807f4e2aabeec14a6d3afa35.png
[03_clicking_find_next]: /images/20210726/98cb75d23f72432582074591cc5930b6.png
[comments are hidden]: https://www.howtogeek.com/218633/how-to-hide-comments-formulas-overflow-text-and-gridlines-in-excel/
[04_comment_found]: /images/20210726/375be0478c684c1f8522466928fb1860.png
[05_selecting_edit_comment]: /images/20210726/2aacbef3962c4e5fb5e1d8fb35132851.png
[06_editing_a_comment]: /images/20210726/fd32f713d6d1472db5fd4457d4501182.png
[https_www.howtogeek.com_261913_how-to-search-through-comments-in-excel]: https://www.howtogeek.com/261913/how-to-search-through-comments-in-excel/