The Tech Edvocate

Top Menu

  • Advertisement
  • Apps
  • Home Page
  • Home Page Five (No Sidebar)
  • Home Page Four
  • Home Page Three
  • Home Page Two
  • Home Tech2
  • Icons [No Sidebar]
  • Left Sidbear Page
  • Lynch Educational Consulting
  • My Account
  • My Speaking Page
  • Newsletter Sign Up Confirmation
  • Newsletter Unsubscription
  • Our Brands
  • Page Example
  • Privacy Policy
  • Protected Content
  • Register
  • Request a Product Review
  • Shop
  • Shortcodes Examples
  • Signup
  • Start Here
    • Governance
    • Careers
    • Contact Us
  • Terms and Conditions
  • The Edvocate
  • The Tech Edvocate Product Guide
  • Topics
  • Write For Us
  • Advertise

Main Menu

  • Start Here
    • Our Brands
    • Governance
      • Lynch Educational Consulting, LLC.
      • Dr. Lynch’s Personal Website
      • Careers
    • Write For Us
    • The Tech Edvocate Product Guide
    • Contact Us
    • Books
    • Edupedia
    • Post a Job
    • The Edvocate Podcast
    • Terms and Conditions
    • Privacy Policy
  • Topics
    • Assistive Technology
    • Child Development Tech
    • Early Childhood & K-12 EdTech
    • EdTech Futures
    • EdTech News
    • EdTech Policy & Reform
    • EdTech Startups & Businesses
    • Higher Education EdTech
    • Online Learning & eLearning
    • Parent & Family Tech
    • Personalized Learning
    • Product Reviews
  • Advertise
  • Tech Edvocate Awards
  • The Edvocate
  • Pedagogue
  • School Ratings

logo

The Tech Edvocate

  • Start Here
    • Our Brands
    • Governance
      • Lynch Educational Consulting, LLC.
      • Dr. Lynch’s Personal Website
        • My Speaking Page
      • Careers
    • Write For Us
    • The Tech Edvocate Product Guide
    • Contact Us
    • Books
    • Edupedia
    • Post a Job
    • The Edvocate Podcast
    • Terms and Conditions
    • Privacy Policy
  • Topics
    • Assistive Technology
    • Child Development Tech
    • Early Childhood & K-12 EdTech
    • EdTech Futures
    • EdTech News
    • EdTech Policy & Reform
    • EdTech Startups & Businesses
    • Higher Education EdTech
    • Online Learning & eLearning
    • Parent & Family Tech
    • Personalized Learning
    • Product Reviews
  • Advertise
  • Tech Edvocate Awards
  • The Edvocate
  • Pedagogue
  • School Ratings
  • The Hidden Cost of EVs: Why Your Battery Could Cost More Than Your Car in 2026

  • Jensen Huang’s Shock Exit: This Unbelievable Scandal Just Rocked Nvidia and the AI World

  • Big Walk developer House House Confirms ‘Sparing’ Use of Gen AI – Press Start

  • Baffling: How a Cyber Breach at South Korea’s Top Security Watchdog Exposed Millions

  • Wenn Ordnung den Bildschirm beruhigt: Warum klare Abläufe Casino-Unterhaltung einladender machen

  • Reddit AI Reviews: The Quiet Reshaping of Online Opinion

  • The Chilling Truth: Iran Cyberattacks Europe’s Food and Blood Supplies

  • Anthropic’s $3.4 Billion Bet on Gas: The Unseen Cost of AI’s Future

  • Tribit FlyBuds C3 Earbuds: Premium Features at a Budget-Friendly Price

  • Is AuraCam Pro’s Emotional AI a Privacy Nightmare or Security Breakthrough?

EdTech & Innovation
Home›EdTech & Innovation›Strikethrough in Excel: How to Cross Out Text in Cells

Strikethrough in Excel: How to Cross Out Text in Cells

By Matthew Lynch
February 20, 2024
0
Spread the love

Working with Microsoft Excel, users often find a need to mark information as obsolete or completed without removing it entirely from their spreadsheet. This is where the strikethrough feature comes in handy, allowing you to cross out text in individual cells or ranges of cells with ease.

Strikethrough is a typographical presentation of words with a horizontal line through their center, implying that the text is incorrect or no longer relevant. In Excel, this effect can be applied quickly and easily using several methods.

Method 1: Use the Format Cells Dialog

1.Select the cell or range of cells where you want to apply the strikethrough.

2.Right-click and choose ‘Format Cells’ from the context menu. Alternatively, you can press Ctrl+1 as a shortcut.

3.In the Format Cells dialog box, navigate to the ‘Font’ tab.

4.Under Effects, check ‘Strikethrough’ and click OK.

5.Your selected text will now appear crossed out.

Method 2: The Ribbon Command

1.Highlight the cells you wish to strike through.

2.Go to the Home tab on the Excel ribbon.

3.In the Font group, you’ll see a button with an “ab” icon with a strikethrough – click it.

4.This method toggles strikethrough on and off for selected cells.

Method 3: Keyboard Shortcut

For those who prefer keyboard shortcuts for efficiency:

1.Select the text you want to strike through.

2.Press Ctrl+5 on your keyboard.

If you ever need to remove strikethrough, simply reapply the same steps above to toggle it off.

Conditional Strikethrough

For dynamic spreadsheets, conditional formatting can be used to automatically apply strikethrough based on certain conditions:

1.Select your range of cells.

2.Go to the Home tab and select Conditional Formatting.

3.Choose ‘New Rule’.

4.Select ‘Format only cells that contain’.

5.Change the rule description so that it fits your condition (for instance, cell value equal to “Done”).

6.Click Format, navigate to Font tab, select Strikethrough and press OK twice.

Now whenever a cell meets your set condition, it will automatically have a strikethrough format applied to it.

Using strikethrough in Excel allows for better management of tasks or lists directly within your workbook without deleting anything permanently or affecting the readability of your data.

Remember that formatting such as strikethrough should be used meaningfully since overusing it could lead to visual clutter and reduce efficiency in your spreadsheet management. Responsible use of such tools helps maintain clarity and professionalism in your documents.

Conclusion:

The strikethrough feature in Excel is an effective way to visually communicate completion or negation of certain entries without removing data entirely from view. Whether using manual methods or conditional formatting, this feature adds flexibility and efficiency in managing data within spreadsheets.

Previous Article

How to Add Apps to Folders on ...

Next Article

4 Ways to Share Google Form Responses ...

Matthew Lynch

Related articles More from author

  • EdTech & Innovation

    Benefits Of Interactive Training In The Workplace

    March 23, 2023
    By Matthew Lynch
  • EdTech & Innovation

    The 10 Best Dog Boarding Services Near Me

    August 25, 2023
    By Matthew Lynch
  • EdTech & Innovation

    How to Watch ‘Peter and the Wolf’: Stream New Animated Film From Anywhere

    February 2, 2024
    By Matthew Lynch
  • EdTech & Innovation

    Best Gifts For Your Dungeons & Dragons Group

    March 20, 2024
    By Matthew Lynch
  • EdTech & Innovation

    9 Best Chrome Extensions to Convert Video to Text

    March 25, 2024
    By Matthew Lynch
  • EdTech & Innovation

    Discover The Amazing History Of The LMS

    March 20, 2023
    By Matthew Lynch

Search

Login & Registration

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Newsletter

Signup for The Tech Edvocate Newsletter and have the latest in EdTech news and opinion delivered to your email address!

About Us

Since technology is not going anywhere and does more good than harm, adapting is the best course of action. That is where The Tech Edvocate comes in. We plan to cover the PreK-12 and Higher Education EdTech sectors and provide our readers with the latest news and opinion on the subject. From time to time, I will invite other voices to weigh in on important issues in EdTech. We hope to provide a well-rounded, multi-faceted look at the past, present, the future of EdTech in the US and internationally.

We started this journey back in June 2016, and we plan to continue it for many more years to come. I hope that you will join us in this discussion of the past, present and future of EdTech and lend your own insight to the issues that are discussed.

Newsletter

Signup for The Tech Edvocate Newsletter and have the latest in EdTech news and opinion delivered to your email address!

Contact Us

The Tech Edvocate
910 Goddin Street
Richmond, VA 23231
(601) 630-5238
[email protected]

Copyright © 2026 Matthew Lynch. All rights reserved.