How to Remove Strikethrough in Excel

If you are a regular user of Microsoft Excel, you have probably come across the strikethrough feature at some point. While strikethrough can be a useful tool for indicating completed tasks or crossing off items on a list, there may come a time when you need to remove this formatting. Whether you are dealing with a large dataset or simply need to make a change to a few cells, knowing how to remove strikethrough in Excel can save you time and frustration.

Method 1: Remove Strikethrough using the Format Cells Dialogue Box

The format cells dialogue box in Excel offers a simple way to remove strikethrough formatting. Follow these steps:

Step 1:

Select the cells or range of cells from which you want to remove the strikethrough formatting.

Step 2:

Right-click on the selected cells and click ‘Format Cells.’ This will open a dialogue box.

Step 3:

Go to the ‘Font’ tab in the dialogue box and uncheck the ‘Strikethrough’ box.

Step 4:

Click ‘OK’ to remove the strikethrough formatting.

Method 2: Remove Strikethrough using the Ribbon Toolbar

If you prefer to use the ribbon toolbar, follow these steps:

Step 1:

Select the cells or range of cells from which you want to remove the strikethrough formatting.

Step 2:

Go to the ‘Home’ tab in the ribbon toolbar and click the ‘Strikethrough’ button in the ‘Font’ group. This will remove the strikethrough formatting from the selected cells.

Method 3: Use the Clear Formats Tool

If you want to remove all formatting from a cell, including strikethrough, you can use the clear formats tool. Here’s how:

Step 1:

Select the cell or range of cells from which you want to remove all formatting.

Step 2:

Go to the ‘Home’ tab in the ribbon toolbar and click the ‘Clear Formats’ button in the ‘Editing’ group. This will remove all formatting, including strikethrough, from the selected cells.

By following these simple steps, you can easily remove strikethrough formatting from your Excel worksheets.

Why You Might Need to Remove Strikethrough in Excel

Strikethrough can be a useful tool in Excel when working with lists or tasks that need to be marked off as completed. However, there are times when you might need to remove strikethrough formatting. For example, you may have copied data from a source where strikethrough was used for a different purpose, or you may have accidentally applied the formatting to a group of cells. Whatever the reason, knowing how to remove strikethrough in Excel is an essential skill that can help you work more efficiently.

How to Find and Highlight Cells with Strikethrough

If you are working with a large dataset, it can be challenging to locate cells that have strikethrough formatting. Fortunately, Excel provides a simple way to find and highlight these cells. Here’s how:

Step 1:

Select the cells or range of cells you want to search for strikethrough formatting.

Step 2:

Go to the ‘Home’ tab in the ribbon toolbar and click the ‘Conditional Formatting’ button in the ‘Styles’ group.

Step 3:

Select ‘New Rule’ from the dropdown menu.

Step 4:

Choose ‘Use a formula to determine which cells to format.’

Step 5:

In the formula field, enter the following formula: =CELL("strike", A1) (replace A1 with the first cell of the selected range).

Step 6:

Click the ‘Format’ button and choose how you want to highlight the cells with strikethrough formatting. You can choose to fill the cells with color, add a border, or apply other formatting options.

Step 7:

Click ‘OK’ to apply the formatting to the selected cells.

By following these steps, you can quickly find and highlight cells with strikethrough formatting, making it easier to remove the formatting as needed.

Other Formatting Tips and Tricks in Excel

In addition to removing strikethrough formatting, there are many other formatting tools and options in Excel that can help you work more efficiently. For example, you can use conditional formatting to highlight cells based on specific criteria, or you can adjust column widths and row heights to make your data easier to read. By mastering these formatting tools, you can create more professional-looking spreadsheets that are easier to work with.

FAQs about Removing Strikethrough in Excel

Here are some common questions people have about removing strikethrough formatting in Excel:

Can I remove strikethrough from a single cell in Excel?

Yes, you can remove strikethrough formatting from a single cell by selecting the cell and then using the methods outlined in this article. Alternatively, you can use the ‘Clear Formats’ tool to remove all formatting from the cell.

What if I don’t want to remove all formatting from a cell?

If you only want to remove strikethrough formatting from a cell and leave the other formatting intact, you can use the ‘Format Cells’ dialogue box and uncheck only the ‘Strikethrough’ box. This will remove the strikethrough formatting while leaving other formatting options, such as font size and color, intact.

Can I remove strikethrough formatting from an entire worksheet?

Yes, you can remove strikethrough formatting from an entire worksheet by selecting all cells in the worksheet (clicking the box in the top left corner of the worksheet) and then using the methods outlined in this article. Alternatively, you can use the ‘Clear Formats’ tool to remove all formatting from the worksheet.

How do I remove strikethrough formatting from a cell using a formula?

You can remove strikethrough formatting from a cell using a formula by using the SUBSTITUTE function and replacing the strikethrough character with an empty string. For example, if cell A1 contains text with a strikethrough, you can remove the strikethrough by using the formula =SUBSTITUTE(A1,CHAR(127),"").

Can I use a keyboard shortcut to remove strikethrough formatting?

Yes, you can use the keyboard shortcut Ctrl + 5 to apply or remove strikethrough formatting. Simply select the cells you want to modify and press the keyboard shortcut to toggle strikethrough on or off.