how to delete contents of cells having specific data
 

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

Steve

There is no way to do this easily. It could be done with code. If you
didn't have comments, you could use conditional formatting to turn the cell
value white so it couldn't be seen. It would print though!

If you wish to explore the code route, try posting in the programming group

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"steve" wrote in message
...
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

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