Home > Microsoft Office > Microsoft Office How To

How to strikethrough in Excel using shortcut and font settings

Here are three methods that can help you strikethrough text in Excel!
Last Updated on February 22, 2024
The Microsoft Excel logo on a white background features a strikethrough design.
You can trust PC Guide: Our team of experts use a combination of independent consumer research, in-depth testing where appropriate - which will be flagged as such, and market analysis when recommending products, software and services. Find out how we test here.

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.

How to strikethrough Excel

Step

3

Select strikethrough

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

How to strikethrough Excel

Your text will now appear like this:

A screenshot of a spreadsheet with a strikethrough in Excel.

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.

Learn how to strikethrough Excel

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.

A screenshot of a customer name with a strikethrough in an Excel spreadsheet.

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:

Andrew is one of three co-founders of BGFG, the parent company of PC Guide. A keen gamer and PC enthusiast, Andrew dabbles in a bit of writing sometimes - when he gets the chance to!