Todd is looking for a way to Search in cell comments in Excel
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
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
Transcript of the video:
Learn Excel from MrExcel, Podcast Episode 2103: Search Comments.
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Today's question sent in by Todd.
Is there some VBA that I can use to search comments in the workbook?
And Todd is talking about these type of comments where we go to the Review tab, insert a new comment and type something.
Those comments are usually seen by the little red arrow there that pops up.
And Todd is looking for some VBA that it can search through all the sheets in his workbook to find those comments.
Wait, it's even better than that.
Let's just use one cell and we'll go to Ctrl F for Find.
Find, if I want to find all the comments that contain the word “apple”.
“Apple” spell it right and then click the Options tab.
This is awesome, right?
It's hidden, you have to click Options or you can't see it and then Look in: Formulas, Values or - I have no idea when they added this in, but it's there: Comments.
We will Find All and there's a list of all of those cells on this worksheet.
Let's try it with the Workbook, Find All, sure enough it finds all the comments in all of the sheets and now anything that has “apple” in the comment is going to appear in yellow.
Even applesauce will appear.
Alright, so any form of the word “apple” and we've effectively marked those cells in all of the sheets.
Like this comment, it says banana so it was not found by our trick.
So, pretty cool feature that's built into Excel but hidden where no one would ever find.
Well, hey, that tip and a lot more are in this book Power Excel with MrExcel, 617 Excel mystery solved.
Click that “i” in the top right-hand corner for information on how to buy the book.
Alright, episode recap: Todd is looking for a way to search in cell comments in Excel.
Already built in, use CTRL F for the Find dialogue.
Click the Option button to get to more features.
In the Look in dropdown, change to Comments; Within, change to Workbook, click Find All.
And then a great trick that I use all the time, CTRL A to select all of the found cells on the current worksheet, change the fill color, so we can find them later.
And then click on the Next Sheet in the Search Results to move to the next sheet and repeat.
I want to thank Todd for sending that question in.
I want to thank you for stopping by.
I’ll see you next time for another netcast from MrExcel.
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Today's question sent in by Todd.
Is there some VBA that I can use to search comments in the workbook?
And Todd is talking about these type of comments where we go to the Review tab, insert a new comment and type something.
Those comments are usually seen by the little red arrow there that pops up.
And Todd is looking for some VBA that it can search through all the sheets in his workbook to find those comments.
Wait, it's even better than that.
Let's just use one cell and we'll go to Ctrl F for Find.
Find, if I want to find all the comments that contain the word “apple”.
“Apple” spell it right and then click the Options tab.
This is awesome, right?
It's hidden, you have to click Options or you can't see it and then Look in: Formulas, Values or - I have no idea when they added this in, but it's there: Comments.
We will Find All and there's a list of all of those cells on this worksheet.
Let's try it with the Workbook, Find All, sure enough it finds all the comments in all of the sheets and now anything that has “apple” in the comment is going to appear in yellow.
Even applesauce will appear.
Alright, so any form of the word “apple” and we've effectively marked those cells in all of the sheets.
Like this comment, it says banana so it was not found by our trick.
So, pretty cool feature that's built into Excel but hidden where no one would ever find.
Well, hey, that tip and a lot more are in this book Power Excel with MrExcel, 617 Excel mystery solved.
Click that “i” in the top right-hand corner for information on how to buy the book.
Alright, episode recap: Todd is looking for a way to search in cell comments in Excel.
Already built in, use CTRL F for the Find dialogue.
Click the Option button to get to more features.
In the Look in dropdown, change to Comments; Within, change to Workbook, click Find All.
And then a great trick that I use all the time, CTRL A to select all of the found cells on the current worksheet, change the fill color, so we can find them later.
And then click on the Next Sheet in the Search Results to move to the next sheet and repeat.
I want to thank Todd for sending that question in.
I want to thank you for stopping by.
I’ll see you next time for another netcast from MrExcel.
