How to Apply Strikethrough in Excel [Shortcut + Command]

1. Shortcut Key to Apply Strikethrough to a Cell

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

2. Add a Strikethrough Button to QAT

You might be wondering. Yes, that’s right we can add a button on QAT for strikethrough and then a single click every time. Here are the steps for this one time set up.

  • 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.

3. Apply Strikethrough from Format Option

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. Run a VBA Code to Apply Strikethrough

5. Use 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 =IF(A1=TRUE,TRUE,FALSE)in the formula input bar.
  • 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] Apply Strikethrough in Excel Online

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.

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.

About the Author

puneet one point one

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.


7 thoughts

Leave a Comment

Your email address will not be published.

  1. Hello. How can I have a text in a cell and strikethrough the text and have conditional formatting highlight the cell with ctrl+5 without changing the text. Ex:I have a date with strikethrough and excel will highlight it in the formatting I want

  2. True to form, Puneet is spot-on with this tip. I use strikethrough so seldom that my most common method is to use the ‘format cells’ dialog. (My favorite keyboard shortcut for this is Ctrl + 1). But, since I am a big fan of keyboard shortcuts, the Ctrl + 5 method would quickly become part of my ‘toolbox’ of methods, should I start using the format more often.

  3. Hi – I’m really confused as I can’t get the process (changing regular text to strike-through text in one box based upon a selected checkbox (true value/checked)—which is exactly what I want to do, so thank you for the demo!— to work. Is it because I’m using Excel for Mac? I cannot locate this: Home Tab → Styles → Conditional Formatting → New Rule nor can I pull-up the ‘New Formatting Rule’ pop up window that you show above. Can you assist?