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

idea中注释代码怎么注释

idea中注释代码怎么注释

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中的注释非常适合对某些单元格进行注释,因此您可以跟踪自己的工作。 如果您在工作表中添加了很多注释 ,可能很难记住在注释中放置特定注释的位置。

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

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

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

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

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.

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

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

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

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/

idea中注释代码怎么注释

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值