Get all your news in one place.
100’s of premium titles.
One app.
Start reading
Laptop
Laptop
Technology
Rami Tabari

How to strikethrough in Excel

How to strikethrough in Excel.

Whether you're dominating a complex spreadsheet or clearing out a laundry list of tasks, learning how to strikethrough text is critical for your sanity, and it's especially true in Excel.

Looking to become an Excel guru? We've covered other Excel how-to topics, like how to subtract in Excelhow to filter in Excel, and how to make a graph in Excel.

Otherwise, here's how to strikethrough in Excel.

How to strikethrough in Excel

Method 1: The easiest way to do it is with a shortcut. The shortcut to strikethrough in Excel is Ctrl+5.

(Image credit: Microsoft)

Method 2: If you don't have easy access to a keyboard, you'll want to first select the text and/or cells you want to strikethrough. Then navigate to Home > Font > Strikethrough.

Method 3: You can also be extra by using a formula to strikthrough. A simple example being =STRIKETHROUGH(A1) — that would strikethrough cell A1.

There's more than one way to strikethrough in Excel, and that shouldn't come as a surprise to anyone who's spent more than two seconds looking at the ridiculous number of options the spreadsheet app has to offer.

Strikethrough everything!

Sign up to read this article
Read news from 100’s of titles, curated specifically for you.
Already a member? Sign in here
Related Stories
Top stories on inkl right now
One subscription that gives you access to news from hundreds of sites
Already a member? Sign in here
Our Picks
Fourteen days free
Download the app
One app. One membership.
100+ trusted global sources.