If you want to apply a strikethrough format only to a part of the text in a cell, then simply get into edit mode, either by double-clicking the cell or pressing the F2 key, then highlighting the desired text or values.From the expanded menu, select either Clear Rules from Selected Cells (to stop applying the rule only for the active and any other highlighted cells), or Clear Rules from Entire Sheet (to remove all conditional formatting rules from the current worksheet).Click the Conditional Formatting dropdown menu from the Home tab.To get rid of the strikethrough format that was applied using a conditional formatting rule, do the following: Remove strikethrough applied through conditional formatting rule
#How to show strikethrough in word how to
Learn how to apply conditional formatting when a checkbox in Excel is checked here. If you have checkboxes on your worksheet and they’ve been linked to cells that track their status, conditional formatting may also be used to further convey the idea of a completed item. Therefore, Excel applied the rule B3=“Y” to cell A3, B4=“Y” to cell A4, and so on.
![how to show strikethrough in word how to show strikethrough in word](https://i0.wp.com/www.supportyourtech.com/wp-content/uploads/2019/07/how-draw-line-through-text-word-3.jpg)
Note that even though all the cells within the range B2 to B10 were highlighted, the formula that was entered used B2 as a relative cell reference.
![how to show strikethrough in word how to show strikethrough in word](https://i.stack.imgur.com/W5a9c.png)
The condition would likely be based on a value entered in another cell, for example, “Y” in the cell adjacent to the task. In cases where the strikethrough formatting is needed to show that a task is completed, we would use the “formula” option to create our conditional formatting rule. The strikethrough format may also be applied to cells that satisfy the conditions of a specified conditional formatting rule. Strikethrough with conditional formatting This will reveal the More Font Options menu, from where you can select Strikethrough. If you’re using Excel for the web and you want the strikethrough format applied to values in a cell, it’s actually available by clicking on the ellipsis (.) next to the other text formatting commands right from the Home menu. A Strikethrough icon will now appear on the QAT, above the ribbon.Scroll down and select the Strikethrough command, and click Add>.From the Quick Access Toolbar option, choose ‘All Commands’ from the dropdown list on the left.Alternatively, right-click on any ribbon tab and select Customize the Ribbon. Right-click on any existing QAT icon and select Customize Quick Access Toolbar.The Quick Access Toolbar (QAT) offers exactly that solution. If the strikethrough format is one you’ll be using frequently, you may want to access it a bit more quickly. Method 3: Add to Quick Access Toolbar (QAT) When you click OK, the selected cell(s) will have the displayed text formatted with the strikethrough effect.
![how to show strikethrough in word how to show strikethrough in word](https://blog.hubspot.com/hs-fs/hubfs/Strike-Through-Text-Example.png)
You will see a preview of the strikethrough format in the Preview section of the window.