How to Use Strikethrough in Google Sheets: A Quick Tutorial

Last Modified: January 13, 2024 - 2 min read

Julian Alvarado

TL;DR: Apply strikethrough in Google Sheets by selecting text or cells and using ‘Format’ > ‘Text’ > ‘Strikethrough’ or Alt + Shift + 5 (Cmd + Shift + X on Mac). Remove it using the same steps.

This guide will show you how to apply and remove strikethrough in your Google Sheets.

Step 1: Open Your Google Sheet

Start by opening the Google Sheets document where you want to apply strikethrough.

Step 2: Select the Text or Cell

Click on the cell that contains the text you want to strike through. If you want to strikethrough only part of the text in a cell, double-click the cell and highlight the specific text.

Step 3: Applying Strikethrough

spreadsheet ai
Free AI-Powered Tools Right Within Your Spreadsheet

Supercharge your spreadsheets with GPT-powered AI tools for building formulas, charts, pivots, SQL and more. Simple prompts for automatic generation.

With the text or cell selected, click on the ‘Format’ menu in the menu bar. Hover over ‘Text’ and then click on ‘Strikethrough.’ You can also use the keyboard shortcut Alt + Shift + 5 (Cmd + Shift + X on Mac).

Step 4: Removing Strikethrough

To remove strikethrough, simply select the cell or text again and repeat the same process: ‘Format’ > ‘Text’ > ‘Strikethrough’, or use the keyboard shortcut.

Tips for Using Strikethrough Effectively:

  1. Task Management: Use strikethrough for task lists in your sheet to visually indicate completed items.
  2. Data Correction: Highlight corrections in data sets by using strikethrough on the original text and adding the corrected data nearby.
  3. Visual Consistency: Keep your sheet visually organized by using strikethrough consistently across similar types of data or tasks.

Sync Live Data into Your Spreadsheet

Connect Google Sheets or Excel to your business systems, import your data, and set it on a refresh schedule.

Try the Spreadsheet Automation Tool Over 350,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 350,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Julian Alvarado Content Marketing
Julian is a dynamic B2B marketer with 8+ years of experience creating full-funnel marketing journeys, leveraging an analytical background in biological sciences to examine customer needs.
350,000+ happy users
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies