How to Find Cells With Strikethrough in Excel

Written by clayton kim
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Find Cells With Strikethrough in Excel
Find cells with a strikethrough fast and easily. (David Sacks/Lifesize/Getty Images)

Just like having a cheat code for "Where's Waldo," finding cells with strikethrough in Excel can be made easier using the software's built-in tools. Excel has a built-in "Find" function. The "Find" function searches through the spreadsheet to find all kinds of things, such as "Strikethrough" cells. You do not need to be a computer programmer to use this function. It is very easy to do. With a few taps of the keyboard and mouse, find cells with "Strikethrough."

Skill level:
Moderately Easy


  1. 1

    Open Microsoft Excel. Hold the "Control" key and press the "F" key on the keyboard. The combination opens the"Find" function.

  2. 2

    Click on the "Format" button in the "Find and Replace" window. Click on the "Fonts" tab.

  3. 3

    Check the "Strikethrough" checkbox in the "Effects" section and click the "OK" button.

  4. 4

    Click the "Find all" button in the "Find and Replace" window.

  5. 5

    Look at the bottom of the "Find and Replace" window. All the cells with "Strikethrough" are listed at the bottom of the window.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.