Filter strikethrough data in Microsoft excel

Learn to filter strikethrough data in Excel.

1. Website: https://www.specialskills.in/

How do you filter a column which contains strikethrough data? In below table, column A
contains strikethrough data.


Press control F to open 'find and replace' dialog box. Click on 'options' button.

2. Click on 'format' button.


Go to 'font'. Select 'strikethrough'. Press Ok.

3. Ensure that ‘preview’ button is disabled.



Click on ‘find all’ button. There are six cells that contain strikethrough data.

4. Click on ‘format’ button.


Select one of the rows.

5. Press control A. All cells with strikethrough data get selected in column A.


Go to home ribbon tab. Apply yellow fill colour. Then close ‘find and replace’ dialog box.

6. Apply filter in the table using CTRL SHIFT L


Open filter in column A, go to ‘filter by color’ and then select yellow color.

7. You have successfully filtered only strikethrough data in the given table.