How to Strikethrough Text in Excel?

Do you want to learn how to strikethrough text in Excel? Striking out text in Excel can be a great way to emphasize certain segments of data, or to indicate that a particular task has been completed. In this tutorial, we will provide step-by-step instructions on how to strikethrough text in Excel. We will also discuss why you might want to use strikethrough, as well as some other useful formatting tips. So, let’s get started!

Using Excel’s Strikethrough Feature

Strikethrough text can be useful when you need to highlight certain words or phrases in a document. Excel offers a simple and easy way to strikethrough text directly in a cell. This guide will show you how to use the Strikethrough feature in Excel.

The Strikethrough feature in Excel is located in the Font group on the Home tab. To use the Strikethrough feature, select the cell or range of cells that you want to strikethrough and click the Strikethrough button. This will add a line through the text in the selected cell or cells.

You can also use the keyboard shortcut to activate the Strikethrough feature. To do this, select the cell or range of cells that you want to strikethrough and press the Ctrl + 5 keys. This will add a line through the text in the selected cell or cells.

Removing Strikethrough Text in Excel

If you have strikethrough text in your spreadsheet and you want to remove it, there are a few ways to do this. The first option is to select the cell or range of cells that has the strikethrough text and click the Strikethrough button again. This will remove the line from the text in the selected cell or cells.

The second option is to use the keyboard shortcut to remove the Strikethrough feature. To do this, select the cell or range of cells that has the strikethrough text and press the Ctrl + 5 keys. This will remove the line from the text in the selected cell or cells.

Using the Format Cells Dialog Box

If you want more control over the Strikethrough feature, you can use the Format Cells dialog box. To access the Format Cells dialog box, select the cell or range of cells that you want to strikethrough and click the Format Cells button on the Home tab.

In the Format Cells dialog box, select the Font tab and select the Strikethrough checkbox. This will add a line through the text in the selected cell or cells. To remove the Strikethrough feature, simply uncheck the Strikethrough checkbox.

Using a Keyboard Shortcut to Toggle Strikethrough

If you want to quickly toggle the Strikethrough feature on and off, you can use the keyboard shortcut Ctrl + Shift + 5. This shortcut will toggle the Strikethrough feature on and off for the selected cell or cells.

Using Conditional Formatting to Add Strikethrough

You can also use Conditional Formatting to add strikethrough text in Excel. To use Conditional Formatting, select the cell or range of cells that you want to strikethrough and click the Conditional Formatting button on the Home tab.

In the Conditional Formatting dialog box, select the Text that Contains option and enter a specific character or phrase. Then select the Strikethrough option and click OK. This will add a line through the text in the selected cell or cells that matches the character or phrase that you specified.

Using a Macro to Add Strikethrough

If you want to add strikethrough text to multiple cells, you can use a macro. To do this, open the Visual Basic Editor (VBE) and enter the code below. This code will add a line through the text in the selected cell or cells.

Sub StrikethroughSelection()
Selection.Font.Strikethrough = True
End Sub

Once you have entered the code, select the cell or range of cells that you want to strikethrough and run the macro. This will add a line through the text in the selected cell or cells.

Using a Formula to Add Strikethrough

If you want to add strikethrough text to a cell based on a condition, you can use a formula. To do this, enter the formula below into the cell that you want to strikethrough. This formula will add a line through the text in the cell if a certain condition is met.

=IF(condition, “Strikethrough”, “”)

Replace the condition with an expression that will evaluate to either TRUE or FALSE. If the condition evaluates to TRUE, the cell will be strikethrough. If the condition evaluates to FALSE, the cell will not be strikethrough.

Related Faq

What is Strikethrough Text in Excel?

Strikethrough text in Excel is a formatting option that displays text with a horizontal line through it. This feature is used to indicate that the text should not be included in calculations or when sorting data. It is usually used to indicate that the text is obsolete or no longer relevant to the spreadsheet.

How Do You Strikethrough Text in Excel?

Strikethrough text in Excel can be applied to a single cell or a range of cells. To apply the strikethrough format, select the cell or range of cells that you want to apply the formatting to, then open the Format Cells dialogue box by pressing CTRL + 1. In the Format Cells dialogue box, select the Font tab and check the Strikethrough checkbox. Then, click OK to apply the formatting.

How Do You Remove Strikethrough Text in Excel?

Removing strikethrough text in Excel is done in much the same way as applying it. Select the cell or range of cells that you want to remove the strikethrough formatting from, then open the Format Cells dialogue box by pressing CTRL + 1. In the Format Cells dialogue box, select the Font tab and uncheck the Strikethrough checkbox. Then, click OK to remove the formatting.

Can You Strikethrough Text in Multiple Cells at Once?

Yes, you can apply strikethrough text to multiple cells at once in Excel. To do this, select the range of cells you want to apply the formatting to, then open the Format Cells dialogue box by pressing CTRL + 1. In the Format Cells dialogue box, select the Font tab and check the Strikethrough checkbox. Then, click OK to apply the formatting.

What is the Keyboard Shortcut for Applying Strikethrough in Excel?

The keyboard shortcut for applying strikethrough in Excel is CTRL + 5. To use this shortcut, select the cell or range of cells you want to apply the formatting to, then press CTRL + 5. This will apply the strikethrough formatting to the cells without having to open the Format Cells dialogue box.

Can You Strikethrough Text in Charts in Excel?

Yes, you can apply strikethrough text to text in charts in Excel. To do this, select the text in the chart that you want to apply the formatting to, then open the Format Cells dialogue box by pressing CTRL + 1. In the Format Cells dialogue box, select the Font tab and check the Strikethrough checkbox. Then, click OK to apply the formatting.

Strikethrough Shortcut in Excel (Keyboard Shortcuts)

In conclusion, knowing how to strikethrough text in Excel is a useful skill to have! Whether you are a student, a professional, or a hobbyist, being able to strike through text in Excel can help organize and streamline your work. With just a few simple steps, you can easily add strikethroughs to your Excel documents.