how to delete contents of cells having specific data

G

Guest

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
 
N

Nick Hodge

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
(e-mail address removed)
 
M

Morrigan

Autofilter -> Custom -> Contains "XYZ"

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How do I delete images in a specific range 1
Delete cells containing specific data? 1
How do I boldface specific cells of data table connect to graph? 5
Code to format cells on several worksheets 2
cell contents 1
Macro to clear contents of certain cells 4
copy cells but lock editing 5
Sharing workbooks limitations - Merged Cells 12

Top