5 Ways To Strikethrough Text In Excel

Introduction to Strikethrough Text in Excel

When working with Excel, formatting text is an essential part of making your spreadsheets more readable and understandable. One of the formatting options that can be particularly useful is the strikethrough feature. Strikethrough text appears with a line through the middle of it, indicating that the text is cancelled, incorrect, or not applicable. In this blog post, we will explore 5 different ways to apply strikethrough formatting to text in Excel.

Method 1: Using the Font Dialog Box

The first method to strikethrough text in Excel is by using the Font dialog box. This method provides a straightforward way to apply strikethrough formatting to selected text. Here’s how to do it: * Select the cell or range of cells that contain the text you want to format. * Right-click on the selected cell or range and choose “Format Cells” from the context menu. * In the Format Cells dialog box, click on the “Font” tab. * Check the box next to “Strikethrough” to apply the formatting. * Click “OK” to apply the changes.

Method 2: Using the Ribbon

Another way to apply strikethrough formatting in Excel is by using the Ribbon. This method is quicker than the first method, especially if you are working with Excel 2013 or later versions. Here’s how to do it: * Select the cell or range of cells that contain the text you want to format. * Go to the “Home” tab in the Ribbon. * Click on the “Font” group dialog box launcher (the small arrow in the bottom-right corner of the “Font” group). * In the Font dialog box, check the box next to “Strikethrough” to apply the formatting. * Click “OK” to apply the changes.

Method 3: Using Keyboard Shortcut

If you prefer to use keyboard shortcuts, you can apply strikethrough formatting using the following shortcut: * Select the cell or range of cells that contain the text you want to format. * Press Ctrl + 5 to apply strikethrough formatting.

Method 4: Using Conditional Formatting

You can also apply strikethrough formatting using Conditional Formatting. This method is useful when you want to apply the formatting based on a condition or a formula. Here’s how to do it: * Select the cell or range of cells that contain the text you want to format. * Go to the “Home” tab in the Ribbon. * Click on “Conditional Formatting” in the “Styles” group. * Choose “New Rule” and then select “Use a formula to determine which cells to format”. * Enter a formula that determines when the text should be formatted with strikethrough. * Click on the “Format” button and check the box next to “Strikethrough” to apply the formatting. * Click “OK” to apply the changes.

Method 5: Using VBA Macro

The final method to apply strikethrough formatting in Excel is by using a VBA macro. This method is useful when you want to automate the formatting process or apply it to a large range of cells. Here’s an example of how to create a VBA macro to apply strikethrough formatting:

Step	Code
1. Open the Visual Basic Editor	Press Alt + F11 or navigate to Developer > Visual Basic
2. Insert a new module	Click “Insert” > “Module” in the Visual Basic Editor
3. Enter the code	Enter the following code: Range(“A1”).Font.Strikethrough = True
4. Run the macro	Press F5 or click “Run” > “Run Sub/UserForm” in the Visual Basic Editor

📝 Note: Make sure to replace “A1” with the actual range of cells you want to format.

To summarize, there are several ways to apply strikethrough formatting to text in Excel, including using the Font dialog box, the Ribbon, keyboard shortcuts, Conditional Formatting, and VBA macros. Each method has its own advantages and disadvantages, and the choice of method depends on your personal preference and the specific requirements of your project.