Excel Comment Search: Search in Cell Comments in Excel - Episode 2103
2,961 views · Published 20 June 2017 · 2:26 · Indexed 31 October 2026
Channel: MrExcel.com · 2017 · Education
Microsoft Excel Tutorial: Search in cell comments in Excel. Welcome to another episode of the MrExcel netcast, where we bring you tips and tricks to help you master Excel. In today's episode, we will be discussing how to search comments in Excel, a question sent in by Todd. Todd is looking for a way to search through all the comments in his workbook using VBA. Well, Todd, I have a better solution for you that doesn't require any coding. Did you know that Excel has a built-in feature that allows you to search for specific words or phrases within comments? That's right, you don't need any fancy VBA code. All you need to do is use the Find function. Simply press Ctrl+F to open the Find dialogue box, type in the word or phrase you want to search for, and then click on the Options tab. Here's where it gets interesting. In the Look in dropdown, you can select "Comments" instead of the default "Formulas" or "Values". This will tell Excel to search for your word or phrase only within comments. And if you want to search through all the comments in your entire workbook, just change the Within dropdown to "Workbook". Then click on Find All and voila! Excel will list out all the cells that contain your search term in the comments. But wait, there's more! I have a little trick that I use all the time. After finding all the cells with the desired comment, I press Ctrl+A to select all of them on the current worksheet. Then I change the fill color to something bright, like yellow, so I can easily spot them later. And if you have multiple sheets in your workbook, you can click on the Next Sheet button in the Search Results to move to the next sheet and repeat the process. It's that simple! I hope this tip helps you save time and effort when searching for specific comments in your Excel workbook. And if you want more tips like this, be sure to check out my book "Power Excel with MrExcel", where I share 617 Excel mysteries solved. Click on the "i" in the top right-hand corner for more information on how to purchase the book. Thank you for tuning in to this episode of the MrExcel netcast. Don't forget to subscribe and hit the notification bell to stay updated on our latest videos. See you next time! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ This video answers these common search terms: how to select all on excel from find how to find all in excel how to find all comments in excel excel how to find comments how to search for comments in excel Table of Contents: (00:00) Search Comments in Excel Using VBA? (00:27) Using Ctrl+F to search for comments containing specific words (00:59) Using the "Look in" option to search for comments in formulas, values, or comments (01:19) Using Ctrl+A to select all found cells and change their fill color (01:45) Clicking Like really helps the algorithm Use Ctrl+F for the Find dialog Click the Option button to get more features Look In: change to Comments Within: Change to Workbook Click Find All Use Ctrl+A to select all of the found cells on the current worksheet Change the fill color so you can find them later. Click Feb in the search results to move to the next sheet Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153929/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920