How to strikethrough in Excel using shortcut and font settings

Table of Contents
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.
Top President's Day deals
This year's President's Day sales have officially kickstarted, offering up huge discounts on some of the market's leading tech products. Below, we'll list the best President's Day deals we can find.
- Samsung 990 PRO SSD 1 TB - WAS $159.99 NOW $99.99 Save - $60
- Alienware X16 R2 gaming laptop - WAS $3,099.99 NOW $2,499.99 Save - $600
- CLX Horus Gaming PC - WAS $3,749.99 NOW $$3,449.99 Save - $300
- Western Digital 8TB HD - WAS $204.99 NOW $179.99 Save - $25
- Samsung 85-inch Class Crystal UHD TV - WAS $1097.99 NOW $799 Save - $300
Prices and savings subject to change. Click through to get the current deal prices.
How to strikethrough using font settings
Here’s how you can strikethrough in Excel using the font settings.
Step
Select a cell
Select a cell which contains text.
Step
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
Select strikethrough
Finally, in Effects, check the box next to strikethrough, and click OK.
Your text will now appear like this:
How to strikethrough in Excel using shortcut
Alternatively, you can also use a keyboard shortcut to strikethrough text in Excel.
Step
Select the cell
Once again, select a cell or multiple cells with text in them.
Step
Use the keyboard shortcut
Now, press CTRL + 5 on your keyboard to strikethrough the text.
How to perform a partial strikethrough
In case you want to strikethrough a specific part of text in Excel, follow these steps.
Step
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
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: