See all How-To Articles

How to Add / Remove Strikethrough in Excel & Google Sheets

In this tutorial, you will learn 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, (2) go to the Home tab, and in the Font section, (3) click on the Font Settings icon in the right lower part.
OR use the keyboard shortcut CTRL + SHIFT + F.

 

strikethrough font settings

 

3. 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, (1) select cells B3, B4, and B7 and (2) 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.