How to Strikethrough in Excel

The easy way to cross out text

A screenshot of Excel showing an example of strikethrough feature.

 Place.to

Strikethough text in an Excel spreadsheet can help draw attention to numbers or text that may have changed or may no longer be 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. You may view strikethough text in every version of Excel, but some versions of Excel omit access to the strikethough format setting. However, third-party tools can help you insert strikethough text into Excel — even when the format isn’t available in Microsoft’s menus!

Here’s how to strikethrough text in Excel Online, in Excel on Windows and macOS systems, and in Excel on Android and iOS devices. 

Microsoft supports strikethrough in Excel Online, as well as in Excel on Windows and macOS, but Excel on mobile devices requires 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.

How to Strikethrough Text in Excel Online

Strikethrough is a built-in toggle offered in Excel Online, as part of font formatting options on the Home tab.

  1. Go to https://office.live.com/start/Excel.aspx. 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 strikethrough text.

  3. Select the cell or cells that you want to strikethrough.

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

    Screenshot of word
  5. The selected cells will now show strikethough text.

How to Strikethrough Text in Desktop Excel 

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

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

  2. Select the cell (or cells) in which you want strikethrough 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 the the left of Strikethrough.

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

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

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.

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
  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
  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.