Strikethrough Format in Google Sheets (4 Easy Methods 2022)

Written by Abid Akon

Here's what we'll cover:

Although the strikethrough format is mostly utilized in document apps like Google Docs and Microsoft Word, it can be used in Google sheets to cross out or cancel out data without it being completely removed from the cell. 

In this tutorial, we are going to learn what the strikethrough format is and how to add Strikethrough Format in Google Sheets and also how we remove this Strikethrough Format in Google Sheets. 

What is a Strikethrough?

A strikethrough is denoted by a straight line cutting across a word or group of words in a selected cell, signifying removal or mistakes but not completely removing the word from the cell as the word can still be seen by the user. 

This tool is frequently used to cancel out or cross out words from a list of words. The list of words could be a to-do list, a catalog, a timetable, an agenda or an order of the day. The strikethrough majorly shows that the crossed-out word or agenda has been implemented successfully by the user.

Four ways are used to add strikethroughs to your Google sheet.

Method 1: Adding Strikethrough with the Format Drop-Down menu.

As a Google Sheet user, you are pretty much familiar with the functions of the Format tool on the toolbar. Well if you aren’t, the format tool contains features that are used to improve visibility, text style and design of data in a worksheet. 

These features include Theme, Number, Text, Alignment, Text Rotation, Wrapping, and Conditional formatting. Under the Text tool, are the bold, italic, underline, and strikethrough formats.

In the sample worksheet below, we have a list of daily chores and activities that we need to fulfill. Some tasks are completed already while some aren’t, so we employ the strikethrough format to strike out completed tasks.

1 Strikethrough Format in Google Sheets

By following the steps below, you can apply a strikethrough to a text on your worksheet.

Step 1:  Select or highlight the cell or range of cells on your worksheet.

2 Strikethrough Format in Google Sheets

Step 2: On the toolbar, click on Format.

3 Strikethrough Format in Google Sheets

Step 3: A drop-down menu is produced under format, displaying the major features it entails. Click on Text.

4 Strikethrough Format in Google Sheets

Step 4: Under Text, are four other tools which are Bold, Underline, Italics, and strikethrough. Select strikethrough.

5 Strikethrough Format in Google Sheets

Step 5: The selected cell has its texts crossed out on the worksheet.

6 Strikethrough Format in Google Sheets

Method 2: Keyboard Shortcut to Apply Strikethrough in Google Sheets.

If you like easy, efficient and quick shortcuts then this method is just for you. Unfortunately, users with mobile devices with capacitive or sensitive displays can’t implement this method due to the absence of a keyboard. Users with desktop computers and laptops would enjoy this method more.

  • Windows – Shift key + Alt key + 5. Press and hold the shift and alt keys, then click number five.
  • MacBook – Command key ⌘ + Shift key + X.

With these shortcuts, strikethroughs are added to the selected cells.

Method 3: Add Strikethroughs through the Toolbar.

For those who cannot use the keyboard shortcuts, this is also a shortcut that is compatible with touch screen devices and is done in a few clicks.

Step 1: Select the cell or cells you want to work with.

7 Strikethrough Format in Google Sheets

Step 2: Go to the top right of the worksheet. Little icons denoting different tools are presented there. Select the strikethrough icon as seen below.

8 Strikethrough Format in Google Sheets

Step 3: The selected cells have their texts crossed out of the cell.

9 Strikethrough Format in Google Sheets

Method 4: Add Strikethrough with Conditional Formatting.

In a case where you have a large schedule or timetable and you want to strike out data based on given criteria, conditional formatting is used. 

Conditional formatting also works in collaboration with checkboxes in Google Sheets. Therefore, in the sample worksheet below, we would create checkboxes with the insert tool, and then we would add strikethroughs with the conditional formatting.

Step 1: Select a cell or highlight a range of cells.

10 Strikethrough Format in Google Sheets

Step 2: Select Insert on the toolbar.

11 Strikethrough Format in Google Sheets

Step 3: A drop-down menu is produced, displaying a list of options. Click on the Checkbox option.

12 Strikethrough Format in Google Sheets

Step 4: Checkboxes are inserted in the selected cell or cells.

13 Strikethrough Format in Google Sheets

If you click on the boxes, a tick sign appears in the checkbox but it doesn’t cancel out the text in the cell. This is where Conditional Formatting comes in.

14 Strikethrough Format in Google Sheets

Step 1: Click on Format on the toolbar.

15 Strikethrough Format in Google Sheets

Step 2: Select Conditional formatting from the drop-down menu.

16 Strikethrough Format in Google Sheets

Step 3: The Conditional formatting tab is generated on the right side of the worksheet.

Step 4: Select Apply to Range. Select the data range of cells which is B2:C17.

17 Strikethrough Format in Google Sheets

Step 5: Now, we are going to create rules and conditions for the format. Click on Format cells if.

Step 6: A drop-down menu is displayed. Select Custom Formula Is from the menu.

18 Strikethrough Format in Google Sheets

Step 7: In this section, we are going to create a formula that tells the format when to add a strikethrough to the worksheet. So if a checkbox is true and an unchecked box is false, then using a checkbox in cell A2 as a cell reference, the formula takes the syntax below.

=$A2=TRUE

The dollar sign in the formula locks the cell reference so it could be applied to all the cells in the range. This means that if a box is checked, a strikethrough should be added to the cell.

19 Strikethrough Format in Google Sheets

Step 8: This is the main aspect here, where we customize and change the formatting style.

Step 9: Click on the strikethrough icon here. You can also change the text and fill colors.

20 Strikethrough Format in Google Sheets

Step 10: Click Done.

21 Strikethrough Format in Google Sheets

 If you click the box, the task is crossed out and highlighted in the selected fill color.

22 Strikethrough Format in Google Sheets
23 Strikethrough Format in Google Sheets

Removing Strikethrough in Google Sheets.

We’ve discussed how to add strikethroughs to your worksheet, but what if you want to remove them? Don’t fret about it. The same methods used above to add strikethroughs are also used to remove them. If you want to remove strikethroughs from a worksheet,

  •  Select the cell or range of cells.
24 Strikethrough Format in Google Sheets
  • Use any of the methods stated above like the shortcuts, format menu or strikethrough icon directly on the toolbar.
25 Strikethrough Format in Google Sheets

If the strikethrough was added by conditional formatting, you’d select the formatted cells or range of cells.

  • Click Format on the toolbar.
26 Strikethrough Format in Google Sheets
  • Click clear formatting here. All strikethroughs inserted are removed.
27 Strikethrough Format in Google Sheets
28 Strikethrough Format in Google Sheets

Final Thoughts.

Strikethroughs are necessary mechanisms that aid clarity and orderliness in task worksheets. Although it’s mostly used in word documents, it’s also quite efficient in spreadsheet documents too. I hope you found this tutorial informative. Thanks for reading. 

Abid Akon

Abid Akon

I am a tech content writer. I really love to talk about different Modern Technology. It is very important that people know how to fix their tech related problem. That’s why I am writing articles to share my tech knowledge with you.

Related Articles

MD Abid Akon

Abid Akon

Hi, I am Abid. I really love to talk about different Modern Technology. It is very important that people know how to fix their tech related problem. That’s why I’ve created this website to share my technology keeping knowledge with you. Welcome to ”abidakon.com”

Abid Akon

My Personal Favorites
YouTube Channel