Super Formula Bar (easily edit multiple lines of text and formula) Reading Layout (easily read and edit large numbers of cells) Paste to Filtered Range.
Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.
The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by
#HOW TO STRIKETHROUGH TEXT EXCEL HOW TO#
How to remove only text from cells that containing numbers and texts in Excel?.
How to remove numbers from cells which containing texts and numbers in Excel?.
How to remove unwanted text from cell in Excel?.
How to remove text before or after a specific character in Excel?.
Then all texts marked with a strikethrough are removed from cells immediately as below screenshot shown. In the popping up Kutools for Excel dialog box, please select the range contains the strikethrough texts you will remove, and then click the OK button. Press the F5 key or click the Run button to run the code. Set xRg = Application.InputBox("Please select range：", "KuTools For Excel", Selection.Address,, ,, , 8) VBA code: Remove all strikethrough texts from cells Sub DelStrikethroughText() Then copy and paste below VBA code into the Code window. In the Microsoft Visual Basic for Applications window, please click Inset > Module. In the worksheet contains the strikethrough texts you need to remove, press the Alt + F11 keys simultaneously to open the Microsoft Visual Basic for Applications window.Ģ. The below VBA code can help you remove all texts in cells which have been marked with strikethrough. Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!
0 kommentar(er)
