How to strikethrough in Excel

Strikethrough in Excel is a formatting option that puts a horizontal line through the center of a cell’s contents. It is often used to indicate that a particular item or task has been completed, or to indicate that it is no longer relevant.

However, there may be situations where you would want to remove strikethrough from your Excel cells. For example:

1. If you have used strikethrough to indicate completed tasks, but later need to update those tasks with new information, you may want to remove the strikethrough formatting to make the updates more visible.
2. If you are using a spreadsheet for accounting or financial purposes, strikethrough can be visually confusing and make it difficult to read important figures.
3. Strikethrough can also be used inadvertently, if you accidentally apply the formatting to a cell and then want to remove it.

In these cases, removing strikethrough can help to improve the clarity and accuracy of your Excel spreadsheet.

Excel strikethrough shortcut

The keyboard shortcut to apply strikethrough formatting in Excel is “Ctrl + 5” (press and hold the Ctrl key, then press the number 5).

To remove strikethrough formatting using a shortcut key in Excel, you can use the same shortcut: “Ctrl + 5”. This will toggle the strikethrough on and off.

Alternatively, you can remove strikethrough by selecting the cells with strikethrough formatting, right-clicking and selecting “Format Cells”, clicking on the “Font” tab and unchecking the “Strikethrough” box.

Draw a line through all values in a range

To draw a line through all values in a range in Excel, you can use the “strikethrough” formatting option. Here are the steps:

1. Select the range of cells that you want to apply the strikethrough formatting to.
2. Right-click on the selected range and click “Format Cells” or press Ctrl+1 on your keyboard.
3. In the Format Cells dialog box, click on the “Font” tab.
4. Check the “Strikethrough” checkbox and click “OK”.

This will apply the strikethrough formatting to all the values in the selected range.

Alternatively, you can use a formula to add a strikethrough line to the cell contents. For example, if you want to add a strikethrough line to the contents of cell A1, you can use the following formula in another cell:

=IF(A1<>"", CONCAT(STRIKE(A1)), "")

This formula checks if cell A1 is not empty, then applies the STRIKE function to add a strikethrough line to the cell contents, and returns an empty string if the cell is empty.

Strikethrough non-adjacent cells

To strikethrough non-adjacent cells in Excel, you can use the following steps:

1. Select the first cell that you want to apply the strikethrough formatting to.
2. Hold down the “Ctrl” key and continue selecting the other cells that you want to apply the formatting to.
3. Once you have selected all of the non-adjacent cells, right-click on one of the selected cells and click “Format Cells” or press Ctrl+1 on your keyboard.
4. In the Format Cells dialog box, click on the “Font” tab.
5. Check the “Strikethrough” checkbox and click “OK”.

This will apply the strikethrough formatting to all of the non-adjacent cells that you have selected.

Alternatively, you can use a formula to add a strikethrough line to the contents of non-adjacent cells.

For example, if you want to add a strikethrough line to the contents of cells A1, C1, and E1, you can use the following formula in another cell:

=CONCAT(STRIKE(A1)," ",STRIKE(C1)," ",STRIKE(E1))

This formula uses the STRIKE function to add a strikethrough line to each of the specified cells, and separates them with spaces using the concatenate operator “&”.

To cross out part of the cell value

To cross out part of a cell’s value in Excel, you can use the following steps:

1. Double-click on the cell that you want to edit.
2. Place your cursor at the beginning of the text that you want to cross out.
3. Press “Alt” + “=” on your keyboard. This will insert a strikethrough line in the formula bar.
4. Type the rest of the text that you want to leave unchanged.
5. Press “Enter” to save the changes.

The part of the text that you added the strikethrough line to will now be crossed out in the cell.

Alternatively, you can use conditional formatting to cross out part of a cell’s value based on a certain condition.

For example, if you want to cross out values in a column that are less than 0, you can use the following steps:

1. Select the column that you want to apply the conditional formatting to.
2. Click on the “Conditional Formatting” button in the “Home” tab of the ribbon, and select “New Rule”.
3. In the “New Formatting Rule” dialog box, select “Use a formula to determine which cells to format”.
4. Enter the formula “=A1<0” (assuming that your data starts in cell A1) in the formula field.
5. Click on the “Format” button to open the “Format Cells” dialog box.
6. Select the “Font” tab and check the “Strikethrough” checkbox.
7. Click “OK” to close the “Format Cells” dialog box.
8. Click “OK” again to close the “New Formatting Rule” dialog box.

This will cross out all values in the selected column that are less than 0.

Apply strikethrough via cell format options

You can apply strikethrough to a cell using format options in Excel by following these steps:

1. Select the cell or range of cells that you want to apply strikethrough to.
2. Right-click on the selected cell(s) and click on “Format Cells” in the dropdown menu, or click on “Format Cells” under the “Home” tab in the ribbon.
3. In the “Format Cells” dialog box, click on the “Font” tab.
4. Check the “Strikethrough” checkbox under the “Effects” section.
5. Click “OK” to close the “Format Cells” dialog box.

This will apply strikethrough formatting to the selected cell(s). Any content in the cell(s) will be crossed out by a horizontal line through the center of the text.

Note that this method applies formatting to an entire cell. If you want to cross out only part of the cell’s contents, you will need to use other methods such as inserting a strikethrough line into the formula bar, or manually adding a strikethrough character to the text.

Add a strikethrough button to Quick Access Toolbar

Adding a strikethrough button to the Quick Access Toolbar in Excel can be done by following these steps:

1. Click on the down arrow at the end of the Quick Access Toolbar, which is located above or below the ribbon.
2. Click on “More Commands” in the dropdown menu.
3. In the “Excel Options” dialog box that appears, select “All Commands” from the dropdown list under “Choose commands from”.
4. Scroll down and select “Strikethrough” from the list of commands.
5. Click on the “Add” button to add the “Strikethrough” command to the Quick Access Toolbar.
6. Click “OK” to close the “Excel Options” dialog box.

This will add a strikethrough button to the Quick Access Toolbar, which you can now use to quickly apply or remove strikethrough formatting to selected cells or text.

To use the strikethrough button, simply select the cell(s) or text that you want to apply formatting to, and then click on the strikethrough button in the Quick Access Toolbar.

If you want to remove the formatting, select the cell(s) or text again and click the strikethrough button once more.

Put a strikethrough button onto Excel ribbon

You can add a strikethrough button to the Excel ribbon by following these steps:

1. Right-click on any tab in the ribbon and select “Customize the Ribbon” from the dropdown menu.
2. In the “Excel Options” dialog box that appears, select the tab where you want to place the strikethrough button in the right-hand pane.
3. Click on the “New Group” button at the bottom of the right-hand pane to create a new group on the selected tab.
4. Click on the new group that appears in the right-hand pane to select it.
5. Click on the “Rename…” button below the right-hand pane and enter a name for the new group, such as “Formatting“.
6. Select “All Commands” from the dropdown list under “Choose commands from“.
7. Scroll down and select “Strikethrough” from the list of commands.
8. Click on the “Add” button to add the “Strikethrough” command to the new group.
9. Click “OK” to close the “Excel Options” dialog box.

This will add a new group, named “Formatting” (or whatever you chose to name it), with a Strikethrough button on the tab that you selected. You can now use this button to apply or remove strikethrough formatting to selected cells or text whenever you need it.

How to strikethrough automatically with conditional formatting

You can use conditional formatting to strikethrough automatically in Excel based on a certain condition. Here are the steps:

1. Select the cell range that you want to apply the conditional formatting to.
2. Click on “Conditional Formatting” under the “Home” tab in the ribbon, and select “New Rule“.
3. In the “New Formatting Rule” dialog box, select “Use a formula to determine which cells to format”.
4. Enter the formula that will evaluate to TRUE or FALSE for the selected cells. For example, if you want to strikethrough cells that contain the word “Completed”, enter the following formula: “=SEARCH(“completed”,A1)>0″.
5. Click on the “Format” button to open the “Format Cells” dialog box.
6. Select the “Font” tab and check the “Strikethrough” checkbox.
7. Click “OK” to close the “Format Cells” dialog box.
8. Click “OK” again to close the “New Formatting Rule” dialog box.

This will apply strikethrough automatically to any cell that meets the condition you specified in the formula.

Note that you can modify the formula and formatting options to suit your needs. Also, keep in mind that this method applies strikethrough to entire cells, not just specific parts of the cell contents.

Add strikethrough with a macro

You can add a strikethrough with a macro in Excel by following these steps:

1. Press “Alt + F11” on your keyboard to open the Visual Basic Editor.
2. Click on “Insert” and select “Module” to create a new module.
3. Copy and paste the following code into the module:

Sub AddStrike()
    With Selection.Font
        .Strikethrough = True
    End With
End Sub

4. Save the macro by clicking “File” and then “Save”.
5. Close the Visual Basic Editor.
6. To use the macro, select the cell(s) or range of cells that you want to apply strikethrough to.
7. Click on the “Developer” tab in the ribbon (if it is not visible, you can enable it by going to “File” > “Options” > “Customize Ribbon” and checking the box next to “Developer”).
8. Click on “Macros” in the “Code” section of the Developer tab.
9. Select the “AddStrike” macro from the list of macros and click “Run”.

This will apply strikethrough formatting to the selected cell(s).

Note that this macro applies strikethrough formatting to entire cells, not just specific parts of the cell contents. If you want to cross out only part of the cell’s contents, you will need to modify the macro accordingly.

How to use strikethrough in Excel Online

Using strikethrough in Excel Online is similar to using it in the desktop version of Excel. Here are the steps:

1. Log in to your Microsoft account and open your Excel Online workbook.
2. Select the cell or range of cells that you want to apply strikethrough to.
3. Click on the “Home” tab in the ribbon at the top of the screen.
4. Click on the “Font” dropdown menu in the ribbon and select “More fonts”.
5. In the font options window, check the “Strikethrough” checkbox.
6. Click “OK” to close the font options window.

This will apply strikethrough formatting to the selected cell(s). Any text in the cell(s) will be crossed out by a horizontal line through the center of the text.

Note that Excel Online may have some limitations compared to the desktop version of Excel, so not all features may be available. However, basic formatting options such as strikethrough are typically available in Excel Online.

How to strikethrough in Excel for Mac

You can strikethrough text in Excel for Mac using either a keyboard shortcut or the Font dialog box. Here are the steps:

1. Select the cell(s) that you want to apply strikethrough to.

2a. To use the keyboard shortcut, press “Command” + “Shift” + “X”.

2b. To use the Font dialog box, click on the “Home” tab in the ribbon and select “Format Cells” from the dropdown menu.

3. In the Format Cells dialog box, click on the “Font” tab if it is not already selected.
4. Check the “Strikethrough” checkbox.
5. Click “OK” to close the Format Cells dialog box.

This will apply strikethrough formatting to the selected cells.

Note that the specific steps may vary slightly depending on the version of Excel for Mac you are using. However, the keyboard shortcut and general process for applying strikethrough should be the same across most versions.

Remove strikethrough added manually

To remove strikethrough that has been added manually in Excel, you can use the following steps:

1. Select the cell(s) that contain the text with strikethrough.

2a. To use the keyboard shortcut, press “Command” + “Shift” + “X”.

2b. To use the Format Cells dialog box, click on the “Home” tab in the ribbon and select “Format Cells” from the dropdown menu.

3. In the Format Cells dialog box, click on the “Font” tab if it is not already selected.
4. Uncheck the “Strikethrough” checkbox.
5. Click “OK” to close the Format Cells dialog box.

This will remove the strikethrough formatting from the selected cells.

Note that this method only works for removing strikethrough that was added manually. If the strikethrough was applied through conditional formatting or another automated method, you may need to use a different method to remove it.

Remove strikethrough added with conditional formatting

To remove strikethrough that was added using conditional formatting in Excel, you can use the following steps:

1. Select the cell(s) that contain the strikethrough formatting.
2. Click on “Conditional Formatting” under the “Home” tab in the ribbon, and select “Clear Rules” from the dropdown menu.
3. In the submenu that appears, select “Clear Rules from Selected Cells”.

This will remove the conditional formatting from the selected cells, including any strikethrough formatting that was applied by the rule.

Note that this method removes all conditional formatting rules from the selected cells, not just the strikethrough formatting.

If you want to keep other conditional formatting rules but remove only the strikethrough, you will need to modify the rule or create a new one that does not include strikethrough formatting.

Related posts:

HLOOKUP Function in Excel Discounted cash flow excel Repeat Last Action in Excel How to change negative number to positive