How to Add / Remove Strikethrough in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on July 18, 2023

This tutorial demonstrates how to add and remove strikethrough formatting in Excel and Google Sheets.

excel cells strikethrough

Add Strikethrough

You may want to format some cells with strikethrough in Excel. Say you have the to-do list below and want to emphasize that some items are removed from the list, have been completed, or are no longer available.

excel to do list

As you can see, there are six items on the to-do list above. Say you have completed the tasks in B3, B4, and B7 and want to format them with strikethrough.

  1. Select cells B3, B4, and B7. Note that you can apply strikethrough to either a single cell or multiple cells at once.
  2. Then in the Ribbon, go to the Home tab, and in the Font section, click the Font Settings icon.
    OR use the keyboard shortcut CTRL + 1.

strikethrough font settings

  1. In the Font Settings window, check Strikethrough and click OK.

strikethrough font settings 2

Now cells B3, B4, and B7 appear to be crossed out.

excel cells strikethrough

Remove Strikethrough

To remove the strikethrough effect from cells, follow the steps above, but uncheck Strikethrough in Step 3 instead of checking it.

remove strikethrough excel

As a result, the strikethrough effect in cells B3, B4, and B7 is removed.

excel to do list

Add Strikethrough in Google Sheets

To add strikethrough in Google Sheets, select cells B3, B4, and B7 and click the Strikethrough icon in the Toolbar.

google sheets add strikethrough

Now, the selected cells have strikethrough formatting applied.

google sheets strikethrough

To remove strikethrough, follow the same steps.

Also see

AI Formula Generator

Try for Free

See all How-To Articles