Excel Shortcut: How to Strikethrough Cells in Seconds

Excel Strikethrough Shortcuts

Excel is a powerful tool for managing data, and there are many keyboard shortcuts that can help you work more efficiently. One of the most useful shortcuts is the ability to apply strikethrough formatting to cells. This can be helpful when you want to mark items as completed or indicate that they are no longer relevant.

Windows Keyboard Shortcuts

To apply strikethrough formatting in Excel on Windows, you can use the following keyboard shortcut:

• Ctrl + 5: This will apply strikethrough formatting to the selected cells.

You can also use the following steps to apply strikethrough formatting in Excel on Windows:

1. Select the cells that you want to format.
2. Right-click on the selection and choose “Format Cells” from the context menu.
3. In the Format Cells dialog box, click on the “Font” tab.
4. Check the “Strikethrough” box under “Effects.”
5. Click “OK” to apply the formatting.

Excel for Mac Keyboard Shortcuts

If you’re using Excel on a Mac, you can use the following keyboard shortcut to apply strikethrough formatting:

• Command + Shift + X: This will apply strikethrough formatting to the selected cells.

You can also use the following steps to apply strikethrough formatting in Excel on a Mac:

1. Select the cells that you want to format.
2. Click on the “Format” menu and choose “Cells” from the dropdown.
3. In the Format Cells dialog box, click on the “Font” tab.
4. Check the “Strikethrough” box under “Effects.”
5. Click “OK” to apply the formatting.

By using these shortcuts, you can quickly apply strikethrough formatting to your cells in Excel. This can help you save time and work more efficiently.

Formatting Cells in Excel

Excel provides several options to format cells, including changing the font, font size, font color, and more. Formatting cells can make it easier to read and understand data, and it can also help to highlight important information. Here are two ways to format cells in Excel:

Using the Format Cells Dialog Box

The Format Cells dialog box provides a wide range of formatting options for cells. To access this dialog box, follow these steps:

1. Select the cells you want to format.
2. Right-click the selected cells and choose Format Cells from the context menu.
3. In the Format Cells dialog box, click the Font tab to access font settings.
4. To apply strikethrough formatting, select Strikethrough under the Effects section.
5. Click OK to apply the formatting.

Working with the Quick Access Toolbar

The Quick Access Toolbar (QAT) is a customizable toolbar that provides quick access to frequently used commands. You can add the Strikethrough command to the QAT to quickly apply strikethrough formatting to selected cells. Here’s how:

1. Select the cells you want to format.
2. Click the QAT dropdown arrow and choose More Commands.
3. In the Excel Options dialog box, select All Commands from the Choose commands from dropdown list.
4. Scroll down and select Strikethrough from the list of commands.
5. Click Add to add the command to the QAT.
6. Click OK to close the dialog box.
7. To apply strikethrough formatting, select the cells you want to format and click the Strikethrough button on the QAT.

By following these steps, you can easily format cells in Excel and apply strikethrough formatting to cell contents. If you want to remove strikethrough formatting, simply follow the same steps and uncheck the Strikethrough option.

Advanced Strikethrough Techniques

Conditional Formatting and Strikethrough

Conditional formatting is a powerful tool in Excel that allows you to format cells based on specific conditions. With conditional formatting, you can easily add strikethrough to cells that meet certain criteria. Here’s how:

1. Select the cells you want to apply strikethrough to.
2. Click on the “Conditional Formatting” button in the “Home” tab.
3. Choose “New Rule”.
4. Select “Use a formula to determine which cells to format”.
5. Enter the formula “=CELLS=VALUE” where “CELLS” is the range of cells you want to apply strikethrough to and “VALUE” is the value that triggers the strikethrough.
6. Click on the “Format” button and choose “Font”.
7. Check the box next to “Strikethrough” and click “OK”.
8. Click “OK” again to apply the rule.

VBA and Strikethrough

VBA (Visual Basic for Applications) is a programming language that allows you to automate tasks in Excel. With VBA, you can add strikethrough to cells based on any condition you can think of. Here’s an example:

Sub AddStrikethrough()
    Dim cell As Range
    For Each cell In Selection
        If cell.Value = "Complete" Then
            cell.Font.Strikethrough = True
        End If
    Next cell
End Sub

This code adds strikethrough to any cell in the selected range that contains the word “Complete”. To use this code, simply select the range of cells you want to apply strikethrough to and run the macro.

In addition to these techniques, there are other ways to add strikethrough to cells in Excel, such as using the “Format Cells” dialog box, double-clicking on the cell and adding a line break, or using checkboxes in a to-do list. With these advanced techniques, you can take your Excel skills to the next level and make your projects more organized and efficient.