View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Annie1904 Annie1904 is offline
external usenet poster
 
Posts: 21
Default Can I sort or filter or delete by strike-through?

I've struck through the entire row for each of the records that have been
'deleted'. So now I want to actually delete those rows.

"Gary''s Student" wrote:

Hi Annie:

Do want you want to clear cells containing strikethroughs or delete the
cells or delete the entire row containing the cells?
--
Gary''s Student - gsnu200749


"Annie1904" wrote:

I've got a huge database in Excel, and many of the records have had text
formatted with a strike-trhough. Initially, this was so I could track what
had been 'deleted', but now I want to remove those records. Rather than go
through them individually, is there a quicker way?