How to strikethrough in Excel using shortcut and font settings

Last Updated on February 22, 2024

Want to learn how to strikethrough in Excel? You’ve come to the right place.

Excel is the perfect tool for organizing data. You can format cells in Excel using various options such as font size, font style, font color, background color, border color, etc. This makes it easier to read your data. It is often simple to find the correct formatting for your spreadsheet in Excel. However, one format that many people can’t seem to find is the strikethrough option.

This is where we come in. In this guide, we’ll walk you through how to strikethrough in Excel using three different methods.

1

How to strikethrough using font settings

Here’s how you can strikethrough in Excel using the font settings.

Step

1

Select a cell

Select a cell which contains text.

Step

2

Go to font settings

Next, click on the font settings icon, which can be found in the bottom right corner of the Font box in the Home tab.

Step

3

Select strikethrough

Finally, in Effects, check the box next to strikethrough, and click OK.

Your text will now appear like this:

2

How to strikethrough in Excel using shortcut

Alternatively, you can also use a keyboard shortcut to strikethrough text in Excel.

Step

1

Select the cell

Once again, select a cell or multiple cells with text in them.

Step

2

Use the keyboard shortcut

Now, press CTRL + 5 on your keyboard to strikethrough the text.

3

How to perform a partial strikethrough

In case you want to strikethrough a specific part of text in Excel, follow these steps.

Step

1

Select a part of text

First, go to the cell and select a part of the text, such as the last name of the full name.

Step

2

Perform a partial strikethrough

Now, either use the font settings method or press CTRL + 5 to perform a partial strikethrough.

Conclusion

As you can see, there are many ways in which you can strikethrough in Excel. In this guide, we mentioned three methods, with the third one focusing on a partial strikethrough. All methods can help you quickly strikethrough text, but we’d recommend opting for the keyboard shortcut method, as it is the quickest.

Learn more about Excel through these guides:

• How to autofill in Excel
• How to use IF and VLOOKUP nested functions in Excel
• How to add and use Developer tab in Excel