Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

Worth $20, Absolutely Free

Apply Strikethrough

A few days back, I wrote about different ways to add a check mark for completed tasks. But there also one more thing which we can use: That’s Strikethrough.

It means to draw a line through a value in a cell.

In Microsoft Word, the option for striking through a text is there on the home tab of the ribbon. So it’s really easy to apply it.

When it comes to Excel, we don’t have any direct option to apply strikethrough to a cell. No button or an option is there on the ribbon.

But it doesn’t mean that we can’t do that. In fact, we have more than one method for this.

So today, in this post, I’d like to share with you 5 different methods which you can use to apply strikethrough in Excel.

So, let’s get started.

1. Apply Strikethrough with a Shortcut Key

OK so look.

Let’s say you’re in hurry and don’t want to waste your time, then a keyboard shortcut is a perfect option for you. To apply strikethrough on a cell you can use:

shortcut key strikethrough windows excel

And, if you are using Mac then you can use the shortcut key:

shortcut key strikethrough mac excel

But here’s the kicker:

If you want to apply this to a particular part of the text in a cell then you can edit the cell and select only that part of the text, after that use the shortcut key.

And, if you want to apply it more than one cell then you select the entire range or select the non-continues range and the use the shortcut.

2. Add Strikethrough Icon on Quick Access Toolbar

You might be wondering.

Yes, that’s right we can add a button on QAT for strikethrough and then a single click every time. Follow these steps for this one time set up.

  • First of all, go to File → Options → Quick Access Toolbar.
  • After that, from “Choose commands from” select “Commands Not in the Ribbon”.
  • Now, select “Strikethrough” from the list and add it to the QAT.
  • Click OK.

Now you have an icon of QAT and you can apply strikethrough with a single click.

This button also works if you want to apply it on a particular part of a text and on multiple cells.

Check this out ==> Leading Zeros in Excel

3. Use Format Options To Apply Strikethrough

The real thing is here.

As I said there is no direct option in Excel for strikethrough, but actually, there’s a option which you can access from format options.

This is what you need to do.

  • Select all the cells on which you want to apply it.
  • Use sthortcut key ctrl + 1 to open the format options.
  • In font tab, tick mark the strikethrough option.
  • Click OK.

It works same like other options. You can apply it on multiple cells and on the partial text.

Want to know the best part?

You can also access to other formatting options which are no where on the ribbon through the same.

4. Apply Strikethrough with a Macro Code

Think out of the box.

Macro codes work like a charm. And, if you want to use a VBA for strikethrough here is the code for you.

Sub addstrikethrough()
Dim rng As Range
For Each rng In Selection
rng.Font.Strikethrough = True
Next rng
End Sub

Above code will help you to apply strikethrough on selected cells. You can also asign it on a shape to create a button.

Check this out ==> 101 Macro Code Examples

5. Apply Strikethrough with Conditional Formatting

Get to the next level.

Conditional formatting is one of the best way to apply formatting in a smart way.

Look at the below check list where I have used a check box with conditional formatting to apply strikethrough.

Whenever you mark a check box, the text in the corresponding cell will get a cut through line.

Here’s how can you this.

  • First of all, insert check box in the worksheet.
  • After that, link to cell A1 and change font color of A1 to white.
  • Select cell B1, go to Home Tab → Styles → Conditional Formatting → New Rule.
  • Select “Use a formula to determine which cell to format” option.
  • Enter below formula in the formula input bar.
  • =IF(A1=TRUE,TRUE,FALSE)
  • Now, click on format option and tick mark the strikethrough.
  • Click OK twice.

Now, whenever you tick the checkbox, the text in the cell will get a cut line on it.

[Bonus Tip] Applying Strikethrough in Online Excel

If you use Excel web app then you must be happy because there is an option there on Ribbon which you can use to apply strikethrough.

Remove Strikethrough from a Cell

It’s really easy to remove strikethrough from a cell. You just need to use shortcut key (Control + 5) again.

Important Note: If you have applied it through conditional formatting then you can’t remove it with the shortcut key unless you remove the entire formatting from the cell.

Conclusion

You can also copy-paste strikethrough from one cell to another cell using format painter. Learn more about format painter from here.

So, that’s the whole story about applying strikethrough in Excel. You have 5 + 1 different methods to for this and all are easy to apply.

I hope this tip will help you get better at Excel.

😃

Now tell me one thing. Do you have any other method to apply strikethrough? And, which one is your favorite method? Share with me the comment section, I would love to hear from you.

And, please don’t forget to share this tip with your friends.