Filter Cells In Excel With Strike Through Formatting

I have just finished reviewing an excel spreadsheet where a number of the rows were formatted with strikethough : like this.

The formatting was valid and the rows have to stay there – but I have no need to review those rows. In excel you can filter rows, by contents or even by colour but not by format.

Enter a VBA user function:

Create a code module and paste in the following:

https://github.com/RossGoodman/Excel/blob/master/StruckThrough.bas

You can then add a new column for example A:A and enter the formula

and then copy this down. Column A will then flag true or false if the cell to the right is struck through and you can now filter by this new column.

Leave a Reply

To respond on your own website, enter the URL of your response which should contain a link to this post's permalink URL. Your response will then appear (possibly after moderation) on this page. Want to update or remove your response? Update or delete your post and re-enter your post's URL again. (Learn More)