How To Delete All Strikethrough Text In Excel

11 May, 2021

Hi Charliea Here is a simple VBA macro that should do the trick. Strikethrough is really important if you are working on something like to do list.

How To Strikethrough In Excel Shortcut Button And Conditional Formatting

Tools - Macros - Visual Basic Editor.

How to delete all strikethrough text in excel. Press Ctrl 5 again and the formatting will be removed. Check the box to. Like most useful functions Excel has a keyboard shortcut for strikethrough as well as many other functionalities.

Press the Ctrl 5keyboard shortcut. Sub DelStrikethroughText Deletes strikethrough text in all selected cells Dim Cell As Range For Each Cell In RangeRangeA1 SelectionSpecialCellsxlLastCell DelStrikethroughs Cell Next End Sub Sub DelStrikethroughsCell As Range deletes all strikethrough text in the Cell Dim NewText As String Dim iCh As Integer For iCh 1 To LenCell With CellCharactersiCh 1 If. We often need this but it hard to use if you dont know where to find it i.

When the user changes the value of a drop down list in row 2 to true a strikethrough will be added to the font in row 1. Use strikethrough command in the Font dialog box Select the text you want to cross out. If strikethrough is added by a conditional formatting rule then you need to remove that rule to get rid of strikethrough.

Right click on the selected cells and select Delete from the context menu. Make sure to do this inside the result found All cells with Strikethrough the 9 cells found are being selected Close the Find dialogue box. Visual Basic CodeSub DelStrikethroughText Deletes strikethrough text in all selected cells Dim Cell As Range For Each Cell In Selection DelS.

Remove strikethrough added with conditional formatting. 2 In the VBE use the Insert. Press CTRL A the shortcut for Select ALL.

Now all selected cells are added strikethrough. If you want to remove strikethrough select the cells with strikethrough go to the Format Cells dialog and uncheck the Strikethrough option. If you would like to remove all of the strikethrough from your spreadsheet click the cell above the row 1 heading and to the left of the column A heading.

Use Find and Replace and click the More button and then with the selection in the Find what control click on Format and then on Font and check the box for Strikethrough and then back in the Find and Replace dialog click on Replace All. When the user changes the value of the drop down list back to No the strikethrough will be removed from the cell in row 1. I would like to only delete those character that are Strikethrough and keeping the other non-Strikethrough character in those cells.

There is no need to enter anything in the the Find what and Replace with Controls. Click Close button. Select any cells which you want to remove the formatting from and you can use any of these methods.

Select the cells containing the strikethrough text that you wish to remove. Wondering how excel text is removed non required text box to remove texts itself in excel also removes extra spaces apart from a supplied text box. Click OK to close dialog.

Uncheck the Strikethroughoption in the Format Cellsmenu. To later remove the crossed out text effect simply reapply the strikethrough command to your text or select your text and hit Ctrl Spacebar on your keyboard to wipe out the text formatting. In the Format Cells dialog under Font tab check Strikethrough option in the Effects section.

Removing any strikethrough format in your text is just as easy as applying it. Pay attention not to click on any cell on the worksheet otherwise the selection may change To Hide the rows with cells selected simply press CTRL 9. To have it done select all the cells from which you want to remove strikethrough go to the Home tab Styles group and click Conditional Formatting Clear Rules Clear Rules from Selected Cells.

Simply select the cells you want to remove the. And all cells with Strikethrough are being selected. 1 Go to the Visual Basic Editor VBE using the menu.

Font button at the bottom-right corner of the Font section in the ribbon. Click the Home tab. Click the Format Cells.

Some cells consist of both Strikethrough and normal characters. I have around 1000 rows of data. Please try again later on my email address will remove the file in removing the cells in the specified character from the texts but to replace.

Example in a cell. You can also use Clear formatting to remove it but remember that it will remove all the other formatting as well. Sub DeleteCells Dim cel As Range Dim ws As Worksheet Dim lastRow As Long For Each ws In ActiveWorkbookWorksheets loop through all sheets With ws lastRow Cells RowsCount CEnd xlUpRow get last row with data using Column C For Each cel InRange C1M lastRow loop through all cells in range If celFontStrikethrough Then check if cell has strikethrough property celClear make cell blank and remove strikethrough.

Open your spreadsheet in Excel 2013. The rest of the cell should also be left untouched. Private Sub worksheet_change ByVal target As Range Dim i As Integer.

Just select the cells that have the strikethrough formatting that you want to remove and click on the strikethrough option in the toolbar or in the Format option in the menu. And select Entire row radio button. How to Remove Strikethrough in Excel 2010 Select the cells containing the strikethrough text you wish to remove.

Press those two buttons and the selected cells will have strikethrough applied. Its Ctrl 5.

How To Strikethrough In Excel Shortcut Button And Conditional Formatting