PDFelement: PDF Editor, Scanner
Edit, Convert, Annotate PDF
Edit, Annotate PDF

Google Sheets is a spreadsheet tool infused with collaborative features. You and others can open the document and edit it at the same time. Sometimes, you would need to inform your team about something that needs to be changed before applying said changes. To do that, you can use the Google Sheets strikethrough tool.

In this article, you will learn how to add a strikethrough in Google Sheets. You will also learn additional information, like scenarios when using a strikethrough is necessary. As a bonus, you'll also learn how to strikethrough text in a spreadsheet saved as a PDF using Wondershare PDFelement.

In this article
    1. How To Strikethrough in Google Sheets Using the Toolbar
    2. How To Strikethrough in Google Sheets Using the Menu Options
  1. What Is the Google Sheets Strikethrough Shortcut?
  2. How To Use Google Sheets Checkbox Strikethrough Feature
  3. How To Remove Strikethrough in Google Sheets
    1. Other Useful Features

Part 1. 2 Methods to Strikethrough in Google Sheets

There are two ways to strikethrough text in Google Sheets. You can use the option in the toolbar or use the menu option. Here, you will learn how to do both.

Part 1.1 How To Strikethrough in Google Sheets Using the Toolbar

  1. Select the cell containing the text you want to strikethrough. If you only want to apply the strikethrough to certain words within the cell, double-click the cell and highlight the text you want to strikethrough.
selecting the cell that needs strikethrough
  1. Click the Strikethrough button in the toolbar.
using the strikethrough button in the toolbar

Part 1.2 How To Strikethrough in Google Sheets Using the Menu Options

  1. Select the cell containing the text you want to strikethrough. Suppose you only want to apply the strikethrough to certain words within the cell. Double-click the cell and highlight the text you want to strikethrough.
  2. Click Format > Text > Strikethrough.
using the strikethrough option in menu

We recommend following the steps in Part 1.1. over these steps since that method is much faster.

Part 2. What Is the Google Sheets Strikethrough Shortcut?

This is the fastest way to strikethrough text in Google Sheets. Instead of a series of mouse clicks, all you have to do is press three buttons simultaneously. It's a more effortless method.

Bear in mind that the system you are using changes the keyboard shortcut.

So, how do you do it? Follow these steps to use the Google Sheets Strikethrough Shortcut.

  1. Select the text that you want to strike through. If you want to apply the strikethrough to all the contents in the cell, simply click that.
  2. Press the ALT,SHIFT, and 5 buttons all at once if you are on Windows. On Mac, press the Command, Shift, and X buttons instead.

Part 3. How To Use Google Sheets Checkbox Strikethrough Feature

Google Sheets also allows you to create advanced lists that automatically cross out items when you check their respective checkboxes. To do that, you need to use the Google Sheets Checkbox Strikethrough method through conditional formatting. Here are the steps for doing so:

  1. Select the column where you want to add a checkbox. You want it to be the column on the left of the list.
  2. Click Insert > Checkbox.
adding checkboxes to a cell range
  1. Select the column or cell range containing your list.
selecting cell range containing the list
  1. Click Format > Conditional Formatting.
applying conditional formatting to selected cell range
  1. Under the "Format cell if" section, choose Custom Formula.
  2. Type this in the textbox for "Custom Formula is:" =A2=True.
adding the formula for strikethrough automation
  1. Under “Formatting Style,” click Strikethrough.
selecting strikethrough under formatting style
  1. Click Done and test if it works.
google sheets checkbox strikethrough is working

Part 4. How To Remove Strikethrough in Google Sheets

Just like adding a strikethrough in Google Sheets, there are three methods for removing it. You can use the toolbar, the menu options, or keyboard shortcuts.

  1. Select the cell or text with a strikethrough.
  2. Click the Strikethrough button on the toolbar. Alternatively, click Format > Text > Strikethrough or press ALT + SHIFT + 5 or COMMAND + SHIFT + X.

Again, the fastest way is to use the keyboard shortcut, while the slowest is using the Format menu.

Part 5. How to Strikethrough in PDF Sheets

ai features of wondershare pdfelement

Have you downloaded your Google Sheets file but forgot to apply a strikethrough first? Also, did you convert it to PDF? You can still add a strikethrough to that PDF, albeit using a different tool. Instead of using Google Sheets strikethrough, you can use Wondershare PDFelement instead.

  1. Open Wondershare PDFelement. Click Open PDF > select your spreadsheet that has been converted to PDF.

opening pdf sheets using wondershare pdfelement
  1. If you downloaded the file as an Excel file, click + > From File > Select the document instead.
opening google sheets file using pdfelement
  1. Click Edit > Edit All.

activating pdfelement editing features
  1. Select the text you want to strike through.
  2. On the properties tab on the right, click Strikeout.
adding a strikeout using wondershare pdfelement

You can follow the same steps to remove a strikethrough from the text.

Other Useful Features

  • OCR - Maybe the spreadsheet was scanned or is an image. If so, Wondershare PDFelement will not be able to edit the text within the file. But you can make it editable first using the OCR feature.

wondershare pdfelement ocr feature
  • Strikeout in Comments - Suppose you are suggesting changes. You can use the Strikeout feature in the Comment tab instead. This way, you can add a comment to explain why you put a strikethrough in the text.
strikeout option in pdfelement comment tab
  • Convert - After adding a strikethrough using Wondershare PDFelement, you may want to convert the file back to Excel. You can use Wondershare PDFelement to do that. You can use the To Excel option in the Convert tab or open the feature by clicking Convert PDF from the main menu. In this way, PDFelement completed a similar task like adding strikethrough in Excel.

converting pdf sheets file to excel


The Google Sheets strikethrough feature is useful for highlighting errors, requesting changes, and more. It's a simple formatting tool, and finding the right buttons takes no time.

Google Sheets is not the only tool that offers a strikethrough feature. You can also use Wondershare PDFelement. It can open and edit spreadsheet files saved as PDFs. Furthermore, it can open other files, like Excel files. You can use the built-in converter to turn them back to the original file format after you have added the strikethrough.

People Also Ask

Here are some frequently asked questions regarding the Google Sheet Strikethrough feature or just strikethrough in general.

  • 1. How do you do conditional strikethrough in Google Sheets?
    Google Sheets allows you to do conditional formatting. It does a set action when a condition you set has been fulfilled. You can use this feature to automate adding a strikethrough to text. Here's how to do it.
    1. Select the cell or range of cells where you want to apply conditional formatting.
    2. Click Format > Conditional Formatting.
    3. Set your preferred Formula Rules.
    4. Under Formatting style, click Strikethrough.
    5. Click Done.
  • 2. How do I put a line through a cell in Google Sheets?
    If you meant a horizontal line, then you should use the strikethrough feature. But if you are thinking of a diagonal line, you can use the Insert Drawing option. Here is how to do that.
    1. Click the cell where you want to put a diagonal line.
    2. Click Insert > Drawing.
    3. On this Drawing window, click Line.
    4. Draw a diagonal line on the canvas.
    5. Click Save and Close.
  • 3. How do you insert a line break in a Google sheet cell?
    A line break marks the end of a line; what you type next will appear on a new line. Usually, you just press the Enter key to add a line break. But on Google Sheets, the cursor will move to the next cell rather than the next line. Instead of doing that, press CTRL + Enter on Windows and CMD + Return on Mac.
Audrey Goodwin
Audrey Goodwin May 22, 24
Share article:
12 years of talent acquired in the software industry working with large publishers. Public speaker and author of several eBooks on technical writing and editing.