Windows 7 Can I search comments in excell?

[las14]

Is there a way to search for text in comments in Excell?

tia
las

 

[BIGBEARJEDI]

Are you talking about text in the Cells or separate comments linked to Cell such as notes?

<<<BIGBEARJEDI>>>

 

[las14]

Text in separate comments linked to cell.

 

[BIGBEARJEDI]

Try using Ctrl-F to search. Details are here for 2003 and earlier Excel versions ( you didn't mention which version you were asking about): http://excel.tips.net/T002945_Searching_Comments.html

Here's the link for 2007 and newer Excel versions: http://excelribbon.tips.net/T007852_Searching_Comments.html

<<<BBJ>>>