How to apply Strikethrough in Excel [Shortcut + Command]

Search
Generic filters

Table of Contents

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 perfect option for you is keyboard shortcut. To apply strikethrough on a cell you can use:

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

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 to more than one cell then you select the entire range or select the non-continues range of cells and then use the shortcut.

 Add a Strikethrough Button to QAT

You might be wondering. Yes, that’s right  a button can be added on QAT for strikethrough and then a single click every time. Here are the  few steps for this one-time setup.

 
  1. At first, go to File ➜ Options ➜ Quick Access Toolbar.
  2. Then, from “Choose commands from” select “Commands Not in the Ribbon”.
  3.  After this, select “Strikethrough” from the list and add it to the QAT.
  4. At last, click OK.

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

 

 Also ,this button works if you want to apply it to a particular part of a text and on multiple cells.

Apply Strikethrough from Format Option

As I said there is no direct option in Excel for strikethrough, but actually, there’s an option that you can access from format options. This is what you need to do.

    1. At first, select all the cells on which you want to apply it.
  1. After this, use shortcut key ctrl + 1 to open the format options.
  2. In the font tab, tick marks the strikethrough option.
  3. Then , Click OK.

It works the same as other options. You can apply it on multiple cells and on the partial text. Want to know the best part? You can easily access other formatting options which are nowhere on the ribbon through the same.

Run a VBA Code to Apply Strikethrough

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

The above code would help you to apply strikethrough on selected cells. You can also assign it into a shape to create a button.

Use Conditional Formatting to Apply Strikethrough

Conditional formatting is one of the best ways to apply formatting in a latest way. Given below  is checklist where I have used a check box with conditional formatting to apply strikethrough.

Whenever you tick a check box, the text in the corresponding cell will get a cut-through line. Here’s how you can do this.

  1. Firstly , insert a check box in the worksheet.
  2. Second, link to cell A1 and change the font color of A1 to white.
  3. After  that select cell B1, go to Home Tab → Styles → Conditional Formatting → New Rule.
  4. Then Select the “Use a formula to determine which cell to format” option.
  5. Enter =IF(A1=TRUE,TRUE,FALSE)in the formula input bar.
  6. Now, click on the format option and select the strikethrough.
  7. At last ,click OK twice.

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

 

[Bonus Tip] Apply Strikethrough in Excel Online

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

 

Remove Strikethrough from a Cell

It is  really easy to remove strikethrough from a cell. By using the shortcut key (Control + 5) again. Important Note: If you have applied it through conditional formatting then you cannot 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. So, that’s the whole story about applying strikethrough in Excel. You have 5 + 1 different methods for this and all are easy to apply. I hope this tip will help you get better at Excel.

We Create Your Life Easy With Our Free Excel Templates & Spreadsheet Dashboards

Use free Excel Templates, Tools and Dashboards to create and draft a professional looking dashboards and computation sheet for your personal and business use. You can Explore Calendars, Activity Planners, Invoice Templates, Sales Forecast Sheets, Budget templates and various business information delivering Templates in Excel and Spreadsheet at XLSX Templates. 

These templates, dashboards and tools are useful in various occasions. You can also customize these templates as per your requirement. Modification of fields and data source helps in making the template more relevant.

Learn Microsoft Excel : Blogs and Articles

Learn about various tips and tricks in Microsoft Excel and Spreadsheet. Create best templates and dashboards using free tricks and tutorials in excel and spreadsheet. These tutorial posts are useful for everyone who wants to master the skills in excel and spreadsheet.

Deselect Cells in Excel

How To Deselect Cells in Excel

Table of Contents How to Deselect Cells in Excel After adding the deselecting cells feature in Excel, this  becomes so  …

Select Non-Contiguous Cells in Excel

Learn how to Select Non-Contiguous Cells in Excel

Table of Contents Select cell without using Ctrl Key By following these simple steps we can do it. At first, …

Format Painter in Excel

How to use Format Painter in Excel

Table of Contents Where’s the Format Painter Button? It’s there on your Home Tab. If you look at the clipboard …

Apply Strikethrough in Excel [Shortcut + Command]

How to apply Strikethrough in Excel [Shortcut + Command]

Table of Contents Shortcut Key to Apply Strikethrough to a Cell Let’s say you’re in hurry and don’t want to …

Formula Bar in Excel

Formula Bar in Excel

Table of Contents Key Points To Consider Using Formula Bar You can hide or unhide the formula bar. You can …

Convert Date into Day

Convert Date into Day Sub date2day() Dim tempCell As Range Selection.Value = Selection.Value For Each tempCell In Selection If IsDate(tempCell) …

Basic VBA Macro Codes in Excel

Custom Header & Footer

Sub CustomHeader() Dim myText As String myText = InputBox(“Enter your text here”, “Enter Text”) With ActiveSheet.PageSetup .LeftHeader = “” .CenterHeader …

Get Macro Code

Add Header and Footer Date

Sub DateInHeader() With ActiveSheet.PageSetup .LeftHeader = “” .CenterHeader = “&D” .RightHeader = “” .LeftFooter = “” .CenterFooter = “” .RightFooter …

Get Macro Code

Open Calculator

Sub OpenCalculator() Application.ActivateMicrosoftApp Index:=0 End Sub In Windows, there is a specific calculator and by using this macro code you …

Get Macro Code

Unmerge Cells

Sub UnmergeCells() Selection.UnMerge End Sub Unmerge Cells code simply uses the unmerge options which you have on the HOME‌ tab. …

Get Macro Code

Remove Text Wrap

Sub RemoveTextWrap() Range(“A1”).WrapText = False End Sub This code will help you to remove text wrap from the entire worksheet …

Get Macro Code

Auto Fit Rows

Sub AutoFitRows() Cells.Select Cells.EntireRow.AutoFit End Sub You can use this code to auto-fit all the rows in a worksheet. When …

Get Macro Code

Auto Fit Columns

Sub AutoFitColumns() Cells.Select Cells.EntireColumn.AutoFit End Sub Use above Excel macro code to auto fit rows in all your sheet at …

Get Macro Code

Insert Multiple Columns

Sub InsertMultipleColumns() Dim i As Integer Dim j As Integer ActiveCell.EntireColumn.Select On Error GoTo Last i = InputBox(“Enter number of …

Get Macro Code

Insert Multiple Rows

Sub InsertMultipleRows() Dim i As Integer Dim j As Integer ActiveCell.EntireRow.Select On Error GoTo Last i = InputBox(“Enter number of …

Get Macro Code