Autofilter - Custom - Contains "XYZ"

Select those you want to delete F5 - Special - Visible cells only -
Delete


steve Wrote:
Dear friends,
I am working on a spreadsheet having a variety of data. In some of the
cells
spread across the sheet,I have a specific data ,say XYZ with comments
attached to the cells. I would like to delete the contents of these
cells
along with the comments.
How could I do that.
Thanking you all.
Steve


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=388571