Microsoft excel how to strikethrough text

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 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. 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.

Click OK to confirm the format and OK to apply to the selected cell(s).ДЄll text within the highlighted cells will now have the strikethrough format applied.

Check the Strikethrough checkbox in the Effects section.

In the вЂњ Format values where this formula is true:вЂќ field, type =B2=вЂњYвЂќ.

Under Select a Rule Type, choose Use a formula to determine which cells to format.

Click the conditional formatting dropdown from the Home tab and select New Rule.

Select the cell or range of cells to which you want the conditional formatting applied.

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.

You will see a preview of the strikethrough format in the Preview section of the window.

This will open the Format Cells dialog box, from which you can select the Strikethrough checkbox.

Go to the Home tab on the ribbon and click on the Font Settings button within the Font command group.Select the cell(s) which should have the strikethrough format.

If thatвЂ™s one too many shortcuts, and youвЂ™re not willing to memorize it, follow these steps instead:

Microsoft excel how to strikethrough text