ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I sort or filter or delete by strike-through? (https://www.excelbanter.com/excel-discussion-misc-queries/161896-re-can-i-sort-filter-delete-strike-through.html)

Gary''s Student

Can I sort or filter or delete by strike-through?
 
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?


Annie1904

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?



All times are GMT +1. The time now is 05:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com