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

Watch on YouTube

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