How to Strikethrough in Excel

The easy way to cross out text

What to Know

  • In Excel Online, open a spreadsheet. Select the cells with text you want to strike through. Select the strikethrough icon.
  • In Excel on the desktop, open a spreadsheet. Select the cells containing text you want to strike through.
  • Select the Format Cells launcher. Under Effects, check the box next to Strikethrough.

This article explains how to apply the strikethrough format to text or numbers in Excel Online or Excel for computers. It also includes information on how to use a third-party app to achieve the strikethrough effect in Excel for Android or iOS mobile devices.

How to Strikethrough Text in Excel Online

Strikethough text in an Excel spreadsheet draws attention to numbers or text that changed or is no longer relevant. The font format simultaneously displays information and marks it as obsolete or indicates the information should not be used.

Different versions of Excel provide access to the strikethough effect in different places. Strikethrough is a built-in toggle offered in Excel Online as part of font formatting options on the Home tab.

  1. Go to Excel Online. Sign in with your Microsoft account, if prompted.

    Screenshot of Excel Online sign in prompt (Sign in with email, phone, or Skype)
  2. Open the spreadsheet in which you want to strike through text.

  3. Select the cell or cells that you want to strike through.

  4. Select the strikethrough format option, much as you would add bold, underline, or italics.

    Screenshot of word "Strikethrough" in cell E2, with strikethrough format selected (in gray) above
  5. The selected cells will now show strikethough text.

How to Strikethrough Text in Desktop Excel 

Most recently installed versions of Excel offer strikethrough as a specific formatting option that you can find under font effects. The following works in Excel 2019, Excel 2016, Excel 2013, and Excel 365.

  1. Start Excel and open the spreadsheet in which you want to strike through text.

  2. Select the cell (or cells) in which you want strike through text.

  3. Select the Format Cells launcher to access cell formatting options. (In older versions of Excel, navigate to Menu > Format > Format Cells and look for Font.)

    Screenshot of cursor placed over Font Settings pop-out selection option. Select this to access font options in desktop Excel
  4. Under Effects, select the checkbox to the left of Strikethrough.

    Screenshot with Format Cells > Effects > Strikethrough checkbox selected.
  5. Select OK

  6. The contents of the text or numbers in the selected cells should now display as strikethrough text.

Alternatively, you might try keyboard shortcuts to toggle strikethrough text in Excel. Select the cell (or cells) desired, then press Ctrl+5. On macOS use Shift+Command+X or, on older macOS versions of Excel, such as Excel 2011 or Excel 2008, try Shift+Command+minus.

To remove the strikethrough effect, select a cell (or cells), then repeat the process or keyboard shortcut detailed above.

A screenshot of Excel showing an example of strikethrough feature

How to Strikethrough Text in Excel on Android or iOS Devices

As of June 2019, neither Microsoft Excel on Android nor iOS offers built-in support for strikethrough text in the app. But you can still add strikethrough text and/or numbers into an Excel cell with the help of a website.

To create strikethrough text in a browser:

  1. Open either Safari (on iOS) or Chrome (on Android) to https://www.piliapp.com/cool-text/strikethrough-text/

    Safari on iPad screenshot of piliapp Strikethrough generator.
  2. Enter the text you want to display as strikethrough in the first text box. You’ll see the sample text, with strikethrough, below. 

  3. Tap Copy to Clipboard. Return to your device’s home screen.

    Enter text you want to use to create strikethrough, then tap "Copy to clipboard"
  4. Tap to open Excel.

  5. Tap to select and open the file into which you want to insert strikethrough text.

  6. Tap the cell into which you want to insert strikethrough text.

  7. Depending on your device, either tap Paste or tap the clipboard icon to paste the contents of the clipboard (the strikethrough text you’d created earlier) into the cell.

    Screenshot of Excel on iPad, with cell tapped and "Cut, Copy, Paste" options displayed. Tap paste to insert clipboard contents into the selected cell.
  8. In some cases, you may see an extra line or dash. Adjust the contents of the cell, if needed.

    Screenshot of inserted strikethrough text (e.g., ̶T̶y̶p̶e̶ ̶s̶t̶r̶i̶k̶e̶t̶h̶r̶o̶u̶g̶h̶ ̶t̶e̶x̶t̶ ̶h̶e̶r̶e̶)
  9. Your strikethrough text should now display as desired in Excel.

Microsoft supports strikethrough in Excel Online, as well as in Excel on Windows and macOS, but Excel on mobile devices requires the use of a third-party site to format text. If you work with sensitive information in Excel, you should avoid using a third-party site to format strikethrough text.

Was this page helpful?