#How to strikethrough text in excel how to

Step 1: Open your spreadsheet in Microsoft Excel 2010. If you instead wish to add the strikethrough effect to some of the cells in your spreadsheet, the this article will show you how. The steps in this article will assume that you have a spreadsheet which contains text with the strikethrough effect, and that you wish to remove that effect. Italics are created using either a single asterisk () or single underscore ().

#How to strikethrough text in excel how to

How to Remove the Line Through Text in Excel 2010 (Guide with Pictures) Answer (1 of 3): Reddit Comment Formatting 1.

Check the box to the left of Strikethrough to remove the check mark.

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

Mark all of the cells in the ROW containing the text you want to strikeout and Click the menu Format -> Conditional formatting. Under Effects, check the box next to Strikethrough. Select the cells containing text you want to strike through. In Excel on the desktop, open a spreadsheet.

Select the cells containing the strikethrough text you wish to remove. Right-click on the checkbox and enter the format window. Select the cells with text you want to strike through.

How to Remove Strikethrough in Excel 2010 Also known as a strikeout, the line through the text tells the reader that the text should be removed. Our tutorial below will show you where to find the strikethrough option so that you can eliminate it from your selected cells. Strikethrough text is a useful tool for editors and anyone collaborating on a document. The effect is not included in the ribbon, however, so you need to use a keyboard shortcut or a secondary menu in order to apply or remove it. I was trying to use a ref cell that is a REF number and Strikethrough text in Cells 1-8 if the ref number is below the ref and Greater than a specific date.

If you are finding the strikethrough effect to be problematic, then you are probably looking for a way to remove it. I have been researching VBA to strike through text in cells when criteria is met. The strikethrough effect in Microsoft Excel 2010 is helpful when you wish to indicate that information in a cell should be ignored, yet you do not want to delete that information.Р”В«ut the strikethrough effect can be distracting, especially when it is used a lot, and the effect remains applied to the information if you copy and paste it into another spreadsheet or document. But if some of your data has a line through it, then you may be looking for a way to remove strikethrough in Excel. Text formatting effects like bold, italic, and underline can be useful when displaying data in Excel.