How to Strikethrough in Google Sheets (Shortcut)

Strikethrough is the formatting where you see the text (or number) with a line in the middle.

Something as shown below:

Strikethrough formatting on Text

While it’s mostly used with text data in tools such as Google Docs or MS Words, you can also use the strikethrough format in Google Sheets.

One use-case where it may be needed is when you have a list of tasks and you want to show some tasks with the strikethrough formatting to indicate that these have been completed.

In this tutorial, I will show you three simple ways to apply strikethrough formatting in Google Sheets cells.

Let’s get started!

Apply Strikethrough Formatting in Google Sheets

There are three easy ways you can use to get the strikethrough in Google Sheets:

  1. Using a keyboard shortcut
  2. Using the option in the toolbar
  3. Using the option in the menu

Let’s have a look at each of these.

Using a Keyboard Shortcut

Below is the keyboard shortcut to apply the strikethrough formatting to the selected cells (or even multiple ranges of cells)

ALT + SHIFT + 5

To use this keyboard shortcut:

  1. Select the cells or range of cells where you want to apply the strikethrough formatting
  2. With the cells selected, use the keyboard shortcut ALT + SHIFT + 5 (hold the ALT and the SHIFT key and press the 5 key)

The above shortcut works as a toggle. If you use it again on the cells that already have the strikethrough format applied to it, this will remove the formatting.

Note that in this example, I have applied the strikethrough format to the entire cell content. In case you only want to apply it to a part of the text, you need to double-click on the cell (or press F2 to get into the edit mode), select the text that you want to strike-through, and then use the above keyboard shortcut.

Using the Toolbar

If you’re not a keyboard person, there is an equally easy way by using the mouse – and it only takes a click.

Below are the steps to Apply strikethrough using the mouse:

  1. Select the cells or range of cells where you want to apply the strikethrough formatting
  2. Click on the Strikethrough icon in the toolbarClick on the strikethrough option in the toolbar

That’s it!

It will apply the strikethrough formatting to the selected cells.

This works like a toggle button. So if you select the cells where the formatting has already been applied and click on the strikethrough icon again, the formatting will be removed.

Using the Menu Options

And finally, there is also an option in the menu options in Google Sheets.

To use the option in the menu:

  1. Select the cells or range of cells where you want to apply the strikethrough formatting
  2. Click on the Format option in the menu
  3. In the options that appear, click on the Strikethrough option.Use the opton in the format menu

Personally, I never use this option as I find the icon in the toolbar to be more convenient (and it only takes one click as compared to two clicks with the Format option method). But I have still covered it here to show you all the methods that can be used.

Remove Strikethrough Formatting in Google Sheets

As I mentioned, the same options that were used to apply strikethrough formatting in the first place can also be used to remove the formatting.

Just select the cells that have the strikethrough formatting and use any of the above methods.

In case you have multiple cells that have the strikethrough format applied and you want to remove it from all the cells in the worksheet, use the below steps:

  1. Click on the gray empty rectangle at the top-left part of the Google Sheets document. This will select all the cells in the worksheetClick on the gray rectangle to select all cells
  2. Click the strikethrough option in the toolbar (or use any of the methods above)

If there is any cell (or multiple cells) in the worksheet that has the formatting applied to it, this will remove the strikethrough formatting from all the cells.

So these are three simple ways you can use to apply or remove the strikethrough formatting in Google Sheets.

I hope you found this tutorial useful!

Other Google Sheets tutorials you may like:

Leave a Comment