5 Ways Excel Strikethrough

Introduction to Excel Strikethrough

Excel is a powerful tool used for various purposes, including data analysis, budgeting, and more. One of the features that can enhance the readability and presentation of data in Excel is the strikethrough feature. Strikethrough in Excel allows users to strike a line through text, indicating that the information is incorrect, cancelled, or no longer applicable. In this article, we will explore five ways to apply strikethrough in Excel.

Method 1: Using the Font Dialog Box

To apply strikethrough using the Font dialog box, follow these steps: * Select the cell or range of cells that you want to format. * Right-click on the selection and choose Format Cells. * In the Font dialog box, check the box next to Strikethrough. * Click OK to apply the changes.

📝 Note: You can also access the Font dialog box by pressing Ctrl + 1 on your keyboard.

Method 2: Using the Ribbon

You can also apply strikethrough using the Ribbon in Excel. Here’s how: * Select the cell or range of cells that you want to format. * Go to the Home tab in the Ribbon. * Click on the Font group dialog box launcher. * In the Font dialog box, check the box next to Strikethrough. * Click OK to apply the changes.

Method 3: Using Keyboard Shortcuts

If you want to apply strikethrough quickly, you can use keyboard shortcuts. Here’s how: * Select the cell or range of cells that you want to format. * Press Ctrl + 5 on your keyboard to toggle strikethrough on and off.

Method 4: Using Conditional Formatting

You can also apply strikethrough using Conditional Formatting in Excel. Here’s how: * Select the cell or range of cells that you want to format. * Go to the Home tab in the Ribbon. * Click on Conditional Formatting. * Choose New Rule. * Select Use a formula to determine which cells to format. * Enter a formula that meets your conditions. * Click on the Format button. * Check the box next to Strikethrough. * Click OK to apply the changes.

Method 5: Using VBA Macro

If you want to apply strikethrough to a large range of cells, you can use a VBA macro. Here’s an example code:

Sub ApplyStrikethrough()
    Dim cell As Range
    For Each cell In Selection
        cell.Font.Strikethrough = True
    Next cell
End Sub

To use this macro, follow these steps: * Open the Visual Basic Editor by pressing Alt + F11. * Insert a new module by clicking Insert > Module. * Paste the code into the module. * Save the workbook as a macro-enabled file. * Select the cell or range of cells that you want to format. * Run the macro by pressing Alt + F8.

Method	Description
Font Dialog Box	Apply strikethrough using the Font dialog box.
Ribbon	Apply strikethrough using the Ribbon.
Keyboard Shortcuts	Apply strikethrough using keyboard shortcuts.
Conditional Formatting	Apply strikethrough using Conditional Formatting.
VBA Macro	Apply strikethrough using a VBA macro.

In summary, there are several ways to apply strikethrough in Excel, including using the Font dialog box, Ribbon, keyboard shortcuts, Conditional Formatting, and VBA macro. Each method has its own advantages and disadvantages, and the choice of method depends on the specific needs of the user.